Answer Posted / nashiinformaticssolutions

A stored procedure is a precompiled block of PL/SQL code stored in the database, which can be executed to perform a specific task.
Syntax Example:
CREATE OR REPLACE PROCEDURE IncreaseSalary(emp_id NUMBER, increment NUMBER) AS
BEGIN
UPDATE employees
SET salary = salary + increment
WHERE id = emp_id;
END;
To execute:
EXEC IncreaseSalary(101, 500);

Does truncate remove indexes?

1009

---

What are the two types of cursors in pl sql?

1059

---

How many types of triggers are there in pl sql?

1050

---

What is sql injection vulnerability?

928

---

what is acid property in database? : Sql dba

1010

---

How to avoid duplicate records in a query?

987

---

What is the difference between microsoft access and sql server?

1033

---

What is sqlca in powerbuilder?

994

---

How do I save the results of sql query in a file?

963

---

what is clause? : Sql dba

1052

---

How do I tune a sql query?

959

---

Name three sql operations that perform a sort.

988

---

What are the parts of a basic sql query?

956

---

Can we commit inside a trigger?

980

---

How to run pl sql program in mysql?

997

---