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>

Related examples in the same category

1.	refcursor varible
2.	Save returning value from a function to a variable
3.	Define variable and set value
4.	Define variable and use it in sql statement
5.	Bind variables can be declared in your SQL*Plus script,Preface a bind variable with a colon to reference it in a PL/SQL block
6.	Bind variables can even be referenced by SQL queries
7.	Undefine variable
8.	User defined-variable in update set statement

Define variable and print its value out : variable « SQL Plus « Oracle PL / SQL

Related examples in the same category