From oracle-l-bounce@freelists.org Tue Feb 24 01:23:39 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1O7NcP15702 for ; Tue, 24 Feb 2004 01:23:38 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i1O7Nco15697 for ; Tue, 24 Feb 2004 01:23:38 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A585E394EAD; Tue, 24 Feb 2004 02:25:19 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 24 Feb 2004 02:24:18 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mailhost.kssnet.co.jp (mailhost.kssnet.co.jp [202.234.204.3]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B52A5394E4B for ; Tue, 24 Feb 2004 02:24:15 -0500 (EST) Received: from prem (p9103-ipadfx01kokuryo.gunma.ocn.ne.jp [220.98.193.103]) by mailhost.kssnet.co.jp (Post.Office MTA v3.5.3J release 223-101-J ID# 1001-419430633U100L2S100V35J) with ESMTP id jp; Tue, 24 Feb 2004 16:26:45 +0900 From: "Prem Khanna J" To: Cc: Subject: RE: Dynamic prompt in SQL*PLUS Date: Tue, 24 Feb 2004 16:28:16 +0900 Organization: Kantoh System Message-ID: <004501c3faa7$c4f6d8e0$dd00a8c0@prem> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 In-Reply-To: <77ED2BF75D59D1439F90412CC5B10974080742F6@ie10-sahara.hiso.honeywell.com> Importance: Normal X-archive-position: 1666 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jprem@kssnet.co.jp Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l Hi Naven, Just paste the lines below in ur ORACLE_HOME/sqlplus/admin/glogin.sql --------------8<--------------8<--------------8<--------------8<-------- ------8<--------------8<---- COLUMN gname new_value gname noprint SET feed OFF verify OFF SELECT UPPER(USER)||'@&_CONNECT_IDENTIFIER'||' SQL>' gname FROM dual; SET sqlprompt '&gname> ' feed ON verify ON --------------8<--------------8<--------------8<--------------8<-------- ------8<--------------8<---- Hope this is what u need . Regards, Prem. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------