Difference between inline query and stored procedure?
Answer Posted / 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 |
Post New Answer View All Answers
What do we need to check in database testing?
Why do we use view in sql?
What are the main features of cursor?
What is blind sql injection?
What are primary key and foreign key and how they work?
What is sql*loader and what is it used for?
What is a crud api?
How much ram can sql express use?
Which sql statement is used to return only different values?
What is rename in sql?
What is the difference between drop and truncate commands?
What does a pl/sql package consist of?
When are we going to use truncate and delete?
How can triggers be used for the table auditing?
How to test for null values?