Re: Enhancement SQL*Plus (prev.: Re: Fixing a little problem in the login.sql script found in Tom Kyte's book)

From: Alison Holloway <Xalison.holloway_at_oracle.comX>
Date: Tue, 21 Jan 2003 22:46:00 +1100
Message-ID: <3E2D32F8.3070602@oracle.comX>

Peter,

I'm glad you're happy with the little things we add to SQL*Plus. As Chris has mentioned in the past, we try to put the most useful new features into SQL*Plus, but we can't do them all. I'll post more teasers of new features as we get closer to the next release, so stay tuned. :)

Enjoy,

Alison

Peter van Rijn wrote:

> Thanks Alison,
> 
> A lot of people will appreciate this I'm sure.
> And just in case you feel the burden of all those undisclosed secrets:
> you're welcome anytime ;-)
> 
> Peter
> 
> "Alison Holloway" <Xalison.holloway_at_oracle.comX> schreef in bericht
> news:3E2CCBBA.8090002_at_oracle.comX...
> 

>>Peter,
>>
>>You are asking for a lot of pre-release info, but I'll let you have

> 
> another snippet. :)
> 

>>Yes, it will be possible to reset the variables after each successful

> 
> connect command.
> 

>>Now, that's all I'm going to give you ... for now.
>>
>>Alison
>>
>>Peter van Rijn wrote:
>>
>>>Good Morning Alison,
>>>
>>>Thanks for your comments. It certainly is an enhancement, but what I
>>

> really
> 

>>>meant was an enhancement of the prompt itself. If the prompt is set to
>>

> use a
> 

>>>variable it should be reset every time a connect command has been used.
>>

> If I
> 


>>>understand you well this has not (yet?) been realized.

>>>

>>>regards,

>>>

>>>Peter

>>>

>>>

>>>

>>>"Alison Holloway" <Xalison.holloway_at_oracle.comX> schreef in bericht

>>>news:3E260407.2010704_at_oracle.comX...

>>>

>>>

>>>>Chris Jones will no doubt have some comments on this, but I thought I'd

>>>

>>>mention that in

>>>

>>>

>>>>SQL*Plus 9.2, we introduced a define variable that contains the SID

>>>

>>>supplied by the user.

>>>

>>>

>>>>This variable can be used to set the prompt. Here's the blurb from the
>>>

> 9.2
> 


>>>doc:

>>>

>>>

>>>>_CONNECT_IDENTIFIER DEFINE Variable

>>>>

>>>>There is a new DEFINE variable _CONNECT_IDENTIFIER, which contains the
>>>

> SID
> 


>>>as supplied by

>>>

>>>

>>>>the user to make a connection where it is available. This allows the

>>>

>>>connection

>>>

>>>

>>>>information to be accessed like any other DEFINE variable. For example,
>>>

> it
> 


>>>could be used

>>>

>>>

>>>>in TTITLE, in '&' substitution variables, or as your SQL*Plus
>>>

> command-line
> 


>>>prompt by using

>>>

>>>

>>>>the SET SQLPROMPT command. For example, to change your SQL*Plus prompt
>>>

> to
> 


>>>display your

>>>

>>>

>>>>username and SID, enter:

>>>>

>>>>SET SQLPROMPT '&_CONNECT_IDENTIFIER > '

>>>>

>>>>You can use the DEFINE command to view the _CONNECT_IDENTIFIER
>>>

> definition
> 


>>>in the same way

>>>

>>>

>>>>as you view other DEFINE definitions, using the DEFINE command with no

>>>

>>>arguments, or with

>>>

>>>

>>>>the specific argument you wish to display, for example:

>>>>

>>>>DEFINE

>>>>

>>>>or

>>>>

>>>>DEFINE _CONNECT_IDENTIFIER

>>>>

>>>>You can use UNDEFINE to remove the _CONNECT_IDENTIFIER definition and
>>>

> make
> 


>>>it unavailable.

>>>

>>>

>>>>In 10i, we're adding a little more to this. There will be define
>>>

> variables
> 


>>>for _DATE,

>>>

>>>

>>>>_PRIVILEGE, and _USER. So you will be able to do:

>>>>

>>>>SET SQLPROMPT '_USER'@'_CONNECT_IDENTIFIER > '

>>>>

>>>>Alison

>>>>

>>>>Peter van Rijn wrote:

>>>>

>>>>

>>>>>Wouldn't it be nice if SQL*plus itself would offer the functionality of

>>>>>customizing the SQL-prompt? Let's say with dynamically changed

>>>>>USER/DBNAME/SID. A bit like the $PWD in PS1 on Unix.

>>>>>

>>>>>Christopher Jones listening in perhaps? Could this be done 'some day'?

>>>>>

>>>>>Peter

>>>>
>>>

>
> Received on Tue Jan 21 2003 - 05:46:00 CST