Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



More Oracle General Interview Questions

What is the difference between a user and a schema in oracle?

0 Answers  


What is bulk load in oracle?

0 Answers  


When do you get a .pll extension in oracle?

0 Answers  


What is forall Statement ?

2 Answers   Thermotech,


What is a Sequence ?

3 Answers  






What is the quickest way to fetch the data from a table?

0 Answers  


Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

0 Answers  


what is a cartition product?

4 Answers  


Explain a data segment?

0 Answers  


How to enter a new row into a table interactively?

0 Answers  


What are the values that can be specified for OPTIMIZER MODE Parameter ?

1 Answers  


How to find out what privileges a user currently has in oracle?

1 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)