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: Creating view

Re: Creating view

From: Pornpira Vachareeyanukul <pornpira_at_beta.tricity.wsu.edu>
Date: Tue, 23 Nov 1999 17:41:02 -0800
Message-ID: <Pine.OSF.4.10.9911231735440.7755-100000@beta.tricity.wsu.edu>


Hi again,

Thanks for the response,

I guess now I want to know how to go about doing this. I've tried create view test as
pl/sql stuff here because I want to do loop to process the data

But when I ran it, it gave the error that it expected "select" after "create view test as".

Thank you,
Mimi

On Tue, 23 Nov 1999 lily99_at_my-deja.com wrote:

> Yes, you can.
>
> In article <Pine.OSF.4.10.9911221709260.27211-
> 100000_at_beta.tricity.wsu.edu>,
> Pornpira Vachareeyanukul <pornpira_at_beta.tricity.wsu.edu> wrote:
> > Hi,
> > I'm trying to creat a view from multiple tables. But before creating
> one,
> > I'd like to do some data processing and use the result creating the
> view.
> > Is it possible data processing before creating the view?
> > Thank you in advance,
> > Mimi
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
>
Received on Tue Nov 23 1999 - 19:41:02 CST

Original text of this message

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