Re: Should Be Simple Right

sed -e 's/dbms_output.put_line/dbms_output.putline/i' \   -e 's/dbms_output.put/dbms_output.put/i' \  oldfile > newfile

Or edit in place

perl -pi.bak -e '$_=lc($_)' filename

perl -pi.bak -e \
 's/dbms_output.put_line/dbms_output.put_line/i;s/dbms_output.put/dbms_output.put/i' \
  filename

Either will catch all of them.

Jared

On Sat, 13 Nov 2004 06:29:32 -0600, Post, Ethan <ethan.post_at_ps.net> wrote:
> I am writing a package that adds a bunch of instrumentation to existing
> PL/SQL packages. There is no real debugging in this app so one thing it
> will do is replace all the existing DBMS_OUTPUT calls with a new call
> which sends the info to a text file. This will allow developers/qa to
> debug a bit easier. In VB the default behavior for replace is to ignore
> case. I guess before I resort to perl I will just do it the quick/dirty
> way which is to run replace for "DBMS_OUTPUT...,dbms_output...,etc..."
> That will catch 90% of them.
>
>
>
> -----Original Message-----
> From: Jared Still [mailto:jkstill_at_gmail.com]
> Sent: Friday, November 12, 2004 5:20 PM
> To: Post, Ethan
> Cc: oracle-l_at_freelists.org
> Subject: Re: Should Be Simple Right
>
> Hi Ethan,
>
> You have provided precious little context here.
>
> Given that lack of information, the only possible response
> I can make is 'Do it with Perl'.
>
> PL/SQL is notoriosly poor for text handling, while Perl
> is incredibly good for text handling.
>
> Jared
>
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l