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

Popular posts from this blog

c# - Operator '==' incompatible with operand types 'Guid' and 'Guid' using DynamicExpression.ParseLambda<T, bool> -