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

Is it possible to revert a global repository to local one and why?

1140

Explain the types of transformations?

1106

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10329

What is informatica metadata and where is it stored?

1047

complex mapping ur project u r invlve can u explain and give real time example give me ?

2353

What is Index Caches size?

1165

Explain what is informatica metadata and where is it stored?

1113

What if the source is a flat-file?

1170

How to generate sequence numbers?

1137

What is the surrogate key?

1367

Implementation methodology

1776

Where do we use mapping variables in informatica?

1123

Explain the different kinds of facts.

1026

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1994

What is the benefit of session partitioning?

1160