Answer Posted / glibwaresoftsolutions

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 pl sql block in dbms?

1051

---

What is sql constant?

1097

---

Explain two easy sql optimizations.

1070

---

Does sql require a server?

1052

---

What is a scalar value in sql?

1121

---

What is the usage of sql functions?

1197

---

What are the types of triggers in sql?

1140

---

what is a stored procedure? : Sql dba

1187

---

Does sql profiler affect performance?

1041

---

Why are indexes and views important to an organization?

992

---

What is the importance of sqlcode and sqlerrm?

1389

---

Define SQL and state the differences between SQL and other conventional programming Languages?

1258

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1076

---

who introduced sql?

1068

---

Which is better join or inner query?

1119

---