Re: Combining views and CTE

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Fri, 13 Mar 2015 18:55:43 -0400
Message-ID: <55036AEF.4030507_at_yahoo.com>

Sayan, you're a life saver. Thank you very, very much!!!!

On 03/13/2015 06:52 PM, Sayan Malakshinov wrote:
> Just remove parentheses:
>
> SQL> create or replace view v1 as
> 2 (with q1 as (select * from emp e where e.first_name='John')
> 3 select * from q1)
> 4 ;
> select * from q1)
> *
> ERROR at line 3:
> ORA-32034: unsupported use of WITH clause
>
>
> SQL> create or replace view v1 as
> 2 with q1 as (select * from emp e where e.first_name='John')
> 3 select * from q1;
>
> View created.
>
>
> --
> Best regards,
> Sayan Malakshinov
> Senior performance tuning engineer
> PSBank
> http://orasql.org

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com


--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 13 2015 - 23:55:43 CET