From Oracle FAQ
Jump to: navigation, search

A constant as the name implies is a value that is not variable. It cannot be changed after it has been assigned to. By virtue of the fact that it cannot be modified a constant cannot be declared without also being initialised.

PL/SQL Example[edit]

  -- c_someConstant CONSTANT NUMBER; -- ILLEGAL since no initial value has been supplied.
  c_report_lines CONSTANT NUMBER := 80;  -- Define a numeric constant
  dbms_output.put_line('Report has '||c_report_lines||' lines');

Also see[edit]

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #