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
2016-10-16, 552👍, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Tr...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...