Re: Creating View with WITH clause

From: <r13l24r2_at_gmail.com>
Date: 2 Aug 2006 03:22:52 -0700
Message-ID: <1154514172.813619.111060@m79g2000cwm.googlegroups.com>

Well, in fact, I don't think that's fair. This is a usenet group, isn't it? Where people can ask for help, or not? I can appreciate that I may be asking a question that is very basic in your eyes, but I don't see why that means that I can't ask it.

Maybe you can point me in the direction of a friendly oracle forum instead?

Thanks.
m

sybrandb wrote:
> r13l2..._at_gmail.com wrote:
> > Hi all,
> >
> > I'd like to create a view based on some code that I was helped out with
> > yesterday, and I'm having some trouble with it. What I have so far is
> > (with some complexity removed and names changed to protect the
> > innocent):
> >
> > with table_flattener as (
> > select j1.batch_id, b.batch_name,
> > ...
> > from jobs.action j1, jobs.action j2, jobs.batch b
> > where j2.batch_id (+)= j1.batch_id and
> > b.batch_id=j1.batch_id )
> > select a.batch_id, max(a.sent) sent, a.batch_name, max(a.received)
> > received
> > from table_flattener a
> > group by a.batch_id, a.batch_name
> > order by 1
> >
> >
> > what I'd like to do is create a view of this exact data. Of course:
> >
> > create view myview
> > with table_flattener as (
> > etc
> >
> > doesn't work. Am I missng a really obvious way to do this?
> >
> > Thanks so much in advance!
> > m

>

> Asking to help out is one thing.
> Asking others to do your work for free, without even trying to do it
> yourself, another, and should be considered misuse of this forum.
> The obvious thing you are missing is
> - knowledge of SQL
> - motivation to learn to fish, ie to read the manual:
> you are asking others to spoon feed you.
>
> --
> Sybrand Bakker
> Senior Oracle DDBA
Received on Wed Aug 02 2006 - 05:22:52 CDT