Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between inline query and stored procedure?
- 4 Answers
- 29433 Views
- Bharat, Microsoft, I also Faced
- E-Mail Answers
Answer Posted / sharad prakash singhania
Procedure resides in the database in the executable format
whereas in case of inline query, SQL always take a step to
compile the query and then execute it. So In this respect
Procedure takes less time to execute whereas query take more
time to execute.
| Is This Answer Correct ? | 18 Yes | 5 No |
Post New Answer View All Answers
Does db2 use sql?
What is an exception in pl/sql?
Can we use ddl commands in pl sql?
Why is pl sql used?
Where not exists in sql?
what are all the different normalizations? : Sql dba
Which is better join or subquery?
What is sap sql anywhere?
What is date functions?
What are the most important ddl statements in sql?
Which operator is used in query for pattern matching?
Are sql connections encrypted?
How do you define a foreign key?
What is orm in sql?
How many types of triggers exist in pl/sql?
