[해결 방법] ORA-00960: ambiguous column naming in select list

👉 기본 환경

- Language: Oracle

 

 

⌨️ 코드

  SELECT ANIMAL_ID, 
         ANIMAL_ID, 
         SEX_UPON_INTAKE
    FROM ANIMAL_INS
   WHERE NAME IN ('Lucy', 'Ella', 'Pickle', 'Rogan', 'Sabrina', 'Mitty')
ORDER BY ANIMAL_ID
;
 

 

 

🖨️오류

ORA-00960: ambiguous column naming in select list

 

 

📡 원인

SELECT절에 조회 COL Name이 중복됨

 

 

📰 해결 방법

  SELECT ANIMAL_ID, 
         NAME, 
         SEX_UPON_INTAKE
    FROM ANIMAL_INS
   WHERE NAME IN ('Lucy', 'Ella', 'Pickle', 'Rogan', 'Sabrina', 'Mitty')
ORDER BY ANIMAL_ID
;
 

중복된 COL Name 삭제