No initial value but Has a size : Variable init « PL SQL « Oracle PL / SQL






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

No initial value but Has a size

SQL>
SQL> -- No initial value but Has a size.
SQL> set serverout on;
SQL>
SQL> DECLARE
  2     X NUMBER(11,2);
  3
  4  BEGIN
  5
  6
  7     DBMS_OUTPUT.PUT_LINE(x);
  8
  9  END;
 10  /

PL/SQL procedure successfully completed.

SQL>








Related examples in the same category

1.An initialization using the assignment operator (:=)
2.Assign init value to a number
3.Declare variables to be used in the block