[Oracle] ORA-00984: 열을 사용할 수 없습니다

 

 

ORA-00984: 열을 사용할 수 없습니다

 

• insert에서 문자열에 작은따옴표를 하지 않았을 경우
• 오타

 

나의 경우에는 작은따옴표가 문제였다.

 

수정전

INSERT INTO ACCUM_HOUR_INFO(
WORKER_NAME,PERSONAL_NO,BRANCH,ORG_NM,SERVICE_TYPE,SERVICE_NAME,WORKER_TEL,
ACCUM_YEAR,ACCUM_MONTH,ACCUM_HOUR,OVERTIME_HOUR,MEMO,
"1_DAY","2_DAY","3_DAY","4_DAY","5_DAY","6_DAY","7_DAY","8_DAY","9_DAY","10_DAY",
"11_DAY","12_DAY","13_DAY","14_DAY","15_DAY","16_DAY",
"17_DAY","18_DAY","19_DAY","20_DAY","21_DAY","22_DAY","23_DAY","24_DAY","25_DAY","26_DAY",
"27_DAY","28_DAY","29_DAY","30_DAY","31_DAY"
)VALUES(
"홍길동","991111-2","강원지사","AA"M","시장형","사업명","010","2022","9","18","0",NULL,"9","9",NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

 

수정후

INSERT INTO ACCUM_HOUR_INFO(
WORKER_NAME,PERSONAL_NO,BRANCH,ORG_NM,SERVICE_TYPE,SERVICE_NAME,WORKER_TEL,
ACCUM_YEAR,ACCUM_MONTH,ACCUM_HOUR,OVERTIME_HOUR,MEMO,
"1_DAY","2_DAY","3_DAY","4_DAY","5_DAY","6_DAY","7_DAY","8_DAY","9_DAY","10_DAY",
"11_DAY","12_DAY","13_DAY","14_DAY","15_DAY","16_DAY",
"17_DAY","18_DAY","19_DAY","20_DAY","21_DAY","22_DAY","23_DAY","24_DAY","25_DAY","26_DAY",
"27_DAY","28_DAY","29_DAY","30_DAY","31_DAY"
)VALUES(
'홍길동','991111-2','강원지사','AAA,'시장형','사업명','010','2022','9','18','0',NULL,'9','9',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

 

요렇게 큰따옴표(" ")로 감싸서 표현했던 문자를 작은따옴표(' ')로 감쌌다