how do u get the first record from 50,000 records ?
Answer Posted / amedela chandra sekhar
Select * from(select rownum as rno,emp.* from emp) where rno=&n
EX:
SQL> Select * from(select rownum as rno,emp.* from emp) where rno=&n;
Enter value for n: 1
old 1: Select * from(select rownum as rno,emp.* from emp) where rno=&n
new 1: Select * from(select rownum as rno,emp.* from emp) where rno=1
RNO EMPNO ENAME JOB MGR HIREDATE SAL
---------- ---------- ---------- --------- ---------- --------- ----------
COMM DEPTNO
---------- ----------
1 7369 SMITH CLERK 7902 17-DEC-80 800
20
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the sql query overwrite in source qualifier in informatica
What is main use of mapplet?
What is the meaning of up gradation of repository?
Explain sessions and how many types of sessions are there?
Quickly characterize reusable change?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is the difference between router and filter?
What is informatica? Why do we need it?
Enlist the tasks for which source qualifier transformation is used.
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Scheduling properties,whats the default (sequential)
What all join we can perform in LOOKUP transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is the benefit of partitioning a session?