Explain do view contain data?
What is an Index ?
What is flashback in Oracle?
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
what are pseudocolumns?
What is the oracle implicit cursor?
what is Single Byte Overhead...?
what is the use of composite key constraint?
Why cursor variables are easier to use than cursors?
Explain integrity constraint?
How a tablespace is related to data files?
Explain mutating triggers.
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.