how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
Answer Posted / kondeti srinivas
Select * from (select rownum as rn, emp.* from emp) where
rn in (1,3,5);
| Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
my source is junk data how will u remove that junk data by using unix please any one replay me
What are the different lookup cache(s)?
How does the aggregator transformation handle null values?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
In informatica workflow manager, how many repositories can be created?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How to create the source and target database connections in server manager?
What is status code in informatica?
Define joiner transformation?
Explain target update override in informatica
What is a rank transform?
What is Cognos script editor?
What is domain in terms of informatica?
Is it possible to create multiple domains on a single Informatica server?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?