ruhi

You can use FLASHBACK TABLE to retrieve your rows. But before that you must enable row movement by following query [CODE] ALTER TABLE hr.employees ENABLE ROW MOVEMENT; [/CODE] And there after firing the below query for the particular timestamp when your rows were existing at that time. [CODE] FLASHBACK TABLE …

You should define alias to column name also. Which column belongs to which table. It will solve your error. For eg SELECT D.DEPTNO AS DNO, D.DNAME AS DNAME.. Like wise..

You can also use [CODE]SELECT * FROM SENTMAIL WHERE to_char(SENTMAIL_SENT_DATE, 'fmDD-MON-YYYY')='01-OCT-2011'[/CODE]

You can use group by function in select query..

Hi, I have three dropdownlist: country, state and city. Based on the selection of country the data of state will be filtered and similarly depending on the selection of state , the items of the city will be filtered. That is working fine. Now there is one gridview which contains …

Hi everyone, How to use session value during fetching values from database of that particular session value? [code] SqlDataAdapter adapterprice = new SqlDataAdapter("SELECT product.productid, product.productname, product.price, product.description FROM product where product.productid= Session["productid"] ", myconnection); [/code] During writing code in such a way it is showing error.. Can any one help …

sorryy..

Hi all, Can any one tell me how to use a value generated through a button click event in another button click event in the same page.Is viewstate is helpful? If yes then how? -ruhi

hi archanha, Can i know what error message u r getting during clicking edit,clear and all such buttons? May be the software is not properly installed or change in files.. occured which can create such problems...

hi, if your table have one row and it contains five cell and you want value of 3rd cell then lets say The row ID is 'row2' then you can write [code] var a = document.getElementById('row2'); var b = a.cells[2].innerHTML; [/code] there by you can get value through b.

hello everyone, how to write exit code in visual studio.Net so that whole program closes on button click event? And how Message box is created, also how to take input from user as we do in javascript using prompt command? Can anyone help me in this..... Thanx in advance.

hello everyone, i m trying to add row in database through this code: [COLOR=green]Private[/COLOR][COLOR=green]Sub[/COLOR][COLOR=green] btnadd_Click([/COLOR][COLOR=green]ByVal[/COLOR][COLOR=green] sender [/COLOR][COLOR=green]As[/COLOR][COLOR=green] System.Object, [/COLOR][COLOR=green]ByVal[/COLOR][COLOR=green] e [/COLOR][COLOR=green]As[/COLOR][COLOR=green] System.EventArgs) [/COLOR][COLOR=green]Handles[/COLOR][COLOR=green] btnadd.Click[/COLOR] [COLOR=green]Dim[/COLOR] rowNew [COLOR=green]As[/COLOR] System.Data.DataRow = DataSet31.Tables(0).NewRow [COLOR=green]Dim[/COLOR] temp [COLOR=green]As[/COLOR] Random rowNew.Item(4) = temp Response.Write(rowNew.Item(4)) '** DataSet31.Tables(0).Rows.Add(rowNew) DataGrid1.EditItemIndex = DataGrid1.Items.Count DataGrid1.DataSource = DataSet31 DataGrid1.DataBind() [COLOR=green]End[/COLOR] [COLOR=green]Sub[/COLOR] [COLOR=green]but …