Difference between a query and strored procedure?
- 4 Answers
- 8773 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / khushbu wadhwani
in procedure one time compilation is done,whereas in query
compilation is done everytime.so,procedure improves
efficiency & performance
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is right join sql?
Can you have a foreign key without a primary key?
What are database links used for?
How do you break a loop in pl sql?
Is it mandatory for the primary key to be given a value when a new record is inserted?
What is trigger and types?
What are the datatypes available in pl/sql ?
Why do we create stored procedures & functions in pl/sql and how are they different?
Why self join is used in sql?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Can you select everything, but 1 or 2 fields, without writer's cramp?
Why is stored procedure faster than query?
Can we perform dml on view?
What are the usages of sql?
How to test for null values?
