Usage of concatenate and like operator in where condition

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

How to change user password in oracle

alter user XXTEST identified by testinguser

--now password was changed sucessfully