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

Can I call a procedure inside a function?

1074

---

How do I pipe the output of one isql to another?

1055

---

What is the difference between row level and statement level trigger?

1070

---

Can you inner join the same table?

1035

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1112

---

What is attribute indicator in pl sql?

1065

---

Explain commit, rollback and savepoint.

1052

---

What is a heap in sql?

1137

---

What are the syntax and use of the coalesce function?

1271

---

how to start mysql server? : Sql dba

1233

---

What is natural join in sql?

1043

---

What is synonyms?

1116

---

How do I restart sql?

1022

---

Does user triggers have entry for trigger with compilation errors?

1089

---

what is sql profiler? : Sql dba

1115

---