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.
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!
RELATED POSTS
Preventing Database Bottlenecks with Intelligent Workload Analytics and Automation
- 11 June 2026
- Database Performance Management
In today’s digital economy, application performance directly impacts customer satisfaction, operational efficiency, and business growth. Organizations rely on databases to power customer-facing applications, financial transactions, e-commerce platforms, analytics systems, SaaS solutions, and countless other mission-critical services. As enterprises continue to embrace cloud-native architectures, microservices, multi-cloud deployments, and real-time data processing, database workloads have become increasingly … Continue reading “Preventing Database Bottlenecks with Intelligent Workload Analytics and Automation”
The Future of AI-Powered Database Performance Management in Enterprise IT Operations
Enterprise IT operations are undergoing a significant transformation. As organizations accelerate digital transformation initiatives, adopt cloud-native architectures, expand multi-cloud deployments, and implement AI-driven business strategies, the complexity of managing database environments continues to grow. Databases have evolved from simple data repositories into mission-critical components that power applications, analytics platforms, customer experiences, and business operations. Modern … Continue reading “The Future of AI-Powered Database Performance Management in Enterprise IT Operations”
How to Transform Financial Operations with Enteros Database Software and Growth Intelligence
- 10 June 2026
- Database Performance Management
Introduction The financial services industry is experiencing unprecedented digital transformation. Banks, insurance providers, fintech organizations, investment firms, and financial institutions are rapidly modernizing their technology infrastructures to meet evolving customer expectations, regulatory requirements, and competitive market demands. Modern financial organizations now rely on: Digital banking platforms Mobile financial applications Payment processing systems Risk management platforms … Continue reading “How to Transform Financial Operations with Enteros Database Software and Growth Intelligence”
How to Enable Intelligent AI Growth with Enteros Database Performance Management and Operational Intelligence
Introduction Artificial Intelligence (AI) is transforming industries across the globe. From generative AI applications and large language models (LLMs) to predictive analytics, intelligent automation, and machine learning platforms, organizations are investing heavily in AI technologies to improve productivity, accelerate innovation, and drive business growth. Modern AI ecosystems now support: Generative AI platforms Machine learning environments … Continue reading “How to Enable Intelligent AI Growth with Enteros Database Performance Management and Operational Intelligence”