Oracle Database Discussions

Hi,

I am getting a below error when I invoke the SQL : select order_id,count(order_id) as CART_ITEMS_COUNT from item_order group by order_id

ORA-00911: invalid character

00911. 00000 -  "invalid character"

*Cause:    identifiers may not start with any ASCII character other than

           letters and numbers.  $#_ are also allowed after the first

           character.  Identifiers enclosed by doublequotes may contain

           any character other than a doublequote.  Alternative quotes

           (q'#...#') cannot use spaces, tabs, or carriage returns as

           delimiters.  For all other contexts, consult the SQL Language

           Reference Manual.

*Action:

Error at Line: 10 Column: 57

Why I am getting the Invalid char error for "FROM" keyword? please let me know your opinion?

Thanks