Re: SQLPLUS training, why?

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Thu, 23 Dec 2010 12:08:27 -0300
Message-ID: <AANLkTimJhGVwKNsrxavP0-zZ99VqHftEUaXwBQSwQgKu_at_mail.gmail.com>

In a training session my approach would be somewhat different.

ask the attendees:

1. What do you think SQL*Plus is?
2. What can you do with SQL*Plus?
3. What tools do you currently use for your day-to-day tasks?
4. Do you think that knowing SQL*Plus would in some way improve your

productivity? <--- or perhaps: do you think that knowing SQL*Plus would allow you to do things faster and give you time to check facebook?

After you get a few answers, take them and shape them into an argument FOR sql*plus. And specially after the first two questions, take a few minutes to demonstrate what YOU can do with sql*plus (some quick formatting, perhaps something in the login.sql file as well) and show them how with very few lines you can transform the ugly output into something you could even paste into a presentation for Management.

I have taught my fair share of oracle trainings, and have found the best results when I adapted the contents somewhat to the audience. Granted, as a OU trainer you can't change the contents of a course, but you can emphasize one more than the other, take more time for a given chapter and then fast-forward through another.

HTH
Alan.-

On Thu, Dec 23, 2010 at 10:56 AM, Andrew Kerber <andrew.kerber_at_gmail.com>wrote:

> 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 - 09:08:27 CST