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 are the types of keys?
What are reports usually used for?
what are enums used for in mysql? : Sql dba
What is delimiter sql?
Define overloaded procedure?
Explain the select statement in sql?
what does it mean to have quoted_identifier on? : Sql dba
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
When to use inner join and left join?
Explain autonomous transaction.
What are the different types of constraints?
What is plpgsql language?
Difference between table function and pipelined function?
What is difference between procedure and trigger?
Does inner join remove duplicates?