Literal and value functions

Use the literal and value functions to specify literals such as a string or hexadecimal and values such as NULL or a special register.

Function Description
Column Name An explicit column name (column names are case‑insensitive).
NULL NULL. The destination column must be nullable.
Numeric Constant A numeric constant. The constant value must fit into the destination column as defined by its data type, precision, and scale.
Boolean Constant A Boolean constant (TRUE or FALSE).
Special Register A special register:
  • CURRENT DATE
  • CURRENT_DATE
  • CURRENT TIME
  • CURRENT_TIME
  • CURRENT TIMESTAMP
  • CURRENT_TIMESTAMP
  • CURRENT SQLID
  • CURRENT_SQLID
  • CURDATE( )
  • CURTIME( )
  • GETDATE( )
  • GETTIME( )
  • SYSDATE( )
  • NOW( )
  • WORKSTATION_ID
  • USER
String Literal A string literal, enclosed in single quotes. The destination column must contain character data.

Example: 'CA' or '90210'.

Hexadecimal Literal A hexadecimal literal.

Example: X‘1234567890ABCDEF' or 0X1234567890ABCDEF

Date/Time Literal A date/time literal, enclosed in single quotes. Separate the date and time with a space. To format the date/time with a decimal fraction, place a period after the time, followed by the fraction. The date format is determined by the settings in Regional Options on the Control Panel of your computer.
Note: For Oracle Timestamp with Time Zone columns, you must specify the time zone suffix last.


Feedback