Mega Code Archive

 

Categories / Oracle PLSQL / PL SQL

 

Basic PLSQL program block

SQL> SQL> DECLARE   2      x NUMBER;   3  BEGIN   4      x := 10;   5   6      DBMS_OUTPUT.PUT_LINE('X='||x);   7  END;   8  / X=10 PL/SQL procedure successfully completed. SQL>