Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to generate DDL scripts for COMMENTS on TABLES and COLUMNS?

508936Nov 8 2006 — edited Nov 9 2006
Hi,

I am able to generate DDL scripts for database.
select dbms_metadata.get_ddl(object_type,object_name) DDL from user_objects
object_type where
object_type not in('PACKAGE','PROCEDURE','FUNCTION','INDEX','TRIGGER','SYNONYM','SEQUENCE','VIEW',
'PACKAGE BODY','LOB','JAVA CLASS','JAVA SOURCE') order by object_type;


How to generate DDL scripts for COMMENTS on TABLES and COLUMNS?

regards,
mathew
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2006
Added on Nov 8 2006
5 comments
6,539 views