create or replace
procedure cursor_proc
as
cursor l_cur is select ename from emp;
l_count number:=0;
begin
for v_cur in l_cur loop
if(v_cur.ename IS NOT NULL)then
select COUNT(*) into l_count from DUAL where regexp_like(V_CUR.ENAME,'PortA$');
if(l_count <> 0)then
dbms_output.put_line('房价也太高了');
else
dbms_output.put_line('其他处理');
end if;
end if;
end loop;
end;
