PL/SQL Constants
PL/SQL Constants
A constant is a value used in a PL/SQL block that remains unchanged throughout the program. It is a user-defined literal value. It can be declared and used instead of actual values.
Let's take an example to explain it well:
Suppose, you have to write a program which will increase the salary of the employees upto 30%, you can declare a constant and use it throughout the program. Next time if you want to increase the salary again you can change the value of constant than the actual value throughout the program.
Syntax to declare a constant:
- constant_name CONSTANT datatype := VALUE;
- Constant_name:it is the name of constant just like variable name. The constant word is a reserved word and its value does not change.
- VALUE: it is a value which is assigned to a constant when it is declared. It can not be assigned later.
Example of PL/SQL constant
Let's take an example to explain it well:
- DECLARE
- -- constant declaration
- pi constant number := 3.141592654;
- -- other declarations
- radius number(5,2);
- dia number(5,2);
- circumference number(7, 2);
- area number (10, 2);
- BEGIN
- -- processing
- radius := 9.5;
- dia := radius * 2;
- circumference := 2.0 * pi * radius;
- area := pi * radius * radius;
- -- output
- dbms_output.put_line('Radius: ' || radius);
- dbms_output.put_line('Diameter: ' || dia);
- dbms_output.put_line('Circumference: ' || circumference);
- dbms_output.put_line('Area: ' || area);
- END;
- /
After the execution of the above code at SQL prompt, it will produce the following result:.
- Radius: 9.5
- Diameter: 19
- Circumference: 59.69
- Area: 283.53
- Pl/SQL procedure successfully completed.
PL/SQL Literals
Literals are the explicit numeric, character, string or boolean values which are not represented by an identifier. For example: TRUE, NULL, etc. are all literals of type boolean. PL/SQL literals are case-sensitive. There are following kinds of literals in PL/SQL:
- Numeric Literals
- Character Literals
- String Literals
- BOOLEAN Literals
- Date and Time Literals
Example of these different types of Literals:
| Literals | Examples |
|---|---|
| Numeric | 75125, 3568, 33.3333333 etc. |
| Character | 'A' '%' '9' ' ' 'z' '(' |
| String | Hello Word! |
| Boolean | TRUE, FALSE, NULL etc. |
| Date and Time | '26-11-2002' , '2012-10-29 12:01:01' |
