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:
|
|
| 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.
|
|