8 Replies Latest reply: Aug 26, 2014 3:53 PM by user527460 RSS

    WITH Clause not working in 11g


      Hi All,


      I am running this query via PL/SQL developer in 11g but it is not showing me data.


           with aquery as (select c1, c2 from t1 where c2  = 20130101)  select * from aquery;


      However, when I run only this SELECT then it retrieves the output.


           select c1, c2 from t1 where c2  = 20130101


      The db user has both CREATE MV and CREATE Table privileges in this database.