SQL Plus Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. SQL Plus
  4. Define variable and print its value out
SQL> VARIABLE x NUMBER
SQL> BEGIN
  2     :x := 1;
  3  END;
  4  /
PL/SQL procedure successfully completed.
SQL> PRINT :x;
         X
----------
         1
SQL>
SQL>