Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00984: column not allowed here

953429Aug 17 2012 — edited Aug 17 2012
Hello all,

Kindly anyone please throw some light on this error called "ORA-00984: column not allowed here"?

I have created a table:

CREATE TABLE JB(ENAME VARCHAR(20));

Table Created.

Now if I INSERT:

INSERT INTO JB VALUES (Sathik);

ORA-00984: column not allowed here

Why this error, also if i insert a number in the place of "Sathik", inserting is possible. Any characters is not allowed.

What is the column name in this, Its weird totally for me.

Please anyone help me.

Thanks & Regards,
Sathik
This post has been answered by Manguilibe KAO on Aug 17 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2012
Added on Aug 17 2012
5 comments
319 views