|Oracle9i SQL Reference
Release 1 (9.0.1)
Part Number A90125-01
Expressions, 3 of 14
A simple expression specifies column, pseudocolumn, constant, sequence number, or null.
In addition to the schema of a user,
schema can also be "
PUBLIC" (double quotation marks required), in which case it must qualify a public synonym for a table, view, or materialized view. Qualifying a public synonym with "
PUBLIC" is supported only in data manipulation language (DML) statements, not data definition language (DDL) statements.
pseudocolumn can be either
ROWNUM. You can use a pseudocolumn only with a table, not with a view or materialized view.
NVARCHAR2 are not valid pseudocolumn datatypes.
"Pseudocolumns" for more information on pseudocolumns
Some valid simple expressions are: