not null values code example Example: not null SELECT NVL(emp_id,001)emp_id,emp_name FROM employee_details;