ORA 00904 Error:Invalid Identifier

Question

I have installed Oracle 10g in my virtual XP and created a table using

create table reg1 (
  fname varchar2(30),
  lname varchar2(30),
  addr varchar2(30),
  mail varchar2(30),
  occu varchar2(30),
  uname varchar2(30),
  passwd varchar2(30)
);

and the table created successfully.But when I am trying to fetch the values by simple query like

select fname, lname 
  from reg1 
 where uname="bbb";

I am getting error like

ORA-00904: "bbb": invalid identifier

I cannot understand what I have done wrong here.

Andrew Leach · Accepted Answer · 2012-06-30 19:47:21Z

19

Use single quotes.

select fname,lname from reg1 where uname='bbb';

answered Jun 30, 2012 at 19:47

Andrew Leach

13k1 gold badge44 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ben · Accepted Answer · 2012-06-30 20:34:01Z

7

Oracle uses double quotes " in order to identify cased object names. For instance the table "test" is not the same as the table test.

Strings should be enclosed by single quotes, '.

Making your query:

select fname, lname from reg1 where uname = 'bbb';

What's actually happening in your query is Oracle is trying to find the column "bbb" in the table reg1, as this column doesn't exist you get the error thrown.

edited Jun 30, 2012 at 20:34

answered Jun 30, 2012 at 19:51

Ben

53.1k36 gold badges133 silver badges156 bronze badges

1 Comment

OMG Ponies Over a year ago

Not just Oracle, all SQL databases

Collectives™ on Stack Overflow

ORA 00904 Error:Invalid Identifier

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related