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

    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.