Re: QUERY

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Wed, 20 Oct 2004 12:32:46 +0200
Message-Id: <200410201032.i9KAWkoF026739@webmail.nexlink.net>

Which leaves us back, regarding the initial question 'What's wrong in the query' with any answer from 'are you sure that your ORACLE_SID is properly set ?' to 'Are you in the right schema?' or 'define a variable to bind' or 'run queries under SQL*Plus, not directly from the shell'. :-). Regards,

Stephane Faroult

RoughSea Ltd
http://www.roughsea.com

On Wed, 20 Oct 2004 13:08 , Tanel Põder <tanel.poder.003_at_mail.ee> sent:

>Tanel: Are you sure about that? See this example in Oracle 9.2.0.4
Windows XP

Well, "category" is a reserved word (as seen from v$reserved_words) used for maintaining outlines, but as your test shows (and which I should have done before sending my reply), this word can be used freely in SQL.

Tanel.

--
http://www.freelists.org/webpage/oracle-l[1]



--- Links ---
   1 modules/refer.pl?redirect=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Foracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 20 2004 - 05:17:38 CDT