Declare initialized constant number : Constant Number « PL SQL « Oracle PL / SQL






Declare initialized constant number

 

SQL>
SQL>
SQL>
SQL> -- declare initialized constant number
SQL>
SQL>   declare
  2      l_number_constant  constant number := 50;
  3    begin
  4      null;
  5      dbms_output.put_line(l_number_constant);
  6    end;
  7    /
50

PL/SQL procedure successfully completed.

SQL>
SQL>
           
         
  








Related examples in the same category

1.Change constant number
2.you must initialize the constant at the time of declaration
3.declare number constant uninitialized
4.This script demonstrates constants