Constant

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]

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

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 #