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

NetBeans 6.1: Working with Google´s Android SDK, Groovy and Grails