how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
Answer Posted / siva reddy
display odd records
select * from emp where (rowid,1) in ( select
rowid,mod(rownum,2) from emp)
display even records
select * from emp where (rowid,0) in ( select
rowid,mod(rownum,2) from emp)
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
How to do the error handling of if ur source is flatfiles?
What is resilience time?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What you know about transaction control transformation?
What do you mean by filter transformation?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are the static cache and dynamic cache in informatica?
Define mapplet?
What is data caches/ index caches?
explain about unit testing? in real time?
What are the different types of transformation available in informatica.
What is deployment group?
Explian the Process of deployment groups in informatica
Different sorts of metadata that stores in the storage facility?
Explain the features of connected and unconnected lookup.