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

On Fri, 12 Nov 2004 13:13:30 -0600, Post, Ethan <ethan.post_at_ps.net> wrote:
> presume
>
> x.text :=3D 'blah BLAH DBMS_OUTPUT.put_line(''foo'');'
>
> The following line...
>
> x.text :=3D replace(x.text,'dbms_output.put_line','pltrack.put_line');
>
> does not work because DBMS_OUTPUT is upper case.
>
> I want this to work and the easiest method I see is to use UPPER or
> LOWER but then I have change the entire line and I do not want to do
> that. Beside that I have to do some sort of INSTR, SUBSTR which I can
> do but I am hoping there is any easier way to do replace with case
> insensitivity.
>
> Oracle 9.2.0.4
>
> --
> http://www.freelists.org/webpage/oracle-l
>

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