DECLARE
v_ID CHAR(5);
v_Value NUMBER;
v_Arcount NUMBER;
BEGIN
SELECT id,value
INTO v_ID,v_Value
FROM TTR
WHERE value=1;
DBMS_OUTPUT.PUT_LINE(v_Value);
IF v_Value=1 THEN
SELECT count(value)
INTO v_Arcount
FROM TTR
WHERE value>1;
END IF;
DBMS_OUTPUT.PUT_LINE(v_Arcount);
END;
/
v_ID CHAR(5);
v_Value NUMBER;
v_Arcount NUMBER;
BEGIN
SELECT id,value
INTO v_ID,v_Value
FROM TTR
WHERE value=1;
DBMS_OUTPUT.PUT_LINE(v_Value);
IF v_Value=1 THEN
SELECT count(value)
INTO v_Arcount
FROM TTR
WHERE value>1;
END IF;
DBMS_OUTPUT.PUT_LINE(v_Arcount);
END;
/
或case ... when ... then ... when ... then ... else ... end
case when then是sql的语法,不过还是decode好用,用不了decode再用case 吧