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, 1878🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...