Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
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 pondering the Monastery: (7)
As of 2014-12-21 23:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (109 votes), past polls