PL/SQL Constant

Prev Tutorial Next Tutorial

PL/SQL Constant

AConstant is an identifier which holds data whose value can not be changed at the execution time of program.

Constant declaration


constant_name Constant datatype := value;
  • constant_name is the name of the constant it means similar to a variable name.
  • The word Constant is a reserved word and that value does not change.
  • value: value is assigned to constant when it is declared.


 salary_bonus constant number(4); 
 salary_bonus := 2000; 
 dbms_output.put_line (salary_bonus); 

Prev Tutorial Next Tutorial

Google Advertisements
Download Projects

Google Adsense Advertisements

Buy 3 Year Old Domain,, @$200

Buy This Ad Space @$50 per Month, Ad Size 300X250 Contact on: WhatsApp no. 8882538826

Yahoo Advertisements