Re: SQLPLUS training, why?

From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
To: gabriel.aragon@xxxxxx
Date: Thu, 23 Dec 2010 08:14:20 +0100

Oh, and perhaps one other piece of advice I personally would pass along to
junior DBAs...

Start using sql*plus as much as you can, and write your own set of scripts
for it. Because in doing so you will learn a lot that you would never learn
simply by clicking GUI buttons or by using some other scripts downloaded
over the internet.

What are you going to do if that GUI tool doesn't show you the data in a way
you need it? If you've written the scripts yourself you implicitly gain
knowledge about the source of the data you're looking at. Where it comes
from, what it's linked to, how consistent it is, what it really means, etc.
And it will be easy to present the data in another way, as you have a much
better understanding of the data you're looking at.

Stefan

=========================

Stefan P Knecht
CEO & Founder
s@xxxxxxxx

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch

=========================

On Thu, Dec 23, 2010 at 4:09 AM, Aragon, Gabriel (GE, Corporate, consultant)
<gabriel.aragon@xxxxxx> wrote:

>  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 tools?
> 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
>
>
>
>

References:
- SQLPLUS training, why?
  - From: Aragon, Gabriel (GE, Corporate, consultant)

Re: SQLPLUS training, why?

Other related posts: