Select * From Table A Where ROWID = (Select Max(ROWID) From Table A Union

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 / mr lee

7 Answers
10831 Views
IBM, TCS, I also Faced
E-Mail Answers

Answer Posted / mr lee

Select * From Table A Where ROWID = (Select Max(ROWID) From
Table A
Union
Select * From Table B Where Rownum = 1

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is index?how it can work in informatica

2036

How to partition the Session?

1105

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1150

what is the complex transformation you used in informatica

2585

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7177

How can you validate all mappings in the repository simultaneously?

1361

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

1112

Explain joiner transformation in informatica

1121

How to create Target definition for flat files?

1211

What are the reusable transformations?

1154

What is an aggregator transformation?

1096

What are the different ways to implement parallel processing in informatica?

1418

What is mapping debugger?

1006

How to elaborate tracing level?

1168

Which version configuration tool used in ur project?

3247