Home » SQL & PL/SQL » SQL & PL/SQL » Getting STATMENT CODE OF A TABLE
Getting STATMENT CODE OF A TABLE [message #199461] Tue, 24 October 2006 09:32 Go to next message
Rinus277
Messages: 2
Registered: October 2006
Junior Member
Hi all,
i'm creating a procedure for keeping aligned two user of a same instance.
I Would like to know if there is a system's table which contains the code of the tables. [CREATE TABLE mytable (......) ]

Thanks
Rin
Re: Getting STATMENT CODE OF A TABLE [message #199462 is a reply to message #199461] Tue, 24 October 2006 09:35 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
DBMS_METADATA.GET_DDL
Re: Getting STATMENT CODE OF A TABLE [message #199465 is a reply to message #199462] Tue, 24 October 2006 10:11 Go to previous messageGo to next message
Rinus277
Messages: 2
Registered: October 2006
Junior Member
Thanks a lot!
Re: Getting STATMENT CODE OF A TABLE [message #199473 is a reply to message #199461] Tue, 24 October 2006 11:11 Go to previous message
rikfair
Messages: 22
Registered: October 2006
Location: UK
Junior Member
Hi
The following article may be of some help to you. It uses a procedure to output all the schema objects by type using DBMS_METADATA.

http://www.astral-consultancy.co.uk/cgi-bin/hunbug/doco.cgi?11300

Razz
Previous Topic: regarding query grouping
Next Topic: Designing tables and queries for performance
Goto Forum:
  


Current Time: Sun Dec 11 00:15:37 CST 2016

Total time taken to generate the page: 0.05346 seconds