Skip to Main Content

SQL & PL/SQL

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!

missing ';' from the ddl

J1604Oct 13 2010 — edited Oct 14 2010
Dear 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
This post has been answered by Solomon Yakobson on Oct 13 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 11 2010
Added on Oct 13 2010
7 comments
297 views