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, 1808🔥, 0💬
Popular Posts:
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...