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.