Problem with ORA --0094 : Invalid identifier
882468Aug 15 2011 — edited Aug 15 2011Hi All,
I am facing an issue while executing a query in the Oracle 11g R2 database.
Let us take an example.
create table test (ID int not null, country_Name Varchar(20))
if i do select * from test where country_Name="someValue". It gives ORA- 0094 error and says "someValue" is invalid identifier.
whereas if i do "select * from test where country_Name='someValue'. It works fine.
Can somebody help me out. This is very urgent