Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Sanity Check Index DDL scrips

Simple example

Description: My dummy sample schema

Using syntax highlighting: Yes

Character set: iso-8859-2

Constraints: NOT NULL constraints are skipped. This information is kept in colums list. You can enable its listing by --nn option.

DDL Scripts: Obtaining the DDL script depends on the DBMS_METADATA package. So it's limited only for Oracle version 9 and greater and for users with EXECUTE privilege on this package.