Data Definition Language (DDL) Syntax

Syntax Notation

					[ INTERNAL ]

	If you include the optional item, omit the brackets.
Vertical Bar |	A vertical bar separates alternative items within brackets or braces. For example:

					[ ASC | DESC ]

	Type one of the items, but omit the vertical bar and brackets.
Braces { }	Braces enclose two or more alternative mandatory items. For example:

					DEFINE { procedure_name | function_name }

	Type one of the items, but omit the braces and vertical bar.
Ellipsis ...	An ellipsis represents an arbitrary number of one or more similar items. For example:

					CONCAT ( column1, column2, ... columnN )

	where N >= 3.
	Type similar items and delimiters as required, but omit the ellipsis.
Symbols	Type the following symbols precisely as they appear in the syntax notation:

For details of the notation used in the syntax diagrams in this Reference, see the PL/SQL User's Guide and Reference or the preface in the Oracle7 Server SQL Reference.

High-Level Syntax Diagrams