Re: SQLPLUS training, why?

From: Gints Plivna <gints.plivna@xxxxxxxxx>
To: gabriel.aragon@xxxxxx
Date: Thu, 23 Dec 2010 10:43:30 +0200

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@xxxxxx>:
> 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
>
>
>
--
//www.freelists.org/webpage/oracle-l

References:
- SQLPLUS training, why?
  - From: Aragon, Gabriel (GE, Corporate, consultant)

Re: SQLPLUS training, why?

Other related posts: