{ NULL } { [ ] } { [ [ BOTH ] ] } { TRIM ( [ [ LEADING ] CHARACATER value-expr FROM ] value-expr ) } { [ [ TRAILING ] ] } { [ ] } { POSITION (value-expr IN value-expr FROM value-expr ) } { USER } { CURRENT_USER } { CURRENT_DATE } { CURRENT_TIME (scale) } { CURRENT_TIMESTAMP (scale) } { CHARACTER_LENGTH (value-expr) } { CHAR_LENGTH (value-expr) } { OCTET_LENGTH (value-expr) } { UPPER (value-expr) } { LOWER (value-expr) } { SESSION_USER } { SUBSTRING [_OCTETS] (value-expr FROM value-expr FOR value-expr) } { SUBSTRING_CHARACTERS (value-expr FROM value-expr FOR value-expr) } { SYSTEM_USER } { cast-builtin-expr } { { YEAR } } { { MONTH } } { { DAY } } { { HOUR } } { EXTRACT ( { MINUTE } FROM value-expr) } { { SECOND } } { { WEEKDAY } } { { JULIAN } } { TRANSLATE (value-expr USING character-set) } Calculate values based on specified value expressions. See the Descriptions subtopic for Built-in Function descriptions. See the Oracle Rdb7 SQL Reference Manual for the character set types.