Assign default value : Default Value « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Default Value

Assign default value

 
SQL>
SQL>
SQL>  declare
  2      days_in_week   constant number := 7;
  3      weeks_in_month number default 4;
  4    begin
  5      weeks_in_month := 5;
  6    end;
  7    /

PL/SQL procedure successfully completed.

SQL>








Related examples in the same category

1.using the DEFAULT keyword to assign a value to a variable:
2.avoid declaration exception for default value