17,140
社区成员




select * from meet_info where miuiname like '%'||varname||'%';
select * from meet_info where miuiname like '%'||%varname||'%'
declare
l_varname varchar2(100) := 'SMITH';
l_sql varchar2(100);
l_cnt int;
begin
l_sql := 'select count(*) from emp where ename like ''%' || l_varname || '%''';
dbms_output.put_line(l_sql);
execute immediate l_sql into l_cnt;
dbms_output.put_line(l_cnt);
end;