RE: SQLPLUS training, why?
Date: Mon, 27 Dec 2010 14:01:40 -0500
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887F0D035217_at_us-bos-mx022.na.pxl.int>
Humm, forgot about PL/SQL. Could not live a day without it. Remember when we use to use sql to create sql command files? Well, same thing works, a lot better, through an anonymous pl/sql block.
Dick Goulet
Senior Oracle DBA
From: Don Seiler [mailto:don_at_seiler.us]
Sent: Monday, December 27, 2010 12:03 PM
To: Goulet, Richard
Cc: Taylor, Chris David; gabriel.aragon_at_ge.com; oracle-l_at_freelists.org
Subject: Re: SQLPLUS training, why?
When I started my new job 2 years ago, I made it a point to use sqlplus for everything that I could, to break my dependency on TOAD and TORA and the like. I've learned so much doing so, it's the best decision I've ever made. Learning about the important V$ views to query for different problems, rather than seeing only what a specific GUI screen will show you, learning PL/SQL, etc. Plus formatting etc, I would definitely recommend using sqlplus for automated reports as much as possible.
Don.
On Mon, Dec 27, 2010 at 10:45 AM, Goulet, Richard <Richard.Goulet_at_parexel.com> wrote:
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'oracle-l_at_freelists.org'
[mailto:ChrisDavid.Taylor_at_ingrambarge.com]
Sent: Monday, December 27, 2010 11:28 AM To: Goulet, Richard; 'gabriel.aragon_at_ge.com';
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_at_ingrambarge.com
<mailto:chris.taylor_at_ingrambarge.com>
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Goulet, Richard
Sent: Monday, December 27, 2010 10:05 AM To: gabriel.aragon_at_ge.com; oracle-l_at_freelists.org Subject: RE: SQLPLUS training, why? Gabriel, My first question on this would be something like "Why don'tthey 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Aragon, Gabriel (GE,
Corporate, consultant)
Sent: Wednesday, December 22, 2010 10:09 PM To: oracle-l_at_freelists.org Subject: SQLPLUS training, why? Hi list, I have been asked to give a sqlplus training to some junior andjunior+ 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:
- Im sure nobody is exploding all features available in SQLPLUS.
- What would you do if you have to work in a company which is not able to pay for nice tools?
- 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
-- Don Seiler http://www.seiler.us -- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 27 2010 - 13:01:40 CST