Re: A better SQL*Plus -- what features should it have?
From: Scott Mattes <Scott_at_TheMattesFamily.ws>
Date: Thu, 07 Nov 2002 16:23:24 GMT
Message-ID: <0swy9.8731$6g.3176738_at_news1.news.adelphia.net>
- save results to a file
[Quoted] - have as small a footprint as possible ( my sqlplus doesn't do what my [Quoted] schema browser does, etc)
[Quoted] - have table/field name auto completion
> "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.
>
> Indeed, but if I 'forget' that extra character then I have false
assurance.
> If I mistype connect on the other hand I just curse and have another go. I
> 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:23:24 CET
Date: Thu, 07 Nov 2002 16:23:24 GMT
Message-ID: <0swy9.8731$6g.3176738_at_news1.news.adelphia.net>
[Quoted] The demo code upon which I am basing my 'better' sql GUI doesn't let me do 'connect' as a command, I have to disconnect (button click) and reconnect (button click, enter new userid/password/sid), after which it displays the userid/db for me.
[Quoted] Some of the things that I think a better sqlplus should do are
- syntax high lighting [Quoted] - save the last x unique commands [Quoted] - save personal favorites for access from the menu/hotkey [Quoted] - display results in a grid (no messing with formating or wrapped lines ofoutput)
- save results to a file
[Quoted] - have as small a footprint as possible ( my sqlplus doesn't do what my [Quoted] schema browser does, etc)
[Quoted] - have table/field name auto completion
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3dca8ed3$0$8507$ed9e5944_at_reading.news.pipex.net...
> "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.
>
> Indeed, but if I 'forget' that extra character then I have false
assurance.
> If I mistype connect on the other hand I just curse and have another go. I
> 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:23:24 CET