sqlprompt in Sql*Plus

From: Ian Couroulis <ian_at_ironbark.bendigo.latrobe.edu.au>
Date: 1995/06/26
Message-ID: <3smipm$8j9_at_sheoak.bendigo.latrobe.edu.au>#1/1


I thought I read somewhere that it was possible to automatically set the prompt in Sql*Plus from "SQL>" to the value of $ORACLE_SID by putting something in the global login (glogin.sql) file. I have tried experimenting with the 'sqlprompt' value in Sql*Plus but not having much luck.

What I really would like is my prompt set to: ORACLE_SID (user) For instance:

	EMP (scott) > connect tiger/tiger
	EMP (tiger) >

Is this possible? If not, what about either ORACLE_SID or user as the prompt?

Ian.

--
Received on Mon Jun 26 1995 - 00:00:00 CEST

Original text of this message