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 is sql partition function?
What is oracle sql developer?
how do you know the version of your mysql server? : Sql dba
Define overloaded procedure?
How do you identify a primary key?
how can we know the number of days between two given dates using mysql? : Sql dba
Give the order of sql select?
what are the different type of normalization? : Sql dba
difference between anonymous blocks and sub-programs.
What is assignment operator in pl sql?
What is the difference among union, minus and intersect?
Explain what is sql?
Are subqueries faster than joins?
What is lexical units in pl sql?
what is transaction? : Sql dba