Does this help at all? -joe SQL> select 'i am ' || chr(39) || 'joe' || chr(39) from dual; 'IAM'||CHR(39)||'JOE'||CHR(39) ------------------------------ i am 'joe' SQL> ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dennis Williams Sent: Monday, February 09, 2009 12:16 PM To: oracle-l Subject: SQL*Plus Question List, So, I'm trying to generate a list of CREATE TABLESPACE statements from DBA_DATA_FILES. I'm having trouble putting single quotes around the datafile name. This is frustrating because I seem to have forgotten how to do this. I thought there is a SQL function that would let you enter the hexadecimal value of a character you want printed. This is 10.2.0.4 on Solaris, but I don't think that matters. Thanks, Dennis Williams