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