A literal, also called a constant, is a type of expression that specifies a constant value. Generally, you can specify a literal wherever SQL syntax allows an expression. Some SQL constructs allow literals but disallow other forms of expressions.

There are three types of literals:

  • NUMERIC
  • CHARACTER-STRING
  • DATE-TIME

The following sections discuss each type of literal.