Re: '%' in variable used in like clause (PL/SQL)

You don't use val in your query.
val is char, not varchar2, so it is right blank-padded, and like won't match.
Use val varchar2(10), if you want to use it. --
 Alexander I.Doroshko, aid_at_grant.kharkov.ua

• Bank "Grant", Kharkov, Ukraine Vrajesh Patel <vrajesh.patel_at_mci.com> wrote in article <371F4211.AC8B0403_at_mci.com>...
  : You query should definitely work. As, I tried the same from me as
  follows.
  :
  : set serverout on
  :
  : declare
  : val char(10);
  : res integer;
  : begin
  : val:='%';
  : select count(*) into res from temp where name like '%';
  : dbms_output.put_line(res);
  : end;
  : /
  :
  : and table has five records and displayed all.