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
Are left and right joins the same?
What will you get by the cursor attribute sql%rowcount?
Does access use sql?
What are sql constraints?
What does rownum mean in sql?
How many developers work on postgresql?
Why do you partition data?
what is the difference between truncate and delete statement? : Transact sql
What is the non-clustered index in sql?
What are the parameter modes supported by pl/sql?
What are local and global Indexes and where they are useful.
Why do we use procedures in sql?
what is bcp? When is it used?
What are the types of optimization?
how would you enter characters as hex numbers? : Sql dba