RE: SQLPLUS training, why?

  • From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
  • To: "'Richard.Goulet@xxxxxxxxxxx'" <Richard.Goulet@xxxxxxxxxxx>, "'gabriel.aragon@xxxxxx'" <gabriel.aragon@xxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 27 Dec 2010 10:27:47 -0600

What is considered "mastery"?

I think I learn something new fairly regularly using sqlplus :)

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?


    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 

and so on..

but I would like to hear some feedback from you guys, why a sqlplus training is 


Other related posts: