Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: creating views
You need to alias the column count(*), which is an invalid column name
create view it
as select stuID,count(*) count
from Participate group by stuID
"chris" <damoncwk_at_hotmail.com> wrote in message
news:8vlin5$ugo5_at_hkunae.hku.hk...
> Dear All,
> When I try to create a View in oracle, I type
>
> create view IT AS select stuID, count(*) from Participate group by stuID
>
> It prompts "must name this expression with a column alias"
>
> When I type
>
> create view IT (a,b) AS select stuID, count(*) from Participate group by
> stuID
>
> It prompts "Insufficient privileges"
>
> Can anyone pls explain it to me?
>
> Thx a lot!
>
>
>
Received on Fri Nov 24 2000 - 20:13:25 CST