Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between views and stored procedures?
Can we have input parameters for views?
- 6 Answers
- 19691 Views
- I also Faced
- E-Mail Answers
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
Which sql server table is used to hold the stored procedure scripts?
What is the data type of time?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What is scrollable cursor?
What is the language structure to add a record to a table?
What is the beast way to write CTE in SQL Server ?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
How to rebuild indexes with alter index ... Rebuild?
What is the difference between Normalization and De-normalization?
What will happen if a column containing char type data is changed to the nchar data type?
What is difference between count (*) and count 1?
how you can list all the tables in a database?
Explain temporary table vs table variable by using cursor alternative?
What happens if strings are casted into wrong code pages in ms sql server?
What is the usage of sign function?
