oracle中控制语句的示例

suqv1g1inj

DECLARE
grade VARCHAR2(2);
BEGIN
grade := '&grade';
CASE
WHEN grade='A' THEN DBMS_OUTPUT.PUT_LINE('优异');
WHEN grade='B' THEN DBMS_OUTPUT.PUT_LINE ('优秀');
WHEN grade='C' THEN DBMS_OUTPUT.PUT_LINE ('良好');
WHEN grade='D' THEN DBMS_OUTPUT.PUT_LINE ('一般');
WHEN grade='E' THEN DBMS_OUTPUT.PUT_LINE ('较差');
ELSE DBMS_OUTPUT.PUT_LINE ('没有此成绩');
END CASE;
END;
/
BEGIN
LOOP
IF &marks > 60 THEN
DBMS_OUTPUT.PUT_LINE('该生已通过');
EXIT;
END IF;
END LOOP;
END;
/
DECLARE
MONTHLY_VALUE NUMBER := 0;
DAILY_VALUE NUMBER:=0;
BEGIN
WHILE monthly_value <= 4000
LOOP
monthly_value := daily_value * 31;   
daily_value := daily_value + 10;  
dbms_output.put_line('每日销量：' || daily_value);  
END LOOP;
dbms_output.put_line('每月销量：' || monthly_value);
END;


<style type="text/css">.csharpcode, .csharpcode pre
{font-size: small;color: black;font-family: consolas, "Courier New", courier, monospace;background-color: #ffffff;/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{background-color: #f4f4f4;width: 100%;margin: 0em;
}
.csharpcode .lnum { color: #606060; }
</style>