Re: View Column Problem
From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 24 May 2003 21:08:21 -0700
Message-ID: <92eeeff0.0305242008.678920_at_posting.google.com>
Date: 24 May 2003 21:08:21 -0700
Message-ID: <92eeeff0.0305242008.678920_at_posting.google.com>
"Erwin" <erwincisco_at_yahoo.com.sg> wrote in message news:<P1yza.62$ES.758_at_news-server.bigpond.net.au>...
> Hi,
>
> I just created a view with the following column name (bank, account, name)
> and the view name is example.
> It is alright when I did:
> select * from example;
>
> But the following error message: Error at line 1: ORA-00904 "BANK": invalid
> identifier pops up when I try to use this command:
> select bank from example;
>
> What is the going on?
>
> Thanks !
It would be helpfull if you can provide your create view statement.
Regards
/Rauf Sarwar
Received on Sun May 25 2003 - 06:08:21 CEST