Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Write Text Literals in Oracle?

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

SELECT 'rendc.org' FROM DUAL -- The most common format

rendc.org

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!

 122 views

More Questions for you: