Team,
Let us assume we are using SCOTT schema and as usual we have tables my table emp, dept,salgrade etc tables. But lets assume we have a column by name date_created in all the tables. i would like to get the table name along with the max date_created column from the corresponding table. I have tried like this:
{code}
Select Table_Name ,
(Select Max(Date_Created) From (Select Table_Name From user_tables Where Table_Name = Ut.Table_Name)) As Max_Date_Created
from user_tables ut
{code}
but it does not work.
Any suggestions most welcome.
REgards