Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve data from an cursor to a record?
- 0 Answers
- 1097 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
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 many types of tables supported by oracle?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
When do you get a .pll extension in oracle? Explain its importance
What is COST-based approach to optimization ?
Explain an index segment?
what r tyhe major differences between oracle 9i & 10g?
How to define an oracle cursor variable?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What is a sub query? What are its various types?
Explain about the analyze command in oracle?
How many memory layers are in the shared pool?
Oracle General 
