ORA-00984: column not allowed here
953429Aug 17 2012 — edited Aug 17 2012Hello 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