How to generate the DLL for a table or a view from sqlplus, useful if you’ve not got a GUI tool.
So as the schema owner connect and run the following, in this example the table is called TEST_TABLE
set long 1000
select DBMS_METADATA.GET_DDL(‘TABLE’,’TEST_TABLE’) from dual;
output
view example
set long 1000
select DBMS_METADATA.GET_DDL(‘VIEW’,’TEST_VIEW’)from dual;
output