WHAT ARE PL/SQL CONSTANTS?
As we can see the word CONSTANT,we can translate it by this that anything that can not be changed through out the program.It is a user defined value ,after the declaration of Constants we can change the actual values.
Example
If we want to increase the salary of our employees by 10%, we will defined the constants that will increase the salary of employees automatically.
Note : The value of constants is easier to change than actual value changing through out the program. The syntax of constant is in picture below
1 > CONSTANT_NAME is the name of constants and like as variable.
2 > CONSTANT is a reserved keyword and show to keep the value constant.
3> datatype is the type of value that will be assigned to the constants_name.
4> value that will be assigned to the constants and it is important to declare it at the time of defining constants.
No comments:
Post a Comment