Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Write Numeric Literals in Oracle?

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

 141 views

More Questions for you: