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
How can we store rows in PL/SQL using array?
How do I quit sql?
What is record data type?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What is a record in a database?
What are the two parts of design view?
Can we rollback after truncate?
What is trigger explain it?
What are the different types of triggers?
What is mdf ldf and ndf?
How do you delete data from a table?
How many joins can you have in sql?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What does 0 mean in sql?
What is faster join or subquery?