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.

StackExchange Database Administrators Q#112659, answer score: 4