Latest Answer : SQL> create table m( n number);Table created. 1* insert into m values(&1)SQL> /Enter value for 1: 1old 1: insert into m values(&1)new 1: insert into m values(1)1 row created.SQL> /Enter value for 1: 2old ...
There is a field of type character in the table, but we are storing numeric values like (Roll number) in this field, so if we want to sort the field (in java) according to numbers.How?
by creating a function for sorting in the front end(guessing, i am not sure. plz answer it)
Latest Answer : it can be inserted using insert statement :="insert into R1 values('"&A2&"','"&B2&"','"&C2&"','"&D2&"','"&E2&"','"&F2&"','"&G2&"',"&H2&",'"&I2&"','"&J2&"','"&K2&"','"&L2&"','"&M2&"',"&N2&","&O2&",to_char("&P2&",mm/dd/yy);"into ...
Latest Answer : Through Dataconnections. ...
I am running a queue handler process which polls oracle table at a particular frequency. After some 'n' number of polls oracle drops connection, where n is very large integer value. Can any one reason out, why oracle drops the connection.
Latest Answer : Most simple way is to write an Insert trigger on the table which you want to get audited. ...
Please explain about Mutation error in database trigger in oracle with an example
Latest Answer : This error occurs when you try to select rows from a table and try to update the rows of the same table. Most developers face this problem. To avoid getting this error, create views, select the rows from the views, and then try ...
How do you find the users who are running the script ?
Latest Answer : Use v$session view. ...
