what are stored procedures?

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / suresh

7 Answers
27339 Views
TCS, Wells Fargo, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what are stored procedures?..

Answer / suresh

Stored Procedure are the precomplied set of sql command.

Is This Answer Correct ?

6 Yes

0 No

what are stored procedures?..

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

what are stored procedures?..

Answer / suguna

It is nothing but data base object it is stored in data
base whenever we required we will specify the procedure
name & execute it

Is This Answer Correct ?

2 Yes

0 No

what are stored procedures?..

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

what are stored procedures?..

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

what are stored procedures?..

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

what are stored procedures?..

Answer / rocky-455

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

Post New Answer