ORA-00984: column not allowed here – Karan Rajpoot

In this article you will get to know how we can resolve ORA-00984: column not allowed here issue in Oracle.

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.
Advertisement
SQL> insert into employee values (1001, ‘Paul’, ‘Engineer’);
1 row created.

Hope this blog will help you!!

If this article is useful for you please comment, share with your friends.

In case of any issues please send your query to below comment section.

For more articles please do visit below links: –

ORA-12899: value too large for column | Karan Rajpoot

ORA-01119: error in creating database file | Karan Rajpoot

ORA-02140: invalid tablespace name | Karan Rajpoot

How to resolve “TNS-12541 : TNS : no listener” error

If you want to download Oracle virtual box or VMware Workstation Player, Please click on below links:-

Advertisement

Leave a Reply