Answer Posted / hr@tgksolutions.com

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

Explain autonomous transaction.

1216

---

explain the difference between bool, tinyint and bit. : Sql dba

1058

---

What jobs use sql?

1029

---

Is id a reserved word in sql?

1185

---

What is data definition language?

1135

---

what is rollback? : Sql dba

1177

---

What is the difference between null value, zero, and blank space?

1250

---

What is delimiter in pl sql?

1096

---

how to extract a unit value from a date and time? : Sql dba

1034

---

How to return an array from java to pl/sql?

1177

---

Can one improve the performance of sql*loader? : aql loader

1096

---

what is recursive stored procedure? : Sql dba

1026

---

How do I remove all records from a table?

1115

---

what is a materialized view? : Sql dba

1126

---

Explain the methods used to protect source code of pl/sql.

1069

---