这样子不知行不行? declare b varchar2(10); begin select zd into b from table; if zd="" then ..... end if; end if;
IF (( :OLD.REQ_STATUS = 'U' ) AND ( :NEW.REQ_STATUS = 'A')) AND (:OLD.REQ_FROMRENTITY='COMP') THEN SELECT PRV_VALUE INTO BGSQH FROM R5PROPERTYVALUES WHERE PRV_CODE = :OLD.REQ_CODE AND PRV_PROPERTY = 'BGSQH' AND PRV_RENTITY = 'REQ' ; IF BGSQH IS NULL 这里判断查询记录是否为空
declare b varchar2(10);
begin
select zd into b from table;
if zd="" then
.....
end if;
end if;
SELECT PRV_VALUE INTO BGSQH
FROM R5PROPERTYVALUES
WHERE PRV_CODE = :OLD.REQ_CODE
AND PRV_PROPERTY = 'BGSQH'
AND PRV_RENTITY = 'REQ' ;
IF BGSQH IS NULL
这里判断查询记录是否为空