Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> view problem
Hi
I created a view based on a few tables and i renamed the column names
in my view.
table_a
col1_a
col2_a
table_b
col1_b
col2_b
create view my_view as
select col1_A "new_col1", col1_B "new_col2"
from table_a , table_b;
I found that I am not able to:
select * from my_view where new_col2 = "something";
It says invalid column name. Why?
Regards
Daud
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Fri Sep 10 1999 - 07:58:07 CDT