What are the types of Literals in PL/SQL?

1.	What are the types of Literals in PL/SQL?
Answer» Literals are syntactic representation of NUMERIC, character, string, or BOOLEAN value. The literals in PL/SQL are case-sensitive. The FOLLOWING are the literals in PL/SQL: Numeric Literals Examples: 20 -20 0 Character Literals Examples: 'A', '%', '9' String Literals 'Mystring!' 'Web!' BOOLEAN Literals Examples: TRUE, FALSE Date and TIME Literals DATE '2018-12-20'; TIMESTAMP '2018-12-15 11:10:30';

Answer»

Literals are syntactic representation of NUMERIC, character, string, or BOOLEAN value. The literals in PL/SQL are case-sensitive.

The FOLLOWING are the literals in PL/SQL:

'Mystring!' 'Web!'

Examples: TRUE, FALSE

DATE '2018-12-20'; TIMESTAMP '2018-12-15 11:10:30';

Discussion