RE: SQLPLUS training, why?

From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
To: "'kjped1313@xxxxxxxxx'" <kjped1313@xxxxxxxxx>, "'daniel.fink@xxxxxxxxxxxxxx'" <daniel.fink@xxxxxxxxxxxxxx>, 'Oracle L' <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 28 Dec 2010 07:02:38 -0600

I prefer vim (or gvim if I'm in windows) to screw up my statements...

;)

Chris


From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Kellyn Pedersen
Sent: Monday, December 27, 2010 7:05 PM
To: daniel.fink@xxxxxxxxxxxxxx; Oracle L
Subject: Re: SQLPLUS training, why?

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<http://www.dbakevlar.blogspot.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<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<http://www.avg.com>
Version: 9.0.872 / Virus Database: 271.1.1/3342 - Release Date: 12/27/10 
00:34:00

Follow-Ups:
- RE: SQLPLUS training, why?
  - From: TESTAJ3

References:
- SQLPLUS training, why?
  - From: Aragon, Gabriel (GE, Corporate, consultant)
- RE: SQLPLUS training, why?
  - From: Goulet, Richard
- RE: SQLPLUS training, why?
  - From: TESTAJ3
- Re: SQLPLUS training, why?
  - From: Jared Still
- Re: SQLPLUS training, why?
  - From: coskan
- RE: SQLPLUS training, why?
  - From: Goulet, Richard
- RE: SQLPLUS training, why?
  - From: Taylor, Chris David
- RE: SQLPLUS training, why?
  - From: Jacques Kilchoer
- Re: SQLPLUS training, why?
  - From: Jared Still
- Re: SQLPLUS training, why?
  - From: Daniel W. Fink
- Re: SQLPLUS training, why?
  - From: Kellyn Pedersen

RE: SQLPLUS training, why?

Other related posts: