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

    WITH Clause not working in 11g

    user527460

      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.

       

       

      Thanks.