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. -- //www.freelists.org/webpage/oracle-l[1] --- Links --- 1 modules/refer.pl?redirect=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Foracle-l -- //www.freelists.org/webpage/oracle-l