ORA-00984: Column not Allowed Here

Hi,

I got ” ORA-00984: Column not Allowed Here ” error in Oracle.

 

 

ORA-00984: Column not Allowed Here

 

Details of error are as follows.

ORA-00984: Column not Allowed Here
Cause: A column name was used in an expression where it is not permitted, such as in the VALUES clause of an INSERT statement.

Action: Check the syntax of the statement and use column names only where appropriate.

 

 

ORA-00984 error is related with the column name in the VALUES clause of a INSERT statement. You may use the column name in VALUES clause, you need to fix it.

For Example; if you use column_name instead of the related value in the VALUES clause,

INSERT INTO test_table
(name,last_name)
VALUES
('Mehmet', last_name);

 

You will receive the ORA-00984: Column not Allowed Here error.

 

Column not Allowed Here

Don’t use column name in the VALUES clause of INSERT statement.

You need to fix and use it as follows.

INSERT INTO test_table
(name,last_name)
VALUES
('Mehmet', 'DEVECI');

 

 

Do you want to learn Oracle SQL, then read the following articles.

Oracle SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course

 

 806 views last month,  9 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Check Also

blank

ORA-01438: value larger than specified precision allowed for this column

Hi, I got ” ORA-01438: value larger than specified precision allowed for this column” error …

Leave a Reply