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