Explain the use of indexes option in imp command.
What are the differences between date and timestamp in oracle?
How to update values on multiple rows in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
what is the use of system.effective.date variable in oracle?
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
What are the different approaches used by Optimizer in choosing an execution plan ?
Display the records between two range?
How to recover a dropped index?
sql query to get zero records from a table
what is integrity constrains?
What is an oracle and why it is used?
How would you change old and new values in an insert, delete and update triggers?