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
- 20954 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
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Is there any way to read the ms excel datas directly into informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What all are steps in up gradation of Informatica server?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How to load the data from people soft hrm to people soft erm using informatica?
What are the new features of informatica 9.x in developer level?
How are the sources and targets definitions imported in informatica designer?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is the commit type if you have a transaction control transformation in the mapping?
What is decode in informatica?
What is joiner transformation?
