What is the different between Stored Procedure and Procedure?

Answer Posted / roshan kumar

Procedure-

A procedure is a specified series of actions,acts or operations which have to be executed in the same mannner in order to always obtain the same result under the same circumstances.

Stored Procedure-

A stored procedure is a subroutine available to applicATIONS accessing a Relational database system.stored procedures(sometimes called as proc,sproc or sp) are actually stored in database dictionary.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rtm in testing?

567


What is a dirty read sql?

469


What are the differences between in and exists clause?

557


How does rowid help in running a query faster?

961


What are the properties of a transaction?

548






what is the difference between $message and $$message? : Sql dba

540


What is pragma in sql?

610


Why partition by is used in sql?

548


how to use in conditions? : Sql dba

503


What is dense_rank in sql?

533


Explain about various levels of constraint.

517


What are the advantages of pl sql over sql?

536


What is difference between stored procedures and application procedures?

561


What is an implicit commit?

543


When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

619