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 do I clear the screen in sql plus?
Write a query to find the names of users that begin with "um" in sql?
How to return multiple rows from the stored procedure?
What is column?
what is datawarehouse? : Sql dba
How do I know if I have sql express or standard?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is an example of translating a date into julian format?
what is the difference between clustered and non clustered index in sql? : Sql dba
How do you update a value in sql?
What is procedure in pl sql?
Is and as keyword in pl sql?
Is pl sql and postgresql same?
How do I view tables in mysql?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?