Re: differences between VIEW and stored procedure?

Matt wrote:

> I want to know what's the differences between VIEW and stored
> procedure?
>
> stored procedure is like a function that can take parameters, but VIEW
> cannot. Other than
> that, I couldn't see other differences.
>
> Please advise. Thanks!!

There is virtually no relationship between the two so I wonder where you looked?

Go to http://tahiti.oracle.com
search for each and read the Concepts docs

Same goes for functions and procedures ... there are many differences.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)