RE: QUERY
- From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Oct 2004 17:11:58 -0700
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@xxxxxxxxxxx>
> Please suggest what is wrong in following query?
>
> SELECT CATEGORY_ID FROM CATEG WHERE CATEGORY = :b1
--
//www.freelists.org/webpage/oracle-l
Other related posts:
