Common Keywords and Identifiers
Many keywords are used in multiple SQL statements. To conserve pages, these common keywords are listed here, rather than repeated in each SQL statement in which they are used.
See also the discussion of datatypes in Appendix A, of expressions, operators, and conditions in Appendix B, of numeric format elements in Appendix C, and of date format elements in Appendix D.
- alias
Alternate name by which an object, such as a table, can be referenced.
- column
Name of a column in a table or view.
- COMPRESS integer
Specifies that key compression be enabled during creation of an index. integer specifies the number of prefix columns to compress.
- date
Specifies a date in Oracle date format. This date format must match the default date format for the database (see Appendix A).
- dblink
Name of a database link, which provides access to schema objects that reside in a remote database.
- expr
Any valid Oracle expression, usually involving one or more columns from the table, view, or snapshot. See Appendix B for details.
- filename
Name of a file in operating system-specific format.
- indexname
Name of an index. The name may be prefixed by the owner name (schema).
- integer
Any number without a decimal point or decimal component.
- LOGGING
Specifies that redo log records will be written during creation of the object. This is the default.
- NOCOMPRESS
Specifies that key compression be disabled during index creation. This is the default.
- NOLOGGING
Specifies that redo log records ...