This content has been marked as final. Show 2 replies
What is the purpose of such numbering? To number each row?
If so - then use ROWNUM as 1st column.
SQL>with ddd as (select 333 COL from dual union all select 5444 COL from dual) select rownum,COL from ddd;
offcourse this is possible:1 person found this helpful
But I agree with Nikolay, why would you want to do that?
create materialized view mvw_dummy as select s_generic.nextval , dummy from dual;