Re: SQLPLUS training, why?

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 23 Dec 2010 07:56:10 -0600
Message-ID: <AANLkTi=1+WZ78ye3=YKjJ9vxtwRmNsLo_sSky4X_9=Xt_at_mail.gmail.com>

At its most basic, the answer is that if you use tools instead of sqlplus, you lean how but you never learn why.

On Thu, Dec 23, 2010 at 3:07 AM, OKH <okh_at_oraconsult.de> wrote:

> Hi
>
> U*nix guys don't ask why to use shell.
>
> sqlplus is not only a command line interface but also "glue" for
> programming scripts and concatenating steps. you can bring in interactivity
> and error handling, etc. It is like shell programming. Most of the
> "script"-features are not available in GUI tools. And like others already
> mentioned, you can use it wherever you go. As a freelancer you cannot count
> on tools - just SQL*plus. Take a look at Tanel Poders script library ... at
> all his snapper-tool. Probably you can convince them with its outstanding
> way how he programmer it.
>
> Merry Christmas
>
>
>
> Felix
>
> Am 23.12.2010 um 04:09 schrieb "Aragon, Gabriel (GE, Corporate,
> consultant)" <gabriel.aragon_at_ge.com>:
>
> Hi list,
>
> I have been asked to give a sqlplus training to some junior and junior+
> DBA's, since Im expecting the first question to be:
>
> "I know how to run most common DML/DDL/etc commands so, why do I need to
> take a sqlplus training to format output or generate reports when there is a
> lot of tools which can help me to access database w/o using manual input?"
>
> and I have thought some answers like:
>
> 1. Im sure nobody is exploding all features available in SQLPLUS.
> 2. What would you do if you have to work in a company which is not able to
> pay for nice tool
> 3. Knowledge on SQLPLUS would help you to get a better understanding of
> oracle database.
>
> and so on..
>
> but I would like to hear some feedback from you guys, why a sqlplus
> training is important?
>
> TIA
> Gabriel
>
>
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 23 2010 - 07:56:10 CST