Re: Creating View with WITH clause

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