Re: Newbie Question - Concatenating quotes

Sue Kudenchak (sarroyo_at_cnj.digex.net) wrote:
: 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';

Hello Sue,

  You could also use something like:

       select chr(39)öö'alter system kill session 'ööchr(39) ...

  I think it looks better.

Regards,

        Hessu

-- 
---------------------------------------------------------------------
Heikki Rissanen, United Papermills, Rauma, Finland
Email: rissahe1_at_news.ougf.fi
---------------------------------------------------------------------