like condition in pl/sql procedure
899280Mar 22 2012 — edited Mar 22 2012I have a procedure with below if clause.
If user_name ='ABC' then
insert into ...........
...........
end if
I want to check if user_name like '%BC' then. How can I add like condition in this l'if' oop.
Please help