i have oracle table A and target B. i don't know how many
records. i want get get last record in table A as first record
in target table B. write a sql query?
Answer Posted / upendra
select * from (select rownum as num,a.* from A a) where num=(select count(*) from A);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between informatica 7.0 and 8.0?
What is the fact table?
What do you mean by channel change?
Explain Dataware house architecture .how data flow from intial to end?
What is the benefit of partitioning a session?
What is the Process to creating lookup transformation in informatica
Can we create two repositories on same database instance in oracle?
How can you define user defied event?
What is depict expression change?
Explain what are the different versions of informatica?
What is rank transformation in informatica
How to extract sap data using informatica? What is abap? What are idocs?
What is a repository? And how to add it in an informatica client?
How big was your fact table
What is the need for an etl tool?