Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Virtual column not allowed here in select statement
I believe your problem stems from use of a reserved word as a column
name: TYPE is listed in V$RESERVED_WORDS, and, as such, may be the
root cause of your difficulties. Rename the column and you should
alleviate your error.
mittalashish_at_yahoo.com (mittalashish) wrote in message news:<3cb58f22.0211041939.55cb1ad1_at_posting.google.com>...
> I have this query which gives me ORA-01733
>
> select count(*)
> from
>
> "W_PRODUCT_D" T23336,
>
> "W_PRODUCT_DH" T23752,
>
> "W_SYND_DATA_F" T23431
> where
> T23336."TYPE" = 'ZYX' and
> T23752."TOP_LVL_PROD_NAME" = 'ABCD' and
> DATA_TYPE=1
> and T23336."ROW_WID" = T23752."PROD_WID" and T23336."ROW_WID" =
> T23431."PROD_WID"
> group by T23752."LVL7ANC_PROD_NAME", T23752."TOP_LVL_PROD_ID"
>
> however, commenting out the first condition so that the query looks
> like this:
>
> select count(*)
> from
>
> "W_PRODUCT_D" T23336,
>
> "W_PRODUCT_DH" T23752,
>
> "W_SYND_DATA_F" T23431
> where
> --T23336."TYPE" = 'ZYX' and
> T23752."TOP_LVL_PROD_NAME" = 'ABCD' and
> DATA_TYPE=1
> and T23336."ROW_WID" = T23752."PROD_WID" and T23336."ROW_WID" =
> T23431."PROD_WID"
> group by T23752."LVL7ANC_PROD_NAME", T23752."TOP_LVL_PROD_ID"
>
> works fine. The doc says this error occurs when inserting into a view.
> But there is no view here. Any help will be appreciated.
Received on Tue Nov 05 2002 - 12:35:39 CST