Home » SQL & PL/SQL » SQL & PL/SQL » How to get the last table created by the user
How to get the last table created by the user [message #6809] Wed, 07 May 2003 00:21 Go to next message
shawlin
Messages: 25
Registered: April 2003
Junior Member
How to get the last table created by the user.

thanks
shawlin
Re: How to get the last table created by the user [message #6812 is a reply to message #6809] Wed, 07 May 2003 00:39 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
select *
  from dba_objects
 where owner = :owner
   and object_type = 'TABLE'
   and created = (select max(created)
                    from dba_objects
                   where owner = :owner
                     and object_type = 'TABLE');
Previous Topic: Trigger Question
Next Topic: field name stored in variables-urgent
Goto Forum:
  


Current Time: Thu Mar 28 17:47:25 CDT 2024