RE: SQL*Plus Question
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: <oracledba.williams@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 9 Feb 2009 12:56:01 -0700
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
Other related posts:
