Interested to Buy Any Domain ? << Click Here >> for more details...
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);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between stored procedure and trigger?
What is a sql driver?
How to get each name only once from an employee table?
What information is needed to connect sql*plus an oracle server?
What is crud diagram?
What is a pl/sql block?
what are the different type of normalization? : Sql dba
what is myisam? : Sql dba
Can primary key be changed?
What is sql dialect?
How do I write a cron which will run a sql query and mail the results to agroup?
What are variables in pl sql?
What is trigger explain it?
What port does sql server use?
What version is sql?
