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 many sql ddl commands are supported by 'mysql'? : Sql dba
can sql servers linked to other servers like oracle? : Sql dba
How to display the records between two range in Oracle SQL Plus?
Is big data nosql?
What is pl sql variable?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What is primary key and foreign key?
What is the purpose of the primary key?
How do we use distinct statement? What is its use?
What are the indexing methods?
Can sql function call stored procedure?
What is having clause in sql?
Mention what is the plv (pl/vision) package offers?
How to pronounce postgresql?
What are tables in sql?