how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
Answer Posted / uma
select * from (select rownum rn,ename,job,sal
from emp)
where mod(rn,2) <> 0;
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How many numbers of sessions can one group in batches?
What do you understand by SOA of Informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
What are the types of lookup transformation?
What are the components of the workflow manager?
Clarify the utilization of aggregator cache record?
What is dimensional table?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is the Process to creating lookup transformation in informatica
tell me the rules and responsblites in our project(my project is development)
What is the use of target designer?
Explain pushdown optimization and types in informatica
In informatics server which files are created during the session rums?
How do you update the records with or without using update strategy?