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
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 / 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
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

Post New Answer



More Oracle General Interview Questions

Difference between sub query and nested query ?

18 Answers   TCS, Keane India Ltd,


What is Public Database Link ?

1 Answers  


when do u go for hash partitioning?

1 Answers  


how can db_files > maxdatafiles since db_files is for instance and the later is for database

0 Answers   CTS,


How do we know whether an index is created on a table ???

2 Answers   TCS,






which institute and which faculty is providing best training for oracle sql, plsql in hyderabad

4 Answers  


What is Trace File ?

4 Answers   Thermotech,


Query to get max and second max in oracle in one query ?

34 Answers   CTS, TCS, Wipro, Keane India Ltd,


i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers   MasterCard,


ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?

4 Answers  


WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  


what is data independence exactly? give an example

6 Answers  






Categories