Oracle’s equivalent for MySQL SHOW CREATE TABLE

SQL> set pages 0 SQL> set long 999999 SQL> select dbms_metadata.get_ddl('TABLE', 'EMPLOYEES', 'EMP') from dual;