Home >> FAQs/Tutorials >> Oracle Tutorials
Oracle Tutorials - Numeric Literals
(Continued from previous topic...)
How To Write Numeric Literals?
Numeric literals can coded as shown in the following samples:
SELECT 255 FROM DUAL -- An integer
SELECT -6.34 FROM DUAL -- A regular number
SELECT 2.14F FROM DUAL -- A single-precision floating point
SELECT -0.5D FROM DUAL -- A double-precision floating point
(Continued on next topic...)
- What Is SQL Standard?
- How Many Categories of Data Types?
- What Are the Oracle Built-in Data Types?
- What Are the Differences between CHAR and NCHAR?
- What Are the Differences between CHAR and VARCHAR2?
- What Are the Differences between NUMBER and BINARY_FLOAT?
- What Are the Differences between DATE and TIMESTAMP?
- What Are the Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND?
- What Are the Differences between BLOB and CLOB?
- What Are the ANSI Data Types Supported in Oracle?
- How To Write Text Literals?
- How To Write Numeric Literals?
- How To Write Date and Time Literals?
- How To Write Date and Time Interval Literals?
- How To Convert Numbers to Character Strings?
- How To Convert Characters to Numbers?
- How To Convert Dates to Characters?
- How To Convert Character Strings to Dates?
- How To Convert Times to Character Strings?
- How To Convert Character Strings to Times?
- What Is NULL Value?
- How To Use NULL as Conditions?
- How To Concatenate Two Text Values?
- How To Increment Dates by 1?
- How To Calculate Date and Time Differences?
- How To Use IN Conditions?
- How To Use LIKE Conditions?
- How To Use Regular Expression in Pattern Match Conditions?