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);

What are the parts of a basic sql query?

917

---

How do you modify a column in sql?

937

---

What are packages in pl sql and also explain its advantages?

958

---

What is delimiter in pl sql?

987

---

What do we need to check in database testing?

963

---

Is time a data type in sql?

851

---

What is nosql vs sql?

1121

---

How do you use a while loop in pl sql?

939

---

What is difference between sql and excel?

1005

---

How do I remove sql developer from windows 10?

1012

---

What are different types of statements supported by sql?

1095

---

What is the use of index in sql?

957

---

Explain the order of sql statement execution?

976

---

What is rename command in sql?

950

---

What is composite primary key in sql?

938

---