Variables and Constants : Variable Declare « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Variable Declare

Variables and Constants

 
SQL>
SQL> declare
  2    myNumber_variable number;
  3  begin
  4    myNumber_variable := 50;
  5  end;
  6  /

PL/SQL procedure successfully completed.

SQL>
SQL>








Related examples in the same category

1.Declare variable as a loop counter
2.Defining the Indefinable: NULL
3.Raise the VALUE_ERROR exception
4.Raise the 'no data found' exception
5.Declare variables which will be used in SQL statements