Oracle PL/SQL入门学习

1. Case用法

declare
b1  VARCHAR2(50);

BEGIN
  b1 := 'd';
  CASE b1
    WHEN 'b' THEN DBMS_OUTPUT.put_line('b');
    WHEN 'c' THEN DBMS_OUTPUT.put_line('c');
    else   DBMS_OUTPUT.put_line('none'); --if none is matched, then run else
    END case;
END;

还有一种写法：

declare
b1  VARCHAR2(50);

BEGIN
  b1 := 'c';

  CASE 
    WHEN b1 = 'b' THEN DBMS_OUTPUT.put_line('b');
    WHEN b1 = 'c' THEN DBMS_OUTPUT.put_line('c');
    else   DBMS_OUTPUT.put_line('none'); --if none is matched, then run else
    END case;
END;

2.