方法一:用聚合函数
SELECT max(xxxx) INTO v_xxx FROM xxxx;
方法二:SELECT NVL(A.xxx,'xxxx') INTO xxx
FROM DUAL LEFT JOIN(SELECT xxx
FROM xxx
WHERE xxxxxxxxx) A ON 1 = 1;
方法一:用聚合函数
SELECT max(xxxx) INTO v_xxx FROM xxxx;
方法二:SELECT NVL(A.xxx,'xxxx') INTO xxx
FROM DUAL LEFT JOIN(