create or replace xxxx is
type aaaa is ref cursor;
bbbb aaaa;
v_info emp%rowtype;
begin
open bbbb for select * from emp where ename like '%c%';
loop
exit when bbbb%notfound;
dbms_output.put_line(v_info.ename);
end loop;
end;
追问你好,是要在存储过程中创建视图(该视图是带有like模糊查询的!),上面只是表的模糊查询!