Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: REGEXP_LIKE W/DBI

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

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.


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

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (11)
As of 2014-10-20 12:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (76 votes), past polls