<div>
I would probably do it with straight SQL:<br />
select dbms_metadata.get_ddl('TAB<wbr />LE','YOUR_<wbr />TABLE_NAME<wbr />') from dual;<br />
<br />
<a href="https://docs.oracle.com/database/122/ARPLS/DBMS_METADATA.htm#GUID-A4683EEE-6F54-4081-B7BF-1496096675FA" rel="ugc">https://docs.oracle.com/database/122/ARPLS/DBMS_METADATA.htm#GUID-A4683EEE-6F54-4081-B7BF-1496096675FA</a><br />
<br />
If you want the SQL Developer way:<br />
<a href="http://www.oracle.com/technetwork/developer-tools/sql-developer/export-intro-1-161239.html" rel="ugc">http://www.oracle.com/technetwork/developer-tools/sql-developer/export-intro-1-161239.html</a>
</div>


I would probably do it with straight SQL:
select dbms_metadata.get_ddl('TABLE','YOUR_TABLE_NAME') from dual;

https://docs.oracle.com/database/122/ARPLS/DBMS_METADATA.htm#GUID-A4683EEE-6F54-4081-B7BF-1496096675FA [https://docs.oracle.com/database/122/ARPLS/DBMS_METADATA.htm#GUID-A4683EEE-6F54-4081-B7BF-1496096675FA]

If you want the SQL Developer way:
http://www.oracle.com/technetwork/developer-tools/sql-developer/export-intro-1-161239.html [http://www.oracle.com/technetwork/developer-tools/sql-developer/export-intro-1-161239.html]

<div>
<div class="content wysiwyg-content">
In Oracle Sql developer, how do you script out a table definition, so that when you want to create the table in another database, you don't have to create the table manually?
</div>
</div>


In Oracle Sql developer, how do you script out a table definition, so that when you want to create the table in another database, you don't have to create the table manually?

How to script out a table definition in Oracle Sql developer

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.