Pl Sql <PRO>

EXCEPTION WHEN DUP_VAL_ON_INDEX THEN DBMS_OUTPUT.PUT_LINE('Duplicate record skipped'); WHEN OTHERS THEN RAISE_APPLICATION_ERROR(-20001, 'Unknown error: ' || SQLERRM); Packages bundle related procedures, functions, and variables. They maintain state across sessions (using package variables) and offer true encapsulation. 6. Native Compilation PL/SQL can be compiled to native machine code (C), not just bytecode. For CPU-intensive loops, this delivers C-like performance. Where PL/SQL Dominates | Industry | Typical Use | |----------|--------------| | Banking | Nightly batch reconciliation, fraud detection rules | | Airlines | Booking engines, loyalty point calculations | | Insurance | Premium calculations, claims processing | | Retail | Inventory management, sales tax computation | | Healthcare | Claims adjudication, HIPAA-compliant data logic |

BEGIN FOR rec IN (SELECT * FROM sales WHERE status = 'PENDING') LOOP UPDATE accounts SET balance = balance + rec.commission WHERE account_id = rec.acct_id; INSERT INTO audit_log (sale_id, action) VALUES (rec.sale_id, 'COMMISSION_PAID'); END LOOP; COMMIT; END; pl sql

DBMS_OUTPUT.PUT_LINE('Employee: ' || v_name); DBMS_OUTPUT.PUT_LINE('Salary: $' || v_salary); EXCEPTION WHEN DUP_VAL_ON_INDEX THEN DBMS_OUTPUT