How To Write Text Literals

Q

How To Write Text Literals? - Oracle DBA FAQ - Understanding SQL Basics

✍: FYIcenter.com

A

There are several ways to write text literals as shown in the following samples:

SELECT 'FYICenter.com' FROM DUAL -- The most common format
FYICenter.com

SELECT 'It''s Sunday!' FROM DUAL -- Single quote escaped
It's Sunday! 

SELECT N'Allo, C''est moi.' FROM DUAL -- National chars
Allo, C'est moi.

SELECT Q'/It's Sunday!/' FROM DUAL -- Your own delimiter
It's Sunday!

2007-04-24, 4781👍, 0💬

What Are the Differences between BLOB and CLOB
What Are the Differences between BLOB and CLOB? - Oracle DBA FAQ - Understanding SQL Basics The main differences between BLOB and CLOB are: BLOB stores values as LOB (Large OBject) in bitstreams. CLOB stores values as LOB (Large OBject) in character steams. 2007-04-24, 5295👍, 0💬

What Are the Differences between NUMBER and BINARY_FLOAT
What Are the Differences between NUMBER and BINARY_FLOAT? - Oracle DBA FAQ - Understanding SQL Basics The main differences between NUMBER and BINARY_FLOAT are: NUMBER stores values as fixed-point numbers using 1 to 22 bytes. BINARY_FLOAT stores values as single precision floating-point numbers. 2007-04-24, 5161👍, 0💬

What Are the Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND
What Are the Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND? - Oracle DBA FAQ - Understanding SQL Basics The main differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND are: INTERVAL YEAR TO MONTH stores values as time intervals at the month level. INTERVAL DAY ... 2007-04-24, 5152👍, 0💬

How To Convert Characters to Numbers
How To Convert Characters to Numbers? - Oracle DBA FAQ - Understanding SQL Basics You can convert characters to numbers by using the TO_NUMBER() function as shown in the following examples: SELECT TO_NUMBER('4123.4570') FROM DUAL 4123.457 SELECT TO_NUMBER(' $4,123.46','$9,999,999.99') FROM DUAL 4123... 2007-04-23, 5148👍, 0💬

How To Write Numeric Literals
How To Write Numeric Literals? - Oracle DBA FAQ - Understanding SQL Basics 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.... 2007-04-24, 4868👍, 0💬

What Are the Differences between DATE and TIMESTAMP
What Are the Differences between DATE and TIMESTAMP? - Oracle DBA FAQ - Understanding SQL Basics The main differences between DATE and TIMESTAMP are: DATE stores values as century, year, month, date, hour, minute, and second. TIMESTAMP stores values as year, month, day, hour, minute, second, and fra... 2007-04-24, 4845👍, 0💬

How To Write Date and Time Literals
How To Write Date and Time Literals? - Oracle DBA FAQ - Understanding SQL Basics Date and time literals can coded as shown in the following samples: SELECT DATE '2002-10-03' FROM DUAL -- ANSI date format 03-OCT-02 SELECT TIMESTAMP '1997-01-31 09:26:50.124' FROM DUAL 31-JAN-97 09.26.50.124000000 AM -... 2007-04-24, 4815👍, 0💬

What Are the ANSI Data Types Supported in Oracle
What Are the ANSI Data Types Supported in Oracle? - Oracle DBA FAQ - Understanding SQL Basics The following ANSI data types are supported in Oracle: CHARACTER(n) / CHAR(n) CHARACTER VARYING(n) / CHAR VARYING(n) NATIONAL CHARACTER(n) / NATIONAL CHAR(n) / NCHAR(n) NATIONAL CHARACTER VARYING(n) / NATIO... 2007-04-24, 4811👍, 0💬

How To Write Text Literals
How To Write Text Literals? - Oracle DBA FAQ - Understanding SQL Basics There are several ways to write text literals as shown in the following samples: SELECT 'FYICenter.com' FROM DUAL -- The most common format FYICenter.com SELECT 'It''s Sunday!' FROM DUAL -- Single quote escaped It's Sunday! SELE... 2007-04-24, 4782👍, 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.