Sobes.tech
Junior — Middle

Have you created stored procedures in an Oracle database using PL/SQL?

sobes.tech AI

Answer from AI

Yes, I have created stored procedures in Oracle using PL/SQL. For example, I wrote procedures for handling business logic on the database side, which helped improve performance and centralize logic. A simple procedure example:

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;
/
Have you created stored procedures in an Oracle… - sobes.tech