Re: SQLPLUS training, why?

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Tue, 28 Dec 2010 15:07:11 +0100
Message-ID: <4D19EF0F.1080707_at_roughsea.com>

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_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-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_ <http://www.dbakevlar.blogspot.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_ <mailto: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_ <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
>
>

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

Received on Tue Dec 28 2010 - 08:07:11 CST