Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating view
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