Skip to content
Skip to content
Archive of entries posted on 10th November 2009

Get a complete CREATE TABLE definition using DBMS_METADATA package

CREATE TABLE has lot of option to go with it; it is hard to remember all of them. Most people will get lost while reading the rail road diagrams. It is fairly quick to create the table in its simple form and obtain all the parameters associated with it. ops$rperumal@PDB10> CREATE TABLE t 2 (n [...]