oracle How to get DDL from Oracle Sugeng Widodo Read more posts by this author. Sugeng Widodo 21 Nov 2012 • 1 min read set long 1000set pagesize 0select DBMS_METADATA.GET_DDL('TABLE','PERSON') from DUAL;