🧱 PL/SQL Blocks
Anonymous blocks, procedures and functions: the building blocks of PL/SQL.
| Snippet | |
|---|---|
| ☆Anonymous Block — Simplest executable PL/SQL block |
BEGIN DBMS_OUTPUT.PUT_LINE('Hello World'); END;
|
| ☆DECLARE + SELECT INTO — Declare variables and fetch into them |
DECLARE v_count NUMBER; BEGIN SELECT COUNT(*) INTO v_count FROM employees; DBMS_OUTPUT.PUT_LINE(v_count); END;
|
| ☆Procedure — Named stored procedure |
CREATE OR REPLACE PROCEDURE greet IS BEGIN DBMS_OUTPUT.PUT_LINE('Hi'); END;
|
| ☆Function — Function returning a value |
CREATE FUNCTION double_salary (sal NUMBER) RETURN NUMBER IS BEGIN RETURN sal * 2; END;
|
| ☆Exception Block — Block with an exception handler |
BEGIN NULL; EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('Error occurred'); END;
|