Path: news.easynews.com!easynews!nntp.flash.net!news.tele.dk!small.news.tele.dk!212.74.64.35!colt.net!newsfeed.esat.net!lnewspeer01.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail From: "Niall Litchfield" Newsgroups: comp.databases.oracle.misc References: <9q1d4q$al6$1@pegasus.tiscalinet.it> Subject: Re: How to set SQLPROMPT Date: Wed, 10 Oct 2001 14:43:04 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 26 Message-ID: <3bc45070$0$8513$ed9e5944@reading.news.pipex.net> NNTP-Posting-Host: host9.audit-commission.gov.uk X-Trace: 1002721392 reading.news.pipex.net 8513 193.128.236.219 X-Complaints-To: abuse@uk.uu.net Xref: easynews comp.databases.oracle.misc:70123 X-Received-Date: Wed, 10 Oct 2001 07:34:18 MST (news.easynews.com) see Connors excellent answer at the co-operative FAQ http://www.jlcomp.demon.co.uk/faq/sqlplus_prompt.html -- Niall Litchfield Oracle DBA Audit Commission UK "Mimmo Sime1" 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! :) > >