Re[2]: how to put ' on statement

From: Sergey V Dolgov <dsv_at_pptus.oilnet.ru>
Date: Mon, 06 May 2002 20:28:24 -0800
Message-ID: <F001.00459914.20020506202824@fatcity.com>

Hello mitchell,

Try to make like this:

select 'ALTER TABLESPACE rename file '''||file_name||''' to '''||file_name||''';' from dba_data_files
where tablespace_name = 'TBL_STATEMENT';

Tuesday, May 07, 2002, 5:53:11 AM, you wrote:

m> hi

m> I forget how to put single qutation on sql. somebody can help me.

m> Mitchell

m> I could't make it from following.

m> select 'ALTER TABLESPACE rename file "'" '||file_name||' to
m> '||file_name||'"'";'
m> from dba_data_files
m> where tablespace_name = 'TBL_STATEMENT';

--

Best regards,

 Sergey                            mailto:dsv_at_pptus.oilnet.ru

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sergey V Dolgov
  INET: dsv_at_pptus.oilnet.ru

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon May 06 2002 - 23:28:24 CDT