Hey all!
Issues when formatting output for DBMS_GET_DDL on SQLPlus? Me too!
Check below the best way to format it. Add to your scripts!
set long 20000 longchunksize 20000 pagesize 0 linesize 1000 feedback off verify off trimspool on column ddl format a1000 begin dbms_metadata.set_transform_param (dbms_metadata.session_transform, 'SQLTERMINATOR', true); dbms_metadata.set_transform_param (dbms_metadata.session_transform, 'PRETTY', true); end; / -- Now you command: select dbms_get_ddl.xxx(..) as ddl from dual;
Hope you enjoy!
Cheers!