在游标循环的时候 如果日期类型为空 就报ORA-01840错误 怎么解决
------解决方案--------------------
实测数据:
- SQL code
CREATE TABLE T142( ID NUMBER(4), Des VARCHAR2(20));INSERT INTO T142 VALUES(1, 'A');INSERT INTO T142 VALUES(2, NULL);INSERT INTO T142 VALUES(3, 'C');COMMIT;
CREATE TABLE T142( ID NUMBER(4), Des VARCHAR2(20));INSERT INTO T142 VALUES(1, 'A');INSERT INTO T142 VALUES(2, NULL);INSERT INTO T142 VALUES(3, 'C');COMMIT;