Oracle - Numeric Literals in Oracle

Numeric Literals in Oracle

Q

How To Write Numeric Literals in Oracle?

✍: FYIcenter.com

A

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

⇒Understanding SQL Language Basics for Oracle

⇒⇒Oracle Database Tutorials

2016-10-16, 591👍, 0💬

💬 2017-07-10 sasi: Nice tutorial..

About dba.FYIcenter.com Website
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administrators) and database application developers looking for database server management tips, database programming tutorials, career information, and so on. Just browse through the site, you will find the b... 2016-10-17, 4090👍, 0💬

Testing Area
What is test testing area for? The testing area is provided to allow visitors to post testing comments. 2016-10-15, 806👍, 2💬

💬 2019-09-19 Aninda mahadev: Good Tutorial!!!

💬 2017-07-10 Kumar Kedi: ascdfwtwert

What Is NULL Value in Oracle
What Is NULL Value in Oracle? NULL is a special value representing "no value" in all data types. NULL can be used on in operations like other values. But most operations has special rules when NULL is involved. The tutorial exercise below shows you some examples: SET NULL 'NULL'; -- Make sure NULL i... 2019-12-02, 717👍, 0💬

Convert Times to Character Strings in Oracle
How To Convert Times to Character Strings in Oracle? You can convert dates to characters using the TO_CHAR() function as shown in the following examples: SELECT TO_CHAR(SYSDATE, 'HH:MI:SS') FROM DUAL; 04:49:49 SELECT TO_CHAR(SYSDATE, 'HH24:MI:SS.FF') FROM DUAL; -- Error: SYSDATE has no fractional se... 2019-12-02, 717👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.