Get DDL for Oracle object

set feed off

set long 1000000

set longchunksize 1000000

set pages 0

set lines 32767

set trimspool on

set feed off

set wrap on

set serveroutput on format wrapped

set def off

set tab off

exec dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'SQLTERMINATOR', TRUE);

select dbms_metadata.get_ddl('<TYPE>', '<NAME>', '<OWNER>') from dual;

-- Example:

select dbms_metadata.get_ddl('INDEX', 'XLA_AE_HEADERS_N1', 'XLA') from dual;