Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between a query and strored procedure?
- 4 Answers
- 10223 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 the best sql course?
What do you understand by pl/sql cursors?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
Is it possible to create the following trigger: before or after update trigger for each row?
Why we use joins in sql?
what is the difference between char and varchar data types? : Sql dba
what is schema? : Sql dba
What does (+) mean in sql joins?
Write a sql select query that only returns each name only once from a table?
what is the difference between a having clause and a where clause? : Sql dba
Can a table have no primary key?
what is denormalization. : Sql dba
How to use sql*plus built-in timers?
What is a sql trace file?
Mention what does the hierarchical profiler does?
