sql - ORA 00904 Error:Invalid Identifier -
i have installed oracle 10g in virtual xp , created 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 table created successfully.but when trying fetch values simple query like
select fname, lname reg1 uname="bbb"; i getting error
ora-00904: "bbb": invalid identifier
i cannot understand have done wrong here.
use single quotes.
select fname,lname reg1 uname='bbb';
Comments
Post a Comment