Re: Combining views and CTE

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Sat, 14 Mar 2015 01:52:30 +0300
Message-ID: <CAOVevU5DT1iMU8NghCNWw-VmxOu5CoXcD3TXORUQ=cW0tnxpHw_at_mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 13 2015 - 23:52:30 CET