Re: view problem

Thomas & Guttadauro

Thanks for the help.

regards
Daud

In article <37d906da.3257944_at_news>,
  jeff109_at_NOSPAM.netscape.net (Jeff Guttadauro) wrote:
> Sorry. I hope I didn't cause confusion. I meant to refer to the
> "new_col1" and "new_col2" view column names, not the col1_A and col1_B
> column names from your tables.
>
> On Fri, 10 Sep 1999 13:25:07 GMT, jeff109_at_NOSPAM.netscape.net (Jeff
> Guttadauro) wrote:
>
> >Hi, Daud.
> >
> > Since you created the column in the view with double quotes
> >around it, Oracle named the column as exactly what you put in the
> >quotes, "col1_B", even with regards to case. When you issue your
> >select, you are not using the double quotes, so Oracle puts
everything
> >to uppercase. If you do your select where "col1_B" = {whatever},
then
> >it will work. I would recommend not using lowercase for object names
> >precisely because of this problem. If you remove the double_quotes
> >from the column names in your view creation, they will be created as
> >COL1_A and COL1_B.
> >
> >Hope this helps,
> >-Jeff
> >
> >On Fri, 10 Sep 1999 12:58:07 GMT, daud11_at_hotmail.com wrote:
> >
> >>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.
> >
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 10 1999 - 21:43:07 CDT