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

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

1034

---

Why cross join is used?

1020

---

Why do we need unique key in a table?

882

---

Why do we use joins in sql?

907

---

How can we optimize a sql query?

982

---

what is text? : Sql dba

1006

---

what is a record in a database ? : Sql dba

994

---

How many types of literals are available in pl sql?

1044

---

What is rowid in sql?

905

---

What are sql built in functions?

893

---

Is sql a backend?

966

---

how to use 'mysql' to run sql statements? : Sql dba

982

---

What is a recursive stored procedure?

1095

---

How do I count duplicates in sql?

1027

---

How can check sql version from command line?

1009

---