missing ';' from the ddl
J1604Oct 13 2010 — edited Oct 14 2010Dear all,
I am running below query to get the ddl for a table using dbms_metadata package.
query:
SELECT dbms_metadata.get_ddl(replace(OBJECT_TYPE, ' ', '_'), OBJECT_NAME,OWNER)
FROM DBA_OBJECTS
WHERE OBJECT_TYPE in ('SEQUENCE',
'PROCEDURE',
'DATABASE LINK',
'PACKAGE',
'PACKAGE BODY',
'MATERIALIZED VIEW',
'TABLE',
'INDEX',
'VIEW',
'FUNCTION')
AND OWNER = 'AI_ADM'
AND OBJECT_NAME LIKE 'TEST_EXPORT_DDL' ;
returns the DDL correctly but missing ';' at the end but when I run the same query on sql developer I get ';' at the end why ?
Any suggestion would be helpful,
Thanks,
J