From the database level, how can you tell under which time
zone a database is operating?
What is a sub query? What are its various types?
How to build data dictionary view an new database?
How do we represent comments in oracle?
How would you change old and new values in an insert, delete and update triggers?
Differnce between view and index
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.
What is forall Statement ?
what are the diffeenes between oracle 9i,oracle 10g
Explain the difference between a procedure and a function? What do you understand by those terms?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
What is the string concatenation operator in oracle?
What is a system tablespace?