Author: Dev

ORA-12899: value too large for column Oracle PL/SQL error message: ORA-12899: value too large for column. Cause: You tried to do an insert or an update column with a value too large for column. Solution: Enter a value smaller than the column width or expand the column width./p> Example: CREATE TABLE TEST( TEST_ID NUMBER NOT…(Continue Reading)

ORA-01400: cannot insert NULL into Oracle PL/SQL error message: ORA-01400: cannot insert NULL into. Cause: An attempt was made to insert a NULL into the column with not null constraint. Solution: Check and change your INSERT statement, replace the NULL with an value. Example: CREATE TABLE employees( id NUMBER NOT NULL, name VARCHAR2(250) NOT NULL,…(Continue Reading)

ORA-00947: not enough values Oracle PL/SQL error message: ORA-00947: not enough values. Cause: An INSERT statement with not enough values. Solution: Check and change your INSERT statement to avoid the duplicate values. Example: INSERT INTO employees(id, name, dept_id, salary) VALUES (‘Anne’, 20, 250); SQL Error: ORA-00947: not enough values Correct insert: INSERT INTO employees(id, name,…(Continue Reading)

ORA-00942: table or view does not exist Oracle PL/SQL error message: ORA-00942: table or view does not exist. Cause: The table or view entered does not exist. Solution: Check if you write the correct name of the table or view. Check if the table or view name exists in the database. Check if the user…(Continue Reading)

ORA-00001 unique constraint (constraint_name) violated Oracle PL/SQL error message: ORA-00001 unique constraint (constraint_name) violated. Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. Solution: Check and change your SQL statement to avoid the duplicate values. Remove the unique constraint using the command drop constraint. Example: CREATE TABLE TEST( TEST_ID NUMBER NOT NULL…(Continue Reading)