What is the difference between views and stored procedures?
Can we have input parameters for views?
Answer Posted / grish varshney
views & stored procedure are basically different appraches.
both have their different purposes.
view is a virtual table. which have no data atall.which
difination stored in oracle system catalogue . whenever a
call is made every time the defination is scanned & a new
virtual table is made over the base table.
while stored procedure are the precompiled statements
which can accept arguments..
Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
How to execute stored procedure and set temp table in sql server?
What is data block and how to define data block size?
How to list all user names in a database?
What is system stored procedures?
What do you mean by subquery?
What are the elements of dbms?
How sql server executes a statement with nested subqueries?
What is onf in normalization form?
Can a cursor be updated? If yes, how you can protect which columns are updated?
How do I setup a sql server database?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
how to determine the service pack currently installed on sql server? : Sql server database administration
Explain the properties of subqueries in sql server?
Explain what is row_number function?
Explain tablesample?