What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / ram
1. nth highest salary
-> select *from emp e where &n =(select count(distinct sal)
from emp m where e.sal <= m.sal);
2. -> Cursor.
When a query is executed in oracle, a result set is
produced and stored in the memory. Oracle allows the
programmer to access this result set in the memory through
cursors.
use a cursor?
Many times, when a query returns more than one row as a
result, we might want to go through each row and process
the data in different way for them. Cursor is handy here.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between a data warehouse and a data mart?
Do you find any difficulty while working with flat files as source and target?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
In warehouses how many schemas are there?
How to create the source and target database connections in server manager?
What is rank transform?
What is the procedure for creating independent data marts from informatica 7.1?
Can we get 1st record through Informatica(without sequence number).
Explain joiner transformation in informatica
As union transformation gives UNION ALL output, how you will get the UNION output?
Explain the aggregator transformation?
what is unit testing?tell me proceedure
where to store informatica rejected data?
Explain transaction control transformation in informatica
How does a sorter cache works?