SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00904: "STATE": invalid identifier

455054Jul 20 2006 — edited Jul 21 2006

hi all,
Here i have a very simple query but it has given me a lot of headache.Can some one look at it and point me where  i made a mistake.
I have the filed state in my database and i do not know why it keep saying  invalid identifer.by the way i am using this in my asp.net page and i am using visual studio 2005. thanks

select * from VENDORDETAIL WHERE STATE  LIKE '%'||Upper('&State')||'%'

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 18 2006

Added on Jul 20 2006

10 comments

3,670 views