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
10866 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

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6181

What is a joiner transformation and why it is an active one?

1083

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

2271

What does cheating measurement mean?

1063

What all join we can perform in LOOKUP transformation?

978

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3871

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1322

How to load last n records of file into target table - informatica

1082

How you can differentiate between connected lookup and unconnected lookup?

1063

Mention few power centre client applications with their basic purpose?

951

Why union transformation is an active transformation?

1048

How is union transformation utilized?

1009

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1076

How to do unit testing in informatica?

1173

What is depict expression change?

1121