Thanks for the question, Don.
Asked: October 19, 2016 - 11:23 pm UTC
Last updated: October 21, 2016 - 2:11 am UTC
Version: 11g
Viewed 10K+ times! This question is
SQL> create or replace view V as 2 with blah as ( select * from dba_source) 3 select owner, count(*) c 4 from blah 5 group by owner; View created. SQL> desc V Name Null? Type ----------------------------------------------------------------------- -------- -------------------- OWNER VARCHAR2(128) C NUMBER
Don Simpson, October 20, 2016 - 9:26 pm UTC
create or replace view V as ( with blah as ( select * from dba_source) select owner, count(*) c from blah group by owner );
Check out more PL/SQL tutorials on our LiveSQL tool.
PL/SQL reference manual from the Oracle documentation library