描述不完整,建议上代码看看

基本的东西，建议先找本Oracle PL/SQL的书来看看吧

declare
cursor ca is select code from tb_city_basic where province='AMS';
xx tb_city_basic.code%type;
begin
open ca;
fetch ca into xx;
if ca%found then
dbms_output.put_line('cursor');
dbms_output.put_line('not empty');
end if;
end;
/

PL/SQL procedure successfully completed.

declare
cursor ca is select code from tb_city_basic where province='新疆';
xx tb_city_basic.code%type;
begin
open ca;
fetch ca into xx;
if ca%found then
dbms_output.put_line('cursor');
dbms_output.put_line('not empty');
end if;
end;
/
cursor
not empty

第一种是CURSOR为空的情况，第二种是非空的