What is the different between Stored Procedure and Procedure?
Answer Posted / v.v.s.vamshi krishna
In Procedures we give the functions and parameters to be
used instantly. this scenario goes similar to that of
instant food. This happens when the complexity is less. But
as far as the stored procedures are concerned they provide
much reusability and can complexity can be handled with
much ease.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How to add a column ‘salary’ to a table employee_details?
What is the difference between left and left outer join?
Explain the methods used to protect source code of pl/sql.
How many developers work on postgresql?
How do I create an index in word?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
Explain unique key in sql.
What is difference between hql and native sql?
What is multiple partition?
Why commit is not used in triggers?
what are different types of collation sensitivity? : Sql dba
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
Are subqueries better than joins?
How do I make sql search faster?
What is a database event trigger?