General MySQL Oracle SQL Server

Numeric Literals in Oracle

Q

How To Write Numeric Literals in Oracle?

✍: FYIcenter.com

A

Numeric literals can coded as shown in the following samples:

SELECT 255 FROM DUAL -- An integer
255

SELECT -6.34 FROM DUAL -- A regular number
-6.34

SELECT 2.14F FROM DUAL -- A single-precision floating point
2.14 

SELECT -0.5D FROM DUAL -- A double-precision floating point
-0.5

 

⇒ Date and Time Literals in Oracle

⇐ Text Literals in Oracle

⇑ Understanding SQL Language Basics for Oracle

⇑⇑ Oracle Database Tutorials

2020-04-14, 1647👍, 0💬

General MySQL Oracle SQL Server