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, 1988🔥, 0💬
Popular Posts:
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...