Category: PL/SQL

ORA-01430: column being added already exists in table Oracle PL/SQL error message: ORA-01430: column being added already exists in table. Cause: You execute an ALTER TABLE ADD statement with a column that is already in the table. All column names must be unique within a table. Solution: Change the column name to be unique, then…(Continue Reading)

ORA-01407: cannot update to NULL Oracle PL/SQL error message: ORA-01407: cannot update to NULL. Cause: You try to make an update in a NOT NULL column. Solution: Alter table column to nullable or update column with a value. Example: CREATE TABLE TEST (TEST_ID NUMBER NOT NULL, TEST_NAME VARCHAR2(5) NOT NULL ); Insert into TEST (TEST_ID,TEST_NAME)…(Continue Reading)

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…(Continue Reading)

ORA-01418: specified index does not exist Oracle PL/SQL error message: ORA-01418: specified index does not exist. Cause: An ALTER INDEX, DROP INDEX, or VALIDATE INDEX statement specified the name of an index that does not exist. Only existing indexes can be altered, dropped, or validated. Existing indexes may be listed by querying the data dictionary.…(Continue Reading)

ORA-01408: such column list already indexed Oracle PL/SQL error message: ORA-01408: such column list already indexed. Cause: A CREATE INDEX statement specified a column that is already indexed. A single column may be indexed only once. Additional indexes may be created on the column if it is used as a portion of a concatenated index,…(Continue Reading)