RE: SQLPLUS training, why?

From: <TESTAJ3_at_nationwide.com>
Date: Tue, 28 Dec 2010 08:24:25 -0500
Message-ID: <OFDF53E402.3C8A3400-ON85257807.004997C4-85257807.0049A5C6_at_lnotes-gw.ent.nwie.net>

:1,$ s/old_string/new_string/ <--- REs are your friend :)

joe

---

Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715

From:
"Taylor, Chris David" <ChrisDavid.Taylor_at_ingrambarge.com> To:
"'kjped1313_at_yahoo.com'" <kjped1313_at_yahoo.com>, "'daniel.fink_at_optimaldba.com'" <daniel.fink_at_optimaldba.com>, 'Oracle L' <oracle-l_at_freelists.org>
Date:
12/28/2010 08:05 AM
Subject:
RE: SQLPLUS training, why?
Sent by:
oracle-l-bounce_at_freelists.org

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

;)  

Chris    

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kellyn Pedersen
Sent: Monday, December 27, 2010 7:05 PM To: daniel.fink_at_optimaldba.com; 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      

From: Daniel W. Fink <daniel.fink_at_optimaldba.com> To: Oracle L <oracle-l_at_freelists.org> 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_at_quest.com> 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  

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 28 2010 - 07:24:25 CST