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: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 29 Nov 2004 17:42:35 +0100
Message-ID: <cofjih$n0s$2@news3.zwoll1.ov.home.nl>


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.

-- 
Regards,
Frank van Bortel
Received on Mon Nov 29 2004 - 10:42:35 CST

Original text of this message

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