How to find the last record of each tables in a schema - oracle database
Posted on 2011-10-28
can you tell me, how to find the last records of every tables in schema, as a single list
Table 1 - rsult1
Table 2 - rsult2
Table 3 - rsult3
I am writing query like this,
SELECT ADDRESS_RN, UPDATED
WHERE ADDRESS_RN =(SELECT MAX(ADDRESS_RN) FROM MAISY.ADDRESS)
SELECT ALERTG_RN , LAST_UPDATED
WHERE ALERTG_RN =(SELECT MAX(ALERTG_RN) FROM MAISY.ALERTG)
WHERE ALERTGU_RN =(SELECT MAX(ALERTGU_RN) FROM MAISY.ALERTGU)
but I do not know, how to integrate results a single list, through one sql script or function in ORACLE 9I.
the tables do not have any common column, but their primary key is TableName_RN.