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