How to create a temporary table in oracle?
What is meant by recursive hints ?
What is a view and how is it different from a table?
what diffrence between function and procedure?
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
How to resolve the ORA-39133 error in Oracle?
Please explain drop constraint oracle?
What types of joins are used in writing subqueries?
Explain about integrity constraint?
Explain the use of show option in imp command.
What are the numeric comparison operations?
List out the difference between commit, rollback, and savepoint?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process