SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to achive equivalent of contains in java using Like operator

deekayAug 2 2012 — edited Aug 2 2012

Hi,

Could anyone please enlighten me on this issue.
I need to achieve through the query to reduce the unnecessary of loop through.

Lets say:
I have a table called BLACKLISTPASSWORD with column BPW.
example record in column (BPW)
Welcome
Welcome1
Welcome123

I want make a query like 

SELECT BPW
FROM BLACKLISTPASSWORD 
WHERE lower(BPW) LIKE 'welcome1234%'

Expecting a result true if any sequence matches in above case expecting true bcz Welcome123 is there in DB.
Plz correct me in the query to achieve this.

Edited by: Deekay on Aug 2, 2012 12:40 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 30 2012

Added on Aug 2 2012

5 comments

405 views