Ha, men Oracle'da PL/SQL yordamida saqlangan protseduralar yaratganman. Masalan, ma'lumotlar bazasi tomonida biznes mantiqini ishlash uchun protseduralar yozganman, bu esa ishlashni yaxshilash va mantiqni markazlashtirish imkonini berdi. Oddiy protsedura misoli:

CREATE OR REPLACE PROCEDURE update_salary(emp_id IN NUMBER, new_salary IN NUMBER) AS
BEGIN
  UPDATE employees SET salary = new_salary WHERE employee_id = emp_id;
  COMMIT;
END;
/

Oldingi Keyingi