Re: Oracle database name in SQL*Plus prompt

Hi Winston,

>Is there an easy way to set my prompt in SQL*Plus to the name of the
>database that I am using without having to prompt myself for the name of
>the database ?

I have created two scripts to make it comfortable.

• Script c.sql somewhere at my SQLPATH ----- set scan on connect &1 @login

  ---

• Script login.sql somewhere at my SQLPATH -- set numwidth 9 set linesize 100 set pagesize 1000 set serverout on size 1000000

SET TERMOUT OFF BREAK ON TODAY
COLUMN TODAY NEW_VALUE _DATE
SELECT TO_CHAR(SYSDATE, 'fmMonth DD, YYYY') TODAY FROM DUAL;
CLEAR BREAKS COLUMN USER_NAME NEW_VALUE _USR
COLUMN MESS_NAME NEW_VALUE _mess

define _usr = ""
define _mess = "not logged in"

SELECT USER||'@'||substr(global_name,1,instr(global_name,'.')-1) USER_NAME ,'logged in' MESS_NAME FROM global_name;

set sqlp "&_usr> "

alter session set nls_date_format='DD.MM.YYYY'; SET TERMOUT ON prompt &_mess

Just forget the command 'connect'! If you don't, you'll be doing very big mistakes very fast.

Jan
jan_at_abs.ee Received on Mon Jul 21 1997 - 00:00:00 CDT