Oracle show create table

select dbms_metadata.get_ddl('TABLE','table_name','db_name') from dual;
select dbms_metadata.get_ddl('INDEX','index_name','db_name') from dual;