Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: QUERY

Re: QUERY

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Tue, 19 Oct 2004 23:38:30 +0300
Message-ID: <049a01c4b61b$987d3090$ec879fd9@porgand>


Hi!

CATEGORY is a reserved word (you can check it from v$reserved_words).

Use ...WHERE "CATEGORY" = :b1 or rename the column...

Tanel.

> Hi,
> Please suggest what is wrong in following query?
>
> SELECT CATEGORY_ID FROM CATEG WHERE CATEGORY = :b1
> thanks

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 19 2004 - 15:34:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US