Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: differences between VIEW and stored procedure?

Re: differences between VIEW and stored procedure?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 29 Nov 2004 17:00:32 -0800
Message-ID: <1101776336.373737@yasure>


Frank van Bortel wrote:
> DA Morgan wrote:
>

>> 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.

>
>
> Judging by the flood of (pretty basic) questions, I'd say
> this is homework, or missed class.

Sure looks like homework for me. And for those of you not up on the school-year ... I am giving my students their final next week. Yep it is that time again ... end of the quarter.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Nov 29 2004 - 19:00:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US