Re: Should Be Simple Right
- From: Jared Still <jkstill@xxxxxxxxx>
- To: ethan.post@xxxxxx
- Date: Fri, 12 Nov 2004 15:20:05 -0800
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@xxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
