ORA-00984: column not allowed here - Karan Rajpoot

                                                  ORA-00984: column not allowed here

Error: - ORA-00984: column not allowed here.



Cause: - When you try to insert the value in a table and forget to enclose the string value in a single quote, then you will get this error.



Solution: - Put the string value under single quotes and re-execute the command again.


Example: - 

SQL> insert into employee values (1001, Paul, Engineer);
insert into employee values (1001, Paul, Engineer)
                                         *
ERROR at line 1:
ORA-00984: column not allowed here

Note: - In the above output string value has not enclosed with single quotes, To resolve this, Put the string value under single quotes and re-run the command again like below.

SQL> insert into employee values (1001, 'Paul', 'Engineer');

1 row created.

Hope that will resolve your issue.

Popular posts from this blog

How to resolve "No protocol specified" error

How to resolve "TNS-12541 : TNS : no listener" error

Oracle "Redo log Groups addition/deletion" | Karan Rajpoot