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
What is rtm in testing?
What is a dirty read sql?
What are the differences between in and exists clause?
How does rowid help in running a query faster?
What are the properties of a transaction?
what is the difference between $message and $$message? : Sql dba
What is pragma in sql?
Why partition by is used in sql?
how to use in conditions? : Sql dba
What is dense_rank in sql?
Explain about various levels of constraint.
What are the advantages of pl sql over sql?
What is difference between stored procedures and application procedures?
What is an implicit commit?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?