Re: REGEXP_LIKE W/DBI

[erix]

Why post the SQL? The SQL does work. You tested it yourself. (I did too, see below).

That reduces your question to "it doesn't work" while you give absolutely no further information about wat 'it' might be.

You should post the perl DBI code that fails (ideally, a self-contained example of that failure).

I tested your query on oracle 11 too (see this):

SQLfiddle.com uses oracle 11 too:

in SQLfiddle's left-hand pane:

create table t (note_tx varchar2(100));

and in the right-hand pane:

insert into t values ('1st: XX Merged From: Vendor: Acme Corp 1');
insert into t values ('2nd: CA Merged From: Vendor: Acme Corp 2');

select *
from t
where REGEXP_LIKE(note_tx, 'CA\s+\n?Merged\s+\n?From:\s+\n?Vendor:');

which displays the second record, as expected.