Re: SQLPLUS training, why?

From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
To: sfaroult@xxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
Date: Tue, 28 Dec 2010 07:10:24 -0800 (PST)

Yes and then some...  considering the technical level of many who will be 
attending, do you really want them playing around with regular expressions??  I 
was referring to ones who might use MSWord, Text editors and Excel spreadsheets 
to create SQL that could be easily generated inside SQL Plus.  When I picture 
these folks, I would never consider just throwing them into the deep end of the 
pool with RE's and say, "Swim!" :)

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




________________________________
From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Tue, December 28, 2010 7:07:11 AM
Subject: Re: SQLPLUS training, why?

But I think that Kellyn's point was that improper use of regular expressions is 
the source of many clbuttic errors ...


Stephane Faroult
RoughSea Ltd
Konagora
RoughSea Channel on Youtube

On 12/28/2010 02:24 PM, TESTAJ3@xxxxxxxxxxxxxx wrote: 

>:1,$ s/old_string/new_string/  <--- REs are your friend :) 
>
>joe 
>
>_______________________________________
>Joe Testa, Oracle Certified Professional 
>Senior Engineering & Administration Lead
>(Work) 
>614-677-1668begin_of_the_skype_highlighting            614-677-1668      
>end_of_the_skype_highlighting
>
>(Cell) 
>614-312-6715begin_of_the_skype_highlighting            614-312-6715      
>end_of_the_skype_highlighting
>
>
>
> 
>
>
>
>From:  "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>  
>To:  "'kjped1313@xxxxxxxxx'" <kjped1313@xxxxxxxxx>, 
>"'daniel.fink@xxxxxxxxxxxxxx'" <daniel.fink@xxxxxxxxxxxxxx>, 'Oracle L' 
><oracle-l@xxxxxxxxxxxxx>  
>
>Date:  12/28/2010 08:05 AM  
>Subject:  RE: SQLPLUS training, why?  
>Sent by:  oracle-l-bounce@xxxxxxxxxxxxx 
>________________________________
 
>
>
>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 
>  
>  
>  
>
>________________________________

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

Follow-Ups:
- Re: SQLPLUS training, why?
  - From: Nuno Souto

References:
- SQLPLUS training, why?
  - From: Aragon, Gabriel (GE, Corporate, consultant)
- 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?
  - From: Taylor, Chris David
- RE: SQLPLUS training, why?
  - From: TESTAJ3
- Re: SQLPLUS training, why?
  - From: Stephane Faroult

Re: SQLPLUS training, why?

Other related posts: