Saturday, 26 September 2015

Usage of concatenate and like operator in where condition

select * from ORG_ORGANIZATION_DEFINITIONS where ORGANIZATION_NAME like '%' || :your_var || '%'

No comments:

Post a Comment