|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : If you want to delete rows with given DATE
DELETE FROM TABLE_NAME WHERE DATE_COLUMN = GIVEN DATE;
If you want to delete rows >= given DATE
DELETE FROM TABLE_NAME WHERE DATE_COLUMN >= GIVEN DATE;
If you want to delete rows ... 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) 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 : you can write an after insert trigger to maintain the audit of that table. ... Read Answers (1) | Asked by : vijay How do you find the users who are running the script ? Latest Answer : Use v$session view. ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
