help neede in creating new table from another table,plzzzzzzzzz help meeeeeee
hi i m working in oracle8i sql plus i have one sql querry but it is not executing instead givivng msg that
1* create table totals as select rno,sum(mark) from marks group by rno
and system gives message that
create table totals as select rno,sum(mark) from marks group by rno
*
ERROR at line 1:
ORA-00998: must name this expression with a column alias
so solve my doubt plzzzzzzz
whether my querry is wrong?????????
or not?
plz help me i have to create secondary table
ragrds
abhinav pandey