PL/SQL Constant

Advertisements

Variable in PLSQL Operator in PLSQL

PL/SQL Constant

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

Constant declaration

Syntax

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.

Example

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

Variable in PLSQL Operator in PLSQL

Advertisements

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 8076671483

Pure VPN Privide Lowest Price VPN Just @ $1.65. Per Month with Non Detected IP Lowest Price Non Detected IP VPN

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

Download Projects

Advertisements


Buy Websites 9999595223

Buy Fresh and Payment Receive Media.net Account with Website. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs