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 the location of pre_defined_functions.

1110

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1034

---

how to convert dates to character strings? : Sql dba

1069

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

944

---

define join and explain different type of joins? : Sql dba

897

---

What is rollback?

1034

---

Does truncate free space?

945

---

What version is sql?

963

---

What is a primary key sql?

989

---

what is the difference between a local and a global temporary table? : Sql dba

1003

---

How to return multiple rows from the stored procedure?

912

---

What is trigger explain with example?

981

---

What is the use of non clustered index?

927

---

How does one load ebcdic data? : aql loader

1092

---

What is int identity in sql?

1059

---