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

What is record type in pl sql?

989

---

what are the different tables present in mysql? : Sql dba

984

---

What is mdf ldf and ndf?

999

---

What is the use of & in pl sql?

1046

---

What is the difference between instead of trigger and after trigger?

1010

---

Explain unique key in sql.

1012

---

What is pl sql block in dbms?

1001

---

what are the types of subquery? : Sql dba

1103

---

how many tables will create when we create table, what are they? : Sql dba

1072

---

What are the parameter modes supported by pl/sql?

1106

---

How do you declare a constant?

960

---

Is sql workbench free?

992

---

What is an exception in pl/sql?

1087

---

Which constraints we can use while creating database in sql?

1079

---

What is the difference between partition and index?

988

---