COMMIT; END;
-- Update all at once FORALL i IN 1 .. l_emp_tab.COUNT UPDATE employees SET salary = l_emp_tab(i).salary WHERE employee_id = l_emp_tab(i).employee_id; pl sql developer
This is a lifesaver for moving data between environments (e.g., Dev to QA). COMMIT; END; -- Update all at once FORALL i IN 1
Since "PL/SQL Developer" is a broad term that usually refers to the (a popular tool for Oracle databases) but can also refer to Oracle developers in general, I have categorized the most useful features/tips below. pl sql developer