how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
- 16 Answers
- 22017 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / anjan
select rownum,empno,ename,sal from (select
rownum,empno,ename,sal from emp)
group by rownum,empno,ename,sal
having rownum in (1,3,5)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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,
What is a code page?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Plz can any one say me how to get the informatica certification materials and dumps
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Please let me know how to make encryption and decryption with example?
What is data movement mode in Informatica and difference between them?
What is the Process to creating lookup transformation in informatica
What is repository manager?
Differentiate between Load Manager and DTM?
What is an Integration service in Informatica?
What is the use of target designer?
How would you copy the content of one repository to another repository?
where to store informatica rejected data?
Enlist some properties of sessions.
