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

How to fix: skipping incompatible /usr/lib/gcc/x86_64-linux-gnu