hi guys,

i am asking out of curiosity ,
can i create a view something like this? i tried to create,but got an error

SQL> create view emp_view as select sum(sal),sum(empno) from emp;
create view emp_view as select sum(sal),sum(empno) from emp
*
ERROR at line 1:
ORA-00998: must name this expression with a column alias

SQL> select sum(sal),sum(empno) from emp;

SUM(SAL) SUM(EMPNO)
--------- ----------
23125 84951

can i create a view based on the above select ?

if there is any other way, can somebody give an example ?

thanks