Friday, 22 November 2013

how to use like for multiple values in oracle

we can use or keyword with below  statement

(columns1 like  '%XXXX%' or column1 like '%yyyy%' or column1 like '%zzzz%') is same as