PL/SQL Programming eBook for free - and legal!

Just as an added note – and this probably goes without saying - you
probably want to do a check to see if the value you are searching for exists
first, if it does then do the task otherwise set some default value.

A substr starting at a position of 0 will give you the entire string.

Roger S.