Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between inline query and stored procedure?
- 4 Answers
- 29241 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
Which is faster truncate or drop?
How to rename a table?
What is a join query?
What is left join example?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is the difference between rename and alias?
What are primary key and foreign key and how they work?
What has stored procedures in sql and how we can use it?
How to return multiple rows from the stored procedure?
How do I truncate a word?
How to load data with sql*loader?
define sql insert statement ? : Sql dba
What is oracle sql developer?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What are the advantages of pl sql?
