How to generate DDL scripts for COMMENTS on TABLES and COLUMNS?
508936Nov 8 2006 — edited Nov 9 2006Hi,
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