SQL statement to get DDL statement of Table

We can get DDL statement used to create any able by using dbms_metadata package.

For example , we can get table creation DDL statement for ap_invoices_all table by running below query.

select dbms_metadata.get_ddl('TABLE','AP_INVOICES_ALL','AP') from dual;