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 are tables in sql?
Which constraints we can use while creating database in sql?
Define sql delete statement.
difference between anonymous blocks and sub-programs.
What is the use of %rowtype?
What is a primary key example?
what is the difference between a having clause and a where clause? : Sql dba
Can a varchar be a primary key?
How to connect a sql*plus session to an oracle server?
Is not null in sql?
What is the difference between cross join and natural join?
Give the order of sql select?
What is sql prepared statement?
What are the 3 types of behavioral triggers?
what are rollup and cube in t-sql? : Transact sql