Path: news.easynews.com!easynews!news.infoave.net!not-for-mail
From: "Chris Boyle" <cboyle@no.spam.hargray.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: How to set SQLPROMPT
Date: Wed, 10 Oct 2001 10:56:28 -0400
Organization: Info Avenue Internet Services, LLC
Lines: 36
Message-ID: <9q1nib$5flc$1@news3.infoave.net>
References: <9q1d4q$al6$1@pegasus.tiscalinet.it>
NNTP-Posting-Host: stimpy.htc.hargray.com
X-Trace: news3.infoave.net 1002725771 179884 204.116.21.6 (10 Oct 2001 14:56:11 GMT)
X-Complaints-To: abuse@infoave.net
NNTP-Posting-Date: Wed, 10 Oct 2001 14:56:11 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Xref: easynews comp.databases.oracle.misc:70130
X-Received-Date: Wed, 10 Oct 2001 08:24:08 MST (news.easynews.com)

This is in my glogin.sql file.

set termout off
spool temp_prompt.sql
select 'set sqlprompt '||''''||upper(user)||'@'||upper(name)||'>
'||''''||chr(10)
from v$database;
spool off
start temp_prompt.sql
set termout on


set heading off
select 'Currently logged in to '||name||' database'
from v$database;
set heading on



Mimmo Sime1 <csime1@xxx.it> wrote in message
news:9q1d4q$al6$1@pegasus.tiscalinet.it...
> Hello everyone!
> I've got a quick question for you all:
>
> How can i set "SQLPROMPT" (from login.sql) with a variable valorized with
a
> query?
> In a few words: i'd like tu set SQLPROMPT with the result of "select
> global_name from global_name"...
>
>
> TIA! :)
>
>