Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> instance name in SQL Plus prompt?

instance name in SQL Plus prompt?

From: Dan A. <nospam_at_email.com>
Date: Thu, 24 May 2001 10:20:24 -0700
Message-ID: <9ejfsq$9j9$1@nntp.Stanford.EDU> 






Hi - Does anyone know how to put the current instance name in the sql plus
prompt?   I'm using the windows (2000) version of sqlplus.  Instead of the
default:



SQL>


can it be changed to something like:



TESTDB>


and it would always change to whatever instance you login to?




Thanks in advance!         -Dan
Received on Thu May 24 2001 - 12:20:24 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US