Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change


by erix (Vicar)
on May 29, 2014 at 22:39 UTC ( #1087889=note: print w/ replies, xml ) Need Help??

in reply to REGEXP_LIKE W/DBI

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): 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.

Comment on Re: REGEXP_LIKE W/DBI
Select or Download Code

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1087889]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (10)
As of 2015-11-30 06:11 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (758 votes), past polls