Passing a variable into 'like' condition in a query

[hptse]

Simply declare a variable to hold the input string and execute the sql.

example:

create table exptest as select * from all_users;
delete exptest ;
declare
b varchar2(10);
begin
b := '%A%';
insert into exptest select * from all_users where username like b;
end;
/