Re: SQLPLUS training, why?

  • From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
  • To: daniel.fink@xxxxxxxxxxxxxx, Oracle L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 27 Dec 2010 17:04:38 -0800 (PST)

Although I think I've missed 90% of this thread due to how busy I am, Dan's 
last 
choice is one I think is really valuable to those taking a SQL Plus class and 
I'll just take it just one step further-
-  Learning how to generate dynamic sql, no matter if it's ddl or dml.

If I see one more person in MS Word or Wordpad using the replace option and 
screwing up statements.  It's just painful to watch... :D


 
Kellyn Pedersen
Sr. Database Administrator
http://www.linkedin.com/in/kellynpedersen
www.dbakevlar.com
 




________________________________
From: Daniel W. Fink <daniel.fink@xxxxxxxxxxxxxx>
To: Oracle L <oracle-l@xxxxxxxxxxxxx>
Sent: Mon, December 27, 2010 2:25:24 PM
Subject: Re: SQLPLUS training, why?

Diagnose issues with Oracle supplied scripts
Modify/customize Oracle supplied scripts (such as statspack/awr/ash     
reporting)
Create a basic interactive menu
Generate ddl (with or without dbms_metadata)


On 12/27/2010 2:15 PM, Jared Still wrote: 
On Mon, Dec 27, 2010 at 12:09 PM, Jacques         Kilchoer 
<Jacques.Kilchoer@xxxxxxxxx> wrote:
>
>
>>
>>I vote yes, but how important is it to a                   DBA to know the 
>>SQL*Plus specific commands?

Only important if you want to format reports so they are           readable.
 
... or spool to .csv
... or accept input from the operator
... or declare defined/bind variables and use them to set           the value 
of 
PL/SQL variables

I sure many here can add to that list.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com

>
>  No virus found in this incoming message. Checked by AVG - www.avg.com 
>Version: 9.0.872 / Virus Database: 271.1.1/3342 - Release Date: 12/27/10 
>00:34:00
>
>

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2010