ORA-00957: duplicate column name

ORA-00957: duplicate column name

Oracle PL/SQL error message: ORA-00957: duplicate column name.

Cause:

A column name was specified twice in a CREATE or INSERT statement. Column names must be unique within a table, view, or cluster.

Solution:

In a CREATE statement, change one of the column names to a new, unique column name. In an INSERT statement, remove one of the duplicate names.

Example:

CREATE TABLE TEST 
(TEST_ID NUMBER, 
TEST_NAME VARCHAR2(5)
); 

Insert into TEST (TEST_ID,TEST_NAME, TEST_NAME) values (1,'abc', 'def');

Output:

ORA-00957: duplicate column name

Correct:

Insert into TEST (TEST_ID,TEST_NAME) values (1,'abc');

Output:

1 rows inserted.