Re: Dynamically assigned SQL*Plus command prompt

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Thu, 11 Mar 1999 16:40:10 +0100
Message-ID: <36e7e3dc$0$987@pascal>

XU wrote
>spool /tmp/userp.sql
>select 'set sqlp "'||decode(user, 'SYS', 'SYS# "', 'SYSTEM', 'SYSTEM# "',
> user||'> "') from dual;
>spool off

>start /tmp/userp.sql

Or use a (non-printing) new_value column, something like

    set verify off
    set feeback off
    column LoginUser new_value LoginUser noprint

    select decode

        ( user
        , 'SYS', 'SYS# '
        , 'SYSTEM', 'SYSTEM# '
        , user || '>'
        ) LoginUser

    from dual;

    set sqlprompt '&LoginUser.'

    clear columns
    set feedback on
    set verify on

Arjan. Received on Thu Mar 11 1999 - 09:40:10 CST