CREATE TABLE B AS SELECT * FROM A ORDER BY ROWNUM DESC;

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?

Question Posted / devi

7 Answers
10821 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

Please Help Members By Posting Answers For Below Questions

Tell me about Propagate functions in informatica

915

What is informatica? Why do we need it?

1088

Do you find any difficulty while working with flat files as source and target?

1092

What are the features of complex mapping?

1151

What are the advantages of informatica?

1005

without table how to come first record only in oracle?

2244

What is informatica worklet?

1056

What is the Rank index port in Rank transformation?

1051

What is a sequence generator transformation?

1010

hi real timers . iam waiting for ur reply regarding ETL TESTING

2263

How to update a particular record in target with out running whole workflow?

1569

How would you join a node to the already existing domain?

1119

What does role playing dimension mean?

1040

What is joiner change?

1142

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. ?

2026