Re: SET SQL Prompt automatically??

John Neus wrote:
>
> Hello,
>
> I would like to set my prompt in Oracle SQL*Plus . Suppose I have 2
> environments: development and production.
> Therefore I would like to have 2 batchfiles which both run Oracle SQL*Plus;
>
> batchfile 1: automatically connection to the Development environment and
> with automatically prompt: DEV>
> batchfile 2: automatically connection to the Production environment and
> with automatically pompt PRO>
>
> I know this is possible by a making the batchfiles, but how ?
>
> Thanks
>
> John

Go here ->>>---> http://www.oracle.com/oramag/code/tip08249.html

--

*------------------------------*----------------------------*
| Andrew Allen                 | Against fools, the gods    |
| Process Leadership / PSL DBA | themselves contend in vain |
| Dearborn, MI USA             | -- author unknown          |
*------------------------------*----------------------------*