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
How to download oracle sql developer?
What is loop in pl sql?
What are the parts of a sql statement?
What is Materialized View? In What Scenario we Use Materialized View?
Can two tables have same primary key?
What is attribute indicator in pl sql?
How to run pl/sql statements in sql*plus?
How can you load multi line records? : aql loader
Is sqlite good enough for production?
What are the types of join and explain each?
Why do we create views in sql?
Why is stored procedure faster than query?
What does truncate mean in sql?
What normalization means?
Is primary key always clustered index?