oracle中控制语句的示例

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>