Returns DDL for named object
Returns DDL for named object where catalog_name is the name of the current catalog, schema_name is the name of the current schema and table_name is the name of the table or view for which you want to generate DDL.
Version 5.2 Feature
As of version 5.2, you no longer need to use the preface SYS_BOOT.MGMT.
SELECT * FROM TABLE(SYS_BOOT.MGMT.GET_OBJECT_DDL('LOCALDB', 'SALES', 'BIDS'));
'0','CREATE OR REPLACE STREAM BIDS (