select dbms_metadata.get_ddl('TABLE', 'the_table_name', 'the_schema_name') from dual
Replace “the_table_name” and “the_schema_name” with yours.
See also:
How to generate a CREATE TABLE statement for a given table in SQL Server
How to generate a CREATE TABLE statement for a given table in Mysql
How to generate a CREATE TABLE statement for a given table in SQLite
Some Oracle tools you can try: https://www.withdata.com/oracle/
Convert your data online, free
Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.
