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, 967👍, 0💬
Popular Posts:
How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL? If a stored procedu...
What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of ...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...