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