Oracle PL/SQL - CASE Statement

Ada 2 Macam penggunaan CASE statement di PL/SQL, yaitu:

• CASE Menggunakan Selector / Pilihan
• CASE tanpa Selector

CASE Statement Menggunakan Selector

Sintak Dasar :

CASE pilihan  
   WHEN nilai-1 
 THEN statement-1;
   WHEN nilai-2
 THEN statement-2;
   ELSE
 statement-3;
END CASE

Contoh :

DECLARE
   hari number := 1;
BEGIN
   CASE hari 
 WHEN 1 THEN
    DBMS_OUTPUT.PUT_LINE('Senin'); 
 WHEN 2 THEN
    DBMS_OUTPUT.PUT_LINE('Selasa'); 
 WHEN 3 THEN
    DBMS_OUTPUT.PUT_LINE('Rabu');
 WHEN 4 THEN
    DBMS_OUTPUT.PUT_LINE('Kamis');
 WHEN 5 THEN
    DBMS_OUTPUT.PUT_LINE('Jumat');
 WHEN 6 THEN
    DBMS_OUTPUT.PUT_LINE('Sabtu');  
 ELSE
    DBMS_OUTPUT.PUT_LINE('Minggu'); 
 END CASE; 
END;
/

CASE Statement Tanpa Selector

Sintak Dasar :

CASE
   WHEN kondisi-1 THEN 
	statement-1;
   WHEN kondisi-2 THEN 
	statement-2;
   ELSE
	statement-3;
END CASE;

Contoh :

DECLARE
   hari number := 1;
BEGIN
   CASE hari 
 WHEN hari = 1 THEN
    DBMS_OUTPUT.PUT_LINE('Senin'); 
 WHEN hari = 2 THEN
    DBMS_OUTPUT.PUT_LINE('Selasa'); 
 WHEN hari = 3 THEN
    DBMS_OUTPUT.PUT_LINE('Rabu');
 WHEN hari = 4 THEN
    DBMS_OUTPUT.PUT_LINE('Kamis');
 WHEN hari = 5 THEN
    DBMS_OUTPUT.PUT_LINE('Jumat');
 WHEN hari = 6 THEN
    DBMS_OUTPUT.PUT_LINE('Sabtu');  
 ELSE
    DBMS_OUTPUT.PUT_LINE('Minggu'); 
 END CASE; 
END;
/

Sekian tutorial tentang CASE Statement di PL/SQL, semoga bermanfaat.