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 ?    5 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 ?    3 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

hai, when to use char and varchar2....?

2 Answers  

What is STATSPACK tool?

3 Answers   Wipro,

What is a Temporary Segment ?

2 Answers  

Is it possible to insert comments into sql statements return in the data model editor ?

0 Answers   Oracle,

how to create a new database in oracle?

6 Answers   TCS,

Do View contain Data ?

10 Answers  

What is a Segment ?

1 Answers  

Without giving condition how to retrieve the unmatched records from table.

1 Answers   TCS,

i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

4 Answers   CGI,

i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash

2 Answers  

What are the different approaches used by Optimizer in choosing an execution plan ?

2 Answers  

What is format trigger?

0 Answers