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: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 19 Oct 2004 17:11:58 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F87ABF@irvmbxw02>


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.

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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 19 2004 - 19:07:39 CDT

Original text of this message

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