RE: QUERY

Seema: What makes you think something is wrong with the query?  Tanel: Are you sure about that? See this example in Oracle 9.2.0.4 Windows XP SQL> describe x

 Nom                            NULL ?   Type
 ------------------------------ -------- ------------
 CATEGORY                                NUMBER

SQL> select * from x ;
 CATEGORY

        1
        2

SQL> select category from x where category = 1 ;  CATEGORY

        1
SQL> -----Original Message-----
From: Tanel Põder

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>

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

--
http://www.freelists.org/webpage/oracle-l