PLSQL

PL/SQL Literals

PL/SQL Literals

The literal is said to be an explicit numeric, character, string or Boolean value that is not represented by an identifier. Like, the following examples TRUE, 890, NULL, ‘great learning’ are the literals of type Boolean, number or String. All the literals are said to be case-sensitive. In PL/SQL we have different types of literals that are shown below:

  1. Numeric Literals 
  2. Character Literals
  3. String Literals
  4. Boolean Literals
  5. Date and Time Literals