Re: Should Be Simple Right

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: "Post, Ethan" <>
  • Date: Sat, 13 Nov 2004 15:04:45 -0800

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  \ 

Either will catch all of them.


On Sat, 13 Nov 2004 06:29:32 -0600, Post, Ethan <> 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@xxxxxxxxx]
> Sent: Friday, November 12, 2004 5:20 PM
> To: Post, Ethan
> Cc: oracle-l@xxxxxxxxxxxxx
> 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

Other related posts: