how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
Answer Posted / amedela chandra sekhar
Select * from (select rownum as rno, emp.* from emp) where
rno in (1,2,5);
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Suppose we do not group by on any ports of the aggregator what will be the output?
Tell me about MD5 functions in informatica
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is a code page?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the different components of powercenter?
How many numbers of sessions can one group in batches?
How to load data in informatica ?
What are the features of complex mapping?
What is a connected transformation?
permutations of mapplet
Explain the types of transformations?
What you know about transaction control transformation?
How we can create indexes after completing the loan process?
What is aggregator transformation in informatica?