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 a memo field?
What is Histogram?
What is the difference between left outer join and left join?
What is sql keyword?
What is the current version of sql?
How do I copy a table in sql?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What are the benefits of pl sql?
How do I save the results of sql query in a file?
What is cte?
What are the uses of merge?
What's the difference between inner join and left join?
What is %type in pl sql?
what is sql profiler? : Sql dba
How many unique keys can a table have?