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

Define update strategy?

1239

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2154

Explain the shared cache and re-cache?

1128

Quickly characterize reusable change?

1131

Can we get 1st record through Informatica(without sequence number).

1491

Explain the scenario which compels informatica server to reject files?

1174

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?

1520

Enterprise data warehouse your projects phase by phase explain?

1933

How to do unit testing in informatica?

1190

Explain informatica architecture - version 8 / 9

1103

What is the difference between informatica 7.0 and 8.0?

1020

Under what condition selecting sorted input in aggregator may fail the session?

1132

what is index?how it can work in informatica

2048

Write the unconnected lookup syntax and how to return more than one column.

1120

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2355