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, 1899🔥, 0💬
Popular Posts:
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...