what are stored procedures?
Answers were Sorted based on User's Feedback
Answer / suresh
Stored Procedure are the precomplied set of sql command.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / pushpa
stored procedures means containing a precompiled block of
code.
if we call stored procedures they need not compiled,only
execution takes place.
with this advantage ,work on database is less.
with these sps we can perform business logics.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / akn
Its nothing but a set of T-SQL statements combined to
perform a single task of several tasks. Its basicaly like a
Macro so when you invoke the Stored Procedure,you actually
run a set of statements
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / jyoti ranjan samal
Store procedure can invoke DDL&DML statement and can return
value.
2.You can also execute one procedure to another procedure.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sapna kalburgi
Stored procedure is a set of SQL statements used to perform
some particular task.
| Is This Answer Correct ? | 0 Yes | 0 No |
1. Store procedure may or may not return a value. If we want to return a value then we need to pass the parameters like INPUT & OUTPUT parameters
2. It can allowed SELECT/INSERT/UPDATE/DELETE Statements. It can be change state of table.
3. It can call Functions, Views, and Procedures inside procedures.
| Is This Answer Correct ? | 0 Yes | 0 No |
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What is private procedure oracle?
How to execute a stored program unit?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
What is transport network substrate (tns) in oracle?
what is primary key?
What is Public Database Link ?
how to make an oracle object
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
Hi Can any one tell me what are the API's used in requisition import.
How to use attributes of the implicit cursor in oracle?