Re: sqlplus

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> writes:

> Secondly: I don't know what's wrong with sql*plus

• no command history
• to way to process commandline options in a resonable way
• No way to extend it (other then via scripts who behave differently that builtins)
• inapropriate for moderatetly complex tasks, so people have to resort to a mixture of SQL, PL/SQL often including dynamic SQL (and sometimes with a shell wrapper around the whole thing)
• source code not available

I understand people, who know command.com and bash and who believe, that sqlplus resembles command.com more than it should. Really, sqlplus is not a good shell.

> Thirdly: there a much better tools like TOAD and Sql*navigator, and
> those can be downloaded from the web, while this tool can't and is
> available for Unix platforms only.

Also there is TORA and Senora. Both are open sorce and Senora is even strictly commandline.

I agree with the rest of your posting though. Received on Sat Jun 09 2001 - 08:18:12 CDT