Re: SQLPLUS training, why?

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Thu, 23 Dec 2010 08:14:20 +0100
Message-ID: <AANLkTimNP8gcZ=3W4wPHv2ofEnDG8fhX0SxP=qrTZEDd_at_mail.gmail.com>

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_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

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

---

On Thu, Dec 23, 2010 at 4:09 AM, Aragon, Gabriel (GE, Corporate, consultant) <gabriel.aragon_at_ge.com> 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
>
>
>
>

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

Received on Thu Dec 23 2010 - 01:14:20 CST