RE: SQLPLUS training, why?

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>, <gabriel.aragon@xxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 27 Dec 2010 11:45:19 -0500

Chris,
 
    Well, I suppose that term really does need definition because it
really does change by what your doing.  Yes I do learn something new
about SQL just about daily, especially with the duhvelopers we have
around here.  There are quite a few who should enter the "Obfuscated
SQL" contest.  Had a "problem" sql statement handed to me the other day.
157 lines of code, 8 sub queries, 12 dynamic view definitions, and 2
partition by clauses only to find what the max(last_trial_date) was in a
particular table for a particular trial.  And to boot the script had a
number of defines, breaks, new_column and no print statements included.
Boy was that ever fun???
 
    So back to the original question, mastery to me means that you can
read 90% of the sql your handed and make sense out of it and that you
can repair, create, or diagnose a database without the help of a GUI
because you may not have access to one.  For the remainder I'd expect
the individual to have a good understanding of where in the
documentation he/she can find what they need and understand it.  Why the
docs you say. because you may or may not have access to the net when you
most need it.  Many years ago I was faced with a broken database, a
VT100 terminal directly attached to the server, an no external network
connectivity.  Thank GOD for Palm Pilots.
 

Dick Goulet 
Senior Oracle DBA 

 

________________________________

From: Taylor, Chris David [mailto:ChrisDavid.Taylor@xxxxxxxxxxxxxxx] 
Sent: Monday, December 27, 2010 11:28 AM
To: Goulet, Richard; 'gabriel.aragon@xxxxxx'; 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: SQLPLUS training, why?



What is considered "mastery"? 

 

I think I learn something new fairly regularly using sqlplus J

 

Heck, I think I "re-learn" something I've forgotten pretty often as
well.  I'm glad there's Google or Bing or Metalink or any number of
other sites that I can quickly look up syntax when I need it.

 

I'm pretty good with sql but I am still often amazed how powerful it is
and how little I really "know".

 

Chris Taylor

Sr. Oracle DBA

Ingram Barge Company

Nashville, TN 37205

Office: 615-517-3355

Cell: 615-663-1673

Email: chris.taylor@xxxxxxxxxxxxxxx
<mailto:chris.taylor@xxxxxxxxxxxxxxx> 

 

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential
and may also be privileged. If you are not the named recipient, please
notify the sender immediately and delete the contents of this message
without disclosing the contents to anyone, using them for any purpose,
or storing or copying the information on any medium.

 

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Goulet, Richard
Sent: Monday, December 27, 2010 10:05 AM
To: gabriel.aragon@xxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: SQLPLUS training, why?

 

Gabriel,

 

    My first question on this would be something like "Why don't they
already have a mastery of SQL*Plus and SQL?".  I'd think that that would
be a pre-req for being able to work as a DBA in the first place.  But
assuming that they don't have that mastery then the more you know about
what your managing and using, the better you are at it.

 

Dick Goulet 
Senior Oracle DBA 

 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Aragon, Gabriel (GE,
Corporate, consultant)
Sent: Wednesday, December 22, 2010 10:09 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: SQLPLUS training, why?

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2010