Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
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.

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 taking refuge in the Monastery: (7)
As of 2016-09-27 22:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Extraterrestrials haven't visited the Earth yet because:







    Results (516 votes). Check out past polls.