meta

-- Table DDL including constraints
SET LONG 100000
SELECT DBMS_METADATA.GET_DDL('TABLE','ZORDERDETAIL') FROM DUAL;

-- Indexes DDL
SELECT DBMS_METADATA.GET_DDL('INDEX', index_name)
FROM user_indexes
WHERE table_name = 'ZORDERDETAIL';

-- Grants
SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','ZORDERDETAIL') FROM DUAL;