Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL PLUS Session Environment

 

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>