Re: SQLPLUS training, why?

  • From: "Daniel W. Fink" <daniel.fink@xxxxxxxxxxxxxx>
  • To: Oracle L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 27 Dec 2010 14:25:24 -0700

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 <mailto: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