Re: QUERY
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, Tanel Põder <tanel.poder.003@xxxxxxx>
- Date: Wed, 20 Oct 2004 12:32:46 +0200
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@xxxxxxx> 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
Other related posts: