Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: creating views

Re: creating views

From: Rafa³ Jank <yankee_at_wp.pl>
Date: Fri, 24 Nov 2000 12:39:09 +0100
Message-ID: <8vlklu$17j$1@korweta.task.gda.pl>

Try create view IT AS select stuID, count(*) as stuCOUNT from Participate group by
stuID.

chris napisa³(a) w wiadomo¶ci: <8vliq8$t3i9_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 - 05:39:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US