Re: SQLPLUS training, why?

  • From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 28 Dec 2010 15:07:11 +0100

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 <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>

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-1668
> (Cell) 614-312-6715
>
>
>
>
>
> 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_ <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@xxxxxxxxxx <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_ <http://jkstill.blogspot.com/>
> Home Page: _http://jaredstill.com_ <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
>  
>

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2010