Use of REGEXP_LIKE [message #338529] |
Tue, 05 August 2008 05:20  |
Olivia
Messages: 519 Registered: June 2008
|
Senior Member |
|
|
I need to know which would be feasible in 10g.
select distinct(CPR_ID) from CPR_TBL where REGEXP_LIKE(CPR_ID,'[J|M]*.zip$')
SELECT Distinct (CP_ID) from CPR_TBL WHERE ( CPR_ID like 'J%.zip' or CPR_ID like 'M%.zip')
Please kindly let me know if anything found wrong.
Regards,
Oli
|
|
|
|
Re: Use of REGEXP_LIKE [message #338548 is a reply to message #338540] |
Tue, 05 August 2008 05:42   |
Olivia
Messages: 519 Registered: June 2008
|
Senior Member |
|
|
Thanks for pointing out the mistake.
I need to know which would be feasible in 10g. Will both queries give same performance?
select distinct(CPR_ID) from CPR_TBL where REGEXP_LIKE(CPR_ID,'^[J|M]*.zip$')
/
select distinct(CPR_ID) from CPR_TBL where ( CPR_ID like 'J%.zip' or CPR_ID like 'M%.zip')
/
[Updated on: Tue, 05 August 2008 05:46] Report message to a moderator
|
|
|
|
Re: Use of REGEXP_LIKE [message #338585 is a reply to message #338568] |
Tue, 05 August 2008 07:07   |
Olivia
Messages: 519 Registered: June 2008
|
Senior Member |
|
|
Thanks Michel for the update.Lack of 10g environment compelled me
to put my question here.Can I get any test environment (10g) through web to test some sample sql
Thank you very much
Regards,
Oli
|
|
|
|
|