Oracle PL/SQL Literals.

Preamble

In this tutorial you will learn how to use literals (text, integers and numbers) in Oracle with examples.

In Oracle, he wrote the same thing as the constant. We will consider three types of literals: text literals, integer literals, numeric literals and date/time literals.

Text literals

Text literals are always enclosed in single quotes (‘).
For example:

'King Arthur'
'23-FEB-18'

Integer liters

Integer literals can contain up to 38 digits.

Integer literals can be either positive numbers or negative numbers. If you do not specify a sign, a positive number is assumed. Here are some examples of real integer literals:

18
+18
-18

Numerical literals

Numerical literals can contain up to 38 digits. Numerical literals can be both positive and negative. If you do not specify a character, a positive number is assumed. Here are some examples of acceptable numeric literals:

23
+23
-23
23e-04
23.607
-23.607

Literals date/time

Date and time are in single quotes (‘).
For example:

'23.02.1918' -- the date when the interventionists were (historical)
'14.01.2018 08:13:24'

When using date/time values, use the TO_DATE function to convert literals to dates.
For example:

SELECT TO_DATE('14.01.2018', 'dd.mm.yyyy') FROM dual;
TO_DATE('14.01.2018', 'DD.MM.YYYY').
----------------------------------
14.01.2018

In this example, the function will take a literal value ‘14.01.2018’ and convert it to a date.

What is the use of literals in oracle database

About Enteros

​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​