ADDING QUOTATION MARKS

-- using double quotation marks to write a sentence with an apostrophe.

SELECT 'Graham''s Book' AS Result
FROM DUAL;

-- using double quotation marks to write a sentence with an apostrophe.
-- att a q before the quotation mark, can be upper or lowercase. This is called the alternative quotion mechanism:
-- This mechanism uses double delimeters
SELECT Q'!Graham's Book!' AS Result FROM DUAL;
SELECT Q'<Graham's Book>' AS Result FROM DUAL;
SELECT Q'[Graham's Book]' AS Result FROM DUAL;
SELECT Q'{Graham's Book}' AS Result FROM DUAL;
SELECT Q'(Graham's Book)' AS Result FROM DUAL;

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top