How to get the DDL of an Oracle table

This is just one of many ways you can get a the DDL of a table in Oracle:
select dbms_metadata.get_ddl('TABLE', 'YOUR_TABLE'.'YOUR_SCHEMA') from dual;

Comments

Popular posts from this blog

Tuning ext4 for performance with emphasis on SSD usage

Java 8: Default Interface Implementations, The Diamond Problem, Multiple Inheritance, and Precedence

Tuning ext3 for performance without losing its data integrity potential