declare number constant uninitialized : Constant Number « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Constant Number

declare number constant uninitialized

  
SQL>
SQL>  declare
  2      myNumber_constant constant number;
  3    begin
  4      null;
  5    end;
  6    /
    myNumber_constant constant number;
    *
ERROR at line 2:
ORA-06550: line 2, column 5:
PLS-00322: declaration of a constant 'MYNUMBER_CONSTANT' must contain an initialization assignment
ORA-06550: line 2, column 23:
PL/SQL: Item ignored


SQL>








Related examples in the same category

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