passing a variable within in stored a procedure
This is an example of my question.. When I format my LIKE clause (see below) ... it doesn't bring back anything because it is looking for the word var1
create or replace s_proc (var1 in varchar2) as
cursor c1 is
select column1, column2
from table1
where column1 like('%var1%') >>>> how do I format this where clause with a like statement ???
;
rec1 c1%rowtype;
begin
whatver ...
end
0