Saturday, July 18, 2009

Solution for-ORA-00904:string: invalid identifier

REASON:

if you entered a invalid column name in SELECT,UPDATE queries you will get this error
So you have to check the below conditions.

SOLUTION :
1.please enter the valid column name from the table.
2.Column name criterias:
a.Column name should not be reserved words.
b.Column name must begin with a letter.
c.Column name should be <=30 Characters and consist of alpha numeric char.. and Special char.. like #,_ and $. Thanks
A.T.J

No comments:

Post a Comment