Re: Combining views and CTE
- From: "Mladen Gogala" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "mgogala@xxxxxxxxx" for DMARC)
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 13 Mar 2015 18:55:43 -0400
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
Other related posts:
