Re: Views?

From: Wojciech Chmielewski <chmielewskiw_at_poland.com>
Date: Thu, 18 Jan 2001 16:49:01 GMT
Message-ID: <18F96.20747$oL4.429750@news2.nokia.com>

Hi,
as you can see, you have some errors in your first query: - you have 2x "as" at the 1st line and 2nd, - what is "*" in 4th line?

try to correct this errors:-)

Regards,
Wojtek

"Doug O'Leary" <dkoleary_at_ro05-24-29-232-217.ce.mediaone.net> wrote in message news:wTD96.972$DWT8.65405155_at_news.randori.com...
> Alright; I'm confused...
>
> SQL> describe dba_users;
> Name Null? Type
> ----------------------------------------- -------- ------------------
> USERNAME NOT NULL VARCHAR2(30)
> USER_ID NOT NULL NUMBER
> PASSWORD VARCHAR2(30)
>
> <<snip>>
>
> SQL> create or replace view show_users as
> 2 as select username, account_status
> 3 from dba_users
> 4* order by username
> SQL> /
> from dba_users
> *
> ERROR at line 3:
> ORA-00942: table or view does not exist
>
> Yet...
>
> SQL> create or replace view show_tables as
> 2 select table_name
> 3 from user_tables
> 4 order by table_name;
>
> View created.
>
> I'm suspecting some type of squirrely priviledge problem. Can anyone
> tell me what I'm screwing up?
>
> Thanks.
>
> Doug
>
>
> --
> ------------------------
> Douglas K. O'Leary
> Senior System Administrator
> dkoleary_at_mediaone.net
Received on Thu Jan 18 2001 - 10:49:01 CST