SET SQL Prompt automatically??

From: John Neus <john.neus_at_superconsult.nl>
Date: Mon, 7 Feb 2000 16:51:33 +0100
Message-ID: <87mpm8$kf$1@porthos.nl.uu.net>

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 Received on Mon Feb 07 2000 - 09:51:33 CST