Extract DDL without some parameters

This is something useful, especially for moving data between systems with very different storage configuration, or if you just want to have smaller output for your DDL command. Below you’ll find some examples that I was able to find: SYS@TEST> create table test (id number, ddate date); Table created. Elapsed: 00:00:00.02 SYS@TEST> select dbms_metadata.get_ddl(‘TABLE’,’TEST’) FROM…

Read More