Newbie Question - Concatenating quotes
From: Sue Kudenchak <Sue.Kudenchak_at_p55.f5500.n240.z2.fidonet.org>
Date: 09 Jan 95 15:15:45
Message-ID: <779_9501100916_at_clipper.de>
Date: 09 Jan 95 15:15:45
Message-ID: <779_9501100916_at_clipper.de>
Good morning:
I have another newbie question.
I want to dynamically create "alter system kill session" commands so that operations can shutdown the server at night cleanly.
The syntax I need to generate looks like this:
alter system kill session 'sid,serial#';
I'm trying to do something like this:
select 'alter system kill session ' || ''' || sid || ',' || serial# || '';' from v$session where username != 'oracle7';
which ( obviously to some gurus ) won't run. Can anybody help?
Thanks in advance - Sue
-- -------------------------------------------------- Sue Kudenchak Currently SKud, Formerly Sue Arroyo Plan: To grow coconuts in Bora-Bora Internet: sarroyo_at_cnj.digex.comReceived on Mon Jan 09 1995 - 15:15:45 CET