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?
- 7 Answers
- 8721 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / devi
CREATE TABLE B
AS
SELECT * FROM A
ORDER BY ROWNUM DESC;
| Is This Answer Correct ? | 26 Yes | 4 No |
Post New Answer View All Answers
What are the tasks that source qualifier perform?
design of staging area?
How to load the data from people soft hrm to people soft erm using informatica?
Did u used latest transformations of 8.6.0? for what?
Does an informatica transformation support only aggregate expressions?
How to update or delete the rows in a target, which do not have key fields?
Differentiate between source qualifier and filter transformation?
How do you load only null records into target?
What is a rank transform?
What is blocking transformation?
What is Data Caches size?
Briefly define a session task?
can anyone suggest best free Talend data integration training online
How to extract sap data using informatica? What is abap? What are idocs?
scenario where i can use only concurrent execution of workflow.
