[Oracle] 컬럼명에 Space가!!! ( column name with space )

[Oracle] 컬럼명에 Space가!!! ( column name with space )

컬럼명이 끝에 Space가 들어가니 찾는데 한참 걸렸음 ㅠㅠ

WITH TEMP AS ( SELECT '1' AS "Col1",'2' AS "Col2",'3' AS "Col3 " FROM DUAL ) SELECT Col3 FROM TEMP;

----------- Result --------------

ORA-00904: "COL3": invalid identifier

00904. 00000 -  "%s: invalid identifier"

*Cause:    

*Action:

5행, 8열에서 오류 발생

< 해결책 >

1. 컬럼명 Space 제거 - 가능한 컬럼명에 Space가 들어가는 것을 권장하지 않음, 디버깅 어려움

2. 큰 따음표 활용

WITH TEMP AS ( SELECT '1' AS "Col1",'2' AS "Col2",'3' AS "Col3 " FROM DUAL ) SELECT "Col3 " FROM TEMP;

----------- Result --------------

C

-

3