Re: SQL *PLus

Procrastinator wrote:
> What's the advantage of using SQL Plus over other tools like Toad.
> Its extremely difficult/cumbersom and output seems very bad. Is there
> anything you can do with SQL Plus that you cant do with Toad.
>
> Thx.
>

If you prefer Toad, then have a look at Oracle's new SQL Developer:

http://www.oracle.com/technology/products/database/sql_developer/index.html

It's a lot like Toad and it is free.

There are still uses for SQL*Plus. SQL*Plus is a command line tool. As such, you can perform server-side scripting. My user-managed hot backup scripts interact with the database and the OS in interleaved steps. I have a shell script which does database calls with SQL*Plus and still does OS calls to copy datafiles. To me, the biggest power of SQL*Plus is that it is a command-line utility that works great in server-side scripts.

To me, SQL*Plus is faster too. I can typically write a query and see my results much quicker than in Toad or SQL Developer.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown