Re: SQLPLUS training, why?

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_at_roughsea.com>
To: oracle-l_at_freelists.org
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_at_nationwide.com 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_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