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.

On Tue, 02 May 2006 05:55:21 -0700, Procrastinator wrote:

You can use it in any organization that does not permit third party tools
to be installed.

Then again, why use Toad instead of SQL Develoepr?

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting [replies] guarantees I won't respond. ***

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

http://www.oracle.com/technology/pro...per/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 (DOT) 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

sql*plus is always available, you don't need the overhead of a
graphical environment, and you can do anything you want.
As you can spool your output to HTML, and isql*plus does this by
default, your concerns are unjustified.
Also: Toad can't write reports.

--
Sybrand Bakker
Senior Oracle DBA

<sybrandb (AT) yahoo (DOT) com> wrote

: sql*plus is always available, you don't need the overhead of a
: graphical environment, and you can do anything you want.
: As you can spool your output to HTML, and isql*plus does this by
: default, your concerns are unjustified.
: Also: Toad can't write reports.
:
: --
: Sybrand Bakker
: Senior Oracle DBA
:

actually, TOAD includes a report writer now, and (AFAIK) even the free
version can do very basic reporting and output to HTML

++ mcs

"HansF" <News.Hans (AT) telus (DOT) net> wrote

: On Tue, 02 May 2006 05:55:21 -0700, 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.
: >
:
: You can use it in any organization that does not permit third party tools
: to be installed.
:
: Then again, why use Toad instead of SQL Develoepr?
:
: --
: Hans Forbrich
: Canada-wide Oracle training and consulting
: mailto: Fuzzy.GreyBeard_at_gmail.com
: *** Top posting [replies] guarantees I won't respond. ***

Hans,

I got real excited about SQL Developer when it went beta -- but it still has
a ways to go.

There's some basic things they just didn't get right -- like the ability to
open a saved pl/sql program to a procedure edit window, and a usable data
maintenance grid.

It's still a matter of you get what you pay for -- I hope the dev team
follows through on a promising start, but if they can't get basic day-to-day
functionality right pretty soon, SQL-Dev is really starting to lose its
shine for me.

++ mcs

On Tue, 02 May 2006 10:16:56 -0400, Mark C. Stock wrote:

As did I - and you are right that even prod release 1 has 'opportunities
for improvement' <tm>

Then again ... how long has it been out? and how long has Toad been out?
In that context, I'm impressed. (Just don't drop the ball, Oracle.)

It depends on what your 'day to day' stuff includes. I very much prefer
SQL*Plus for 99% of the day to day that I do.

I find SQL Developer is an adequate 'hey, look at this' tool, and I have
it on my [*nix] desktop for the few times I want to access it ... mainly
for demos and to inspect [basic] dictionary stuff. Price is right for
that, and it saves firing up some of the alternatives I trend to use.

If, as you say, 'they' continue with dev as promised, it has the markings
of a great tool in the long run. Heck, even I have asked for features

So - right now, it's adequate. And supported at no added charge, under my
current support contract. (Although you may note that I have been
deliberately avoiding contributing to the 'Support sucks' thread. <g>)


All that said, the big advantage of SQLPlus - as a consultant, I like the
'warm fuzzy' of knowing that the tool I need is in any customer's shop.

And that will likely soon extend to SLQ Developer, if Oracle includes it
on their CDs.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting [replies] guarantees I won't respond. ***

"HansF" <News.Hans (AT) telus (DOT) net> wrote

: On Tue, 02 May 2006 10:16:56 -0400, Mark C. Stock wrote:
:

: All that said, the big advantage of SQLPlus - as a consultant, I like the
: 'warm fuzzy' of knowing that the tool I need is in any customer's shop.
:
: And that will likely soon extend to SLQ Developer, if Oracle includes it
: on their CDs.
:
: --

I often find myself going into SQL*P from other tools when I don't believe
the error reporting of the other tool (or it doesn't show the whole stack,
or doesn't identify the line and column of the error.

Re: availability -- depending on customer policy, SQL*D is small enough to
carry around on your USB memory stick and doesn't require an environment...
I better stop, I'm starting to say nice things about it again ;-)

++ mcs

On Tue, 02 May 2006 10:51:47 -0400, Mark C. Stock wrote:

Usefulf for those customers who actually allow you to plug in a USB
memory stick.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting [replies] guarantees I won't respond. ***

Procrastinator wrote:
Available where-ever Oracle is installed.

Works the same on all operating systems and platforms.

Works the same in every country with every language.

Works the same with every version of Oracle.

Always current to the current versions functionality.

Exposes the user to what is actually happening and where it
is stored producing more qualified, better educated, users.

In short: Job security.

Daniel Morgan
www.psoug.org