what are stored procedures?

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
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 / 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 / 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 ?    1 Yes 0 No

what are stored procedures?..

Answer / jyoti ranjan samal

Store procedure can invoke DDL&DML statement and can return
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

Post New Answer

More Oracle General Interview Questions

What is the exact use of Collections?

0 Answers  

how to get the index id?

1 Answers   Cognizant, TCS,

Differentiate between TRUNCATE and DELETE?

2 Answers  

Can we create index on views?

19 Answers   CTS, Syntel, TCS,

Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?

3 Answers  

what is kernel?

2 Answers   Microsoft,

Explain how you would restore a database using RMAN to Point in Time?

0 Answers  

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 Answers  

when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?

2 Answers  

what are Triggers?

5 Answers   TCS,

why dont we assign not null constraint as table level constraint.

0 Answers  

What are the factors causing the reparsing of SQL statements in SGA?

2 Answers