dbms_metadata.get_ddl ('TABLE,'EMP','SCOTT' ) from dual
dbms_metadata.get_ddl ('INDEX,'INDEX_NAME','USERNAME' ) from dual
tolywang
2006-09-18 00:00:00dbms_metadata.get_ddl ('TABLE,'EMP','SCOTT' ) from dual
dbms_metadata.get_ddl ('INDEX,'INDEX_NAME','USERNAME' ) from dual