Collections:
Numeric Literals in Oracle
How To Write Numeric Literals in Oracle?
✍: FYIcenter.com
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
2020-04-14, 1752👍, 0💬
Popular Posts:
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...