ASA SQL Reference
SQL Statements
Using the SQL statement reference
The following conventions are used in the SQL syntax descriptions:
Keywords All SQL keywords are shown like the words ALTER TABLE in the following example:
ALTER TABLE [ owner.]table-name
Placeholders Items that must be replaced with appropriate identifiers or expressions are shown like the words owner and table-name in the following example.
ALTER TABLE [ owner.]table-name
Repeating items Lists of repeating items are shown with an element of the list followed by an ellipsis (three dots), like column-constraint in the following example:
ADD column-definition [ column-constraint, ... ]
One or more list elements are allowed. If more than one is specified, they must be separated by commas.
Optional portions Optional portions of a statement are enclosed by square brackets.
RELEASE SAVEPOINT [ savepoint-name ]
These square brackets indicate that the savepoint-name is optional. The square brackets should not be typed.
Options When none or only one of a list of items can be chosen, vertical bars separate the items and the list is enclosed in square brackets.
[ ASC | DESC ]
For example, you can choose one of ASC, DESC, or neither. The square brackets should not be typed.
Alternatives When precisely one of the options must be chosen, the alternatives are enclosed in curly braces.
[ QUOTES { ON | OFF } ]
If the QUOTES option is chosen, one of ON or OFF must be provided. The brackets and braces should not be typed.
One or more options If you choose more than one, separate your choices with commas.
{ CONNECT, DBA, RESOURCE }