Re: A better SQL*Plus -- what features should it have?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 7 Nov 2002 16:03:31 -0000
Message-ID: <3dca8ed3$0$8507$ed9e5944_at_reading.news.pipex.net>


[Quoted] "Guido Konsolke" <Guido.Konsolke_at_Triaton.com> wrote in message news:1036679124.71494_at_news.thyssen.com...
> of course you're right. But you can handle this by creating
> a script called connect.sql. In this script you can do the
> things you have to to get a proper prompt. And then,
> every time you connect to a db, just issue _at_connect
> instead of connect. It's just one extra character.
> I love this trick. The exact procedure can be found
> in the 'bible' OneOnOne by Tom Kyte.

[Quoted] [Quoted] Indeed, but if I 'forget' that extra character then I have false assurance. [Quoted] [Quoted] If I mistype connect on the other hand I just curse and have another go. I [Quoted] don't think that its that i'm over cautious, just that if there is any possibility that the screen can say <development database> when I'm on the <production database> then *at the worst possible moment* this has a probability approaching 1 of happening :(.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
Received on Thu Nov 07 2002 - 17:03:31 CET

Original text of this message