DECLARE
L_ORDERID NUMBER;
L_ITEMNO NUMBER;
BEGIN
BEGIN
SELECT EXIT(NVL(ORDERID, 0), NVL(ITEMNO, 0) INTO L_ORDERID, L_ITEMNO FROM ORDERS WHERE ORDERID = 12345;
EXCEPTION
WHEN NO_DATA_FOUND THEN
L_ORDERID := 0;
L_ITEMNO := 0;
END;
END;
NO_DATA_FOUND
最新推荐文章于 2021-04-14 23:20:04 发布