creating views

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 - 05:17:21 CST