Re: SQLPLUS training, why?

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Thu, 23 Dec 2010 10:43:30 +0200
Message-ID: <AANLkTimK25svi6A3ghOEWGwbi-Hsmpjzf6-bPUfo3R5Y_at_mail.gmail.com>



As I'm developer and not DBA, I can also follow previous argument of SQL*Plus which is everywhere. Yes mostly now I'm using PL/SQL Developer in my organization, but I'm trying not to forget SQL*Plus because:
1) There were cases when I had to be on a client's site without PL/SQL Developer, Toad or whatever else GUI tool. Rare cases but at least a few. For example recently our consultant DBA installed Oracle for a client, I could login through VPN, Putty or whatever these tools where :) and access next production Oracle only via SQL*Plus. 2) all installations for our developed App Oracle code are as SQL*Plus scripts. Easy configurable, runs on Linux, AIX, Windows whatver OS wher Oracle server for our apps are installed. 3) thanks to SQL*Plus I know at least basic syntax for create table, constraint, index (and probably something more) as well as alter, drop etc. So in case of emergency I don't need to look in docs for basic things.
4) SQL*Plus scripts and their results are very cool for demonstrations - easy to show both used statements and results of the statement.

Gints Plivna
http://www.gplivna.eu

2010/12/23 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 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 23 2010 - 02:43:30 CST

Original text of this message