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>


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.com
Received on Mon Jan 09 1995 - 15:15:45 CET

Original text of this message