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

Explain transaction control transformation in informatica

1222

How to load a Dimension ? and how to load a fact table?

1380

What is rank transformation?

943

What the difference is between a database, a data warehouse and a data mart?

1097

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1525

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1456

What are multi-group transformations?

1029

differences between service based and product based?

1979

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

2246

What is decode in informatica?

1088

How can informatica be used for an organization?

1145

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2086

What are the differences between joiner transformation and source qualifier transformation?

1110

4 yrs etl devloper roles and responsibilities?any body give solutions

2094

What are the data movement modes in informatica?

1093