Difference between inline query and stored procedure?
Answers were Sorted based on User's Feedback
Answer / jas
Select statement which is part of form clause of any
another statement is called as inline query.
Cannot take parameters.
Not a database object
Procedure:
Can take paramters
Database object
can be used globally if same action needs to be performed.
Is This Answer Correct ? | 27 Yes | 4 No |
Answer / 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 |
Answer / inam abbas
1) stored procedure comes with some major characterstics, as it consists in pre compiled format so the performance increase during dataaccess. incase of simple query it requires to complie again and again as per user request, but here its not required due to precompile format (*compile requires only ones).
2)next it reduce the network traffice so impacts less burden on server and u can integrate it with different front-end applications (e.g. vb.bnet,c#,java etc) inorder to data access.
3)come to next, due to precompile code resides in database server it provides more security and due to complicated queries can be integrated with one form it is portable also.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / sudama maharana
1. Stored procedure is loaded to database once it compiled, but inline queries are not loaded in to server. So, Stored procedure is in compiled form.
2. As Stored procedure is in compiled form, so in each calling to it, it takes less time than inline queries. Because in Stored procedure we are passing only the names, but in inline query we are passing the whole query.
3. Stored procedures are compiled only once and in each calling its only executing the query. But inline queries are compiled & executed in each calling. So, in stored procedure network Traffic is less.
4. In stored procedure, we can pass parameters . But in inline query we can't pass.
Thanks
Is This Answer Correct ? | 2 Yes | 0 No |
display records from 5 to 9 using rowid or rownum
Is sql the best database?
What is the difference between numeric and autonumber?
Can we use two order by clause in query?
what is bcp? When is it used?
how can you see all indexes defined for a table? : Sql dba
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
how to enter binary numbers in sql statements? : Sql dba
Explain character-manipulation functions?
What is sqlcontext?
overloading of stored procedure is possible in oracle?
How many developers work on postgresql?