Simple expressions

A simple expression can be a column, pseudocolumn, constant, sequence number, or NULL.

The syntax of a simple expression is as follows:

{ [ query_name.
  | [schema.]
    { table. | view. | materialized view. }
  ] { column | ROWID }
| ROWNUM
| string
| number
| sequence. { CURRVAL | NEXTVAL }
| NULL
}

In addition to the user schema, schema can also be "PUBLIC" with double quotation marks ("). A "PUBLIC" schema specifies a table or view.

The following examples are valid simple expressions:

• employees.first_name

• 'welcome to OceanBase'

• 10

• 3*3