Oracle Study Guide

set pages 0
set long 999999
select dbms_metadata.get_ddl(’TABLE’, ‘EMP’, ‘SCOTT’) from dual;

NOTE: all of the parameters must be uppercase or the query will fail.