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 / pooja
CREATE TABLE B
AS
SELECT *
FROM
(SELECT *
FROM
(SELECT *,ROWNUM R
FROM A)
ORDER BY R DESC)
WHERE R=1;
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What does role playing dimension mean?
What is meant by a domain?
can anyone suggest best free Talend data integration training online
How can you differentiate between powercenter and power map?
have u done any performance tuning? how u ll do?
How many dimensions are there in informatica?
Explain what are the different types of transformation available in informatica.
What is rank transformation in informatica
What is the difference between a connected look up and unconnected lookup?
draw informatica architecture 8.6 ?
How to convert multiple rows to single row (multiple columns) in informatica
Which are the different editions of informatica powercenter that are available?
What is meant by pre and post session shell command?
Clarify the aggregator change?