Question

Does A Not Null Constraint Of A Database Column Apply To %type Variables ?

Answer 1

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;