Andrew Fraser DBA

Oracle single quote marks for excel text datatype

Add a quote in front of a field (useful for excel to mark cell as text datatype) with any of:

SELECT CHR(39) || address1 FROM customers ;
SELECT q'[']'  || address1 FROM customers ;
SELECT ''''    || address1 FROM customers ;