What is the different between Stored Procedure and Procedure?
- 7 Answers
- 12595 Views
- Informatica, MIS, I also Faced
- E-Mail Answers
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 dynamic query?
What is sqlexception in java?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
How can I see all tables in sql?
What is the difference between in and between in sql?
Where not exists in sql?
Is progress software supports to ( pl/sql )?
What is not null in sql?
List the ways to get the count of records in a table?
How do you respond to dementia behavior?
what is commit? : Sql dba
How to raise user-defined exception with custom sqlerrm ?
How to pronounce postgresql?
What has stored procedures in sql?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
