Re: Insert an apostrophe into a string?
From: B C Zygmunt <bzy_at_ornl.gov>
Date: 1996/07/12
Message-ID: <4s6733$b3f_at_stc06.ctd.ornl.gov>#1/1
Date: 1996/07/12
Message-ID: <4s6733$b3f_at_stc06.ctd.ornl.gov>#1/1
How about this? It does your query four items in the table tab.
select 'select tablespace_name from user_segments where segment_name = ''' || tname || ''';' from tab where rownum < 5 and tabtype = 'TABLE';
Beverly Received on Fri Jul 12 1996 - 00:00:00 CEST