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

You may want to take a look at Oracle iSQLW, a tool I've been developing in some spare time as an all around development-friendly query analyzer. It's at the following URL:

http://home.swbell.net/gluttony/ (if you don't mind the funny name, the web page is very much an in-progress location)

> Some of the things that I think a better sqlplus should do are
> - syntax high lighting
Got it!

> - save the last x unique commands
Got it (a history window).

> - save personal favorites for access from the menu/hotkey
Doesn't have it yet...

> - display results in a grid (no messing with formating or wrapped lines of
> output)
Doesn't have it yet...

> - save results to a file

Got it, although still have to implement "spool filename.txt" as a command.

> - have as small a footprint as possible ( my sqlplus doesn't do what my
Built in Delphi, the executable is pretty big...

> schema browser does, etc)
No schema browser, but check out the describe functionality, such as DESCRIBE DUA%

> - have table/field name auto completion
Doesn't have it yet...

Bret
bretg_at_yahoo.com

"Scott Mattes" <Scott_at_TheMattesFamily.ws> wrote in message news:<0swy9.8731$6g.3176738_at_news1.news.adelphia.net>...
> 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.
>
> Some of the things that I think a better sqlplus should do are
> - syntax high lighting
> - save the last x unique commands
> - save personal favorites for access from the menu/hotkey
> - display results in a grid (no messing with formating or wrapped lines of
> output)
> - save results to a file
> - have as small a footprint as possible ( my sqlplus doesn't do what my
> schema browser does, etc)
> - have table/field name auto completion
>
Received on Sat Nov 09 2002 - 07:51:12 CET