Difference between inline query and stored procedure?
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
How to set up sql*plus output format in oracle?
Does postgresql run on the cloud?
What is cross join example?
What is difference between stored procedure and trigger?
How do you delete data from a table?
explain commit and rollback in mysql : sql dba
Where do we use pl sql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
How long does it take to learn pl sql?
explain the delete statements in sql
What is the largest value that can be stored in a byte data field?
Define SQL and state the differences between SQL and other conventional programming Languages?
What is native sql query?
what are wild cards used in database for pattern matching ? : Sql dba
Define implicit and explicit cursors.