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: <srana5190_at_my-deja.com>
Date: Wed, 24 Nov 1999 15:59:13 GMT
Message-ID: <81h20e$utp$1@nnrp1.deja.com>


could you write down the statement you wanted to execute. That would help to give the suggession

sohail

In article <Pine.OSF.4.10.9911231735440.7755- 100000_at_beta.tricity.wsu.edu>,
  Pornpira Vachareeyanukul <pornpira_at_beta.tricity.wsu.edu> wrote:
> 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.
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 09:59:13 CST

Original text of this message

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