InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Does A Not Null Constraint Of A Database Column Apply To %type Variables ? |
|
Answer» No, a NOT NULL constraint does not apply to VARIABLES declared using the %TYPE attribute. These variables can be assigned a null VALUE in a PL/SQL block, as shown in the FOLLOWING CODE snippet: DECLARE var_emp_code t_employee.emp_codeflPE; BEGIN var_emp_code NULL;No, a NOT NULL constraint does not apply to variables declared using the %TYPE attribute. These variables can be assigned a null value in a PL/SQL block, as shown in the following code snippet: |
|