[Oracle/오라클]오류 보고 -ORA-00001: unique constraint (SYSTEM.SYS

728x90

BIG

insert into test(idNum, name) values(99999,'철이')
오류 보고 -
ORA-00001: unique constraint (SYSTEM.SYS_C006998) violated

프라이머리키가 겹치는 것이 있어서 그렇다 프라이머리키 벨류값을 바꿔주면 들어감

728x90

BIG

[Oracle/오라클]ORA-00904: "STUDENT": invalid identifier00904. 00000 - "%s: invalid identifier"*Cause: (0)	2022.11.09
[Oracle/오라클]ORA-00905: missing keyword00905. 00000 - "missing keyword" (0)	2022.11.09
[Oracle/오라클]insert into test(idNum, name) values(값)오류 보고 -ORA-12899: value too large for column "SYSTEM"."TEST"."NAME" (actual: 12, maximum: 9) (0)	2022.11.09
[Oracle/오라클] ORA-00942: table or view does not exist00942. 00000 - "table or view does not exist"Cause: Action:32행, 15열에서 오류 발생 (0)	2022.11.09
[Oracle/오라클]ORA-01438: value larger than specified precision allowed for this column 에러 (0)	2022.11.09