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.

Original Message ----- From: "Seema Singh" <oracledbam_at_hotmail.com> To: <oracle-l_at_freelists.org> Sent: Tuesday, October 19, 2004 11:32 PM Subject: QUERY

> 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