DBMS_METADATA.GET_DDL not displaying complete DDL for big tables While generating the DDL for a schema, big tables' DDL are getting truncated. After displaying close to 110 rows I am getting an ellipsis (...).

I am using SQL developer to run:

SELECT dbms_metadata.get_ddl('TABLE',TABLE_NAME,OWNER)
FROM DBA_TABLES
WHERE OWNER = 'XYZ'
Just set the "long" in the sql sheet window big enough to hold the desired ddl. 

Example:

set long 1000
select dbms_metadata.get_ddl('TABLE', 'XP','OPS$RM74384') from dual;


-- Then just hit Run Script button or press f5.