how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
Answer Posted / jhansi
It displays odd rows
select * from emp where (rowid,0) in(select rowid,mod
(rownum,2) from emp);
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
I have a flat file, want to reverse the contents of the flat file
Clarify the utilization of aggregator cache record?
What differs when we choose the sorted input for aggregator transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Informatica settings are available in which file?
Target increases every day even though no new record was inserted
what is mean by complex business rule ?
Explain sessions?
What is the use of transformation?
How we can create indexes after completing the load process?
How does a rank transform differ from aggregator transform functions max and min?
What is informatica? Why do we need it?
What are the types of lookup transformation?
What are the different types of transformation available in informatica.