DECLARE CURSOR MY_CURSOR IS SELECT SYSDATE AS MY_DATE FROM DUAL UNION SELECT NULL FROM DUAL; MY_REC MY_CURSOR%ROWTYPE; BEGIN OPEN MY_CURSOR; LOOP FETCH MY_CURSOR INTO MY_REC; EXIT WHEN MY_CURSOR%NOTFOUND; IF MY_REC.MY_DATE IS NULL -----------> 判断空值 THEN DBMS_OUTPUT.PUT_LINE('IS NULL!!!'); END IF; END LOOP; CLOSE MY_CURSOR; END;
CURSOR MY_CURSOR IS
SELECT SYSDATE AS MY_DATE
FROM DUAL
UNION
SELECT NULL
FROM DUAL;
MY_REC MY_CURSOR%ROWTYPE;
BEGIN
OPEN MY_CURSOR;
LOOP
FETCH MY_CURSOR
INTO MY_REC;
EXIT WHEN MY_CURSOR%NOTFOUND;
IF MY_REC.MY_DATE IS NULL -----------> 判断空值
THEN
DBMS_OUTPUT.PUT_LINE('IS NULL!!!');
END IF;
END LOOP;
CLOSE MY_CURSOR;
END;
会报错的