Collections:
Text Literals in Oracle
How To Write Text Literals in Oracle?
✍: FYIcenter.com
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!
2020-04-14, 943👍, 0💬
Popular Posts:
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
Where to find answers to frequently asked questions on Using INSERT, UPDATE and DELETE Statements in...
How To Create a View on an Existing Table in SQL Server? If you want to a view on an existing table,...
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard ...