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

What is flashback table ? Advance thanks

1872

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2208

Tell me about Propagate functions in informatica

874

What is complex mapping?

1068

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

998

What is dynamic cache?

967

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1995

On which transformations you created partitions in your project?

1250

what is song in infrmatica...?

2161

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1027

What is the reusable transformation?

1006

In informatics server which files are created during the session rums?

1063

How can we store previous session logs?

989

How many ways are there to create ports?

1234

How to start a workflow using pmcmd command?

1174