Interested to Buy Any Domain ? << Click Here >> for more details...
What is the query to find nth highest salary?
What is the use of cursors?
- 8 Answers
- 21399 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
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
How can we remove the duplicates from flat file source?
What are active and passive transformations?
Sequence generator, when you move from develoment to production how will you reset
What is resilience time?
Can we create two repositories on same database instance in oracle?
Mention some types of transformation?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is union transformation?
What is domain and gateway node?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the difference between informatica 7.0 and 8.0?
How to use procedural logic inside infromatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the new features of informatica 9.x developer?
Whats there in global repository
