InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What is a subprogram in PL/SQL |
|
Answer» The default VALUE is NULL. PL/SQL assigns NULL as the default value of a variable. To assign another value, you can use the DEFAULT keyword or the assignment operator. Let us see them one by one.Initialization with DEFAULT keyword: DECLARE msg varchar2(15) DEFAULT 'House'; BEGIN dbms_output.put_line(msg); END; /The OUTPUT: HouseInitialization with assignment operator: DECLARE device varchar2(11) := 'Laptop'; BEGIN dbms_output.put_line(device); END; /The output: Laptop |
|