Improving Code Readability With Named Notation In Oracle PL/SQL
Named notation improves code readability & flexibility by passing correct values to right parameters, even if their order is different. It's especially useful when there are multiple params with default values.
Let's walk through the example and see the output when calling the update_employee_info procedure using named notation.
Table Creation (Short Version)
CREATE TABLE employees (
emp_id NUMBER(6) PRIMARY KEY,
emp_name VARCHAR2(50),
emp_salary NUMBER(8, 2),
emp_dept VARCHAR2(30) DEFAULT 'IT',
hire_date DATE DEFAULT SYSDATE
);
Inserting Sample Data (Short Version)
INSERT INTO employees (emp_id, emp_name, emp_salary, emp_dept, hire_date)
VALUES (101, 'John Doe', 50000, 'Finance', TO_DATE('2024-01-01', 'YYYY-MM-DD'));
INSERT INTO employees (emp_id, emp_name, emp_...