by 임세엽 [Oracle 기초] 서브쿼리 [2013.01.11 10:43:39]
컬럼명 재정의는 AS를 쓰시면 되용~ SELECT '홍길동' AS USER_NAME FROM DUALSELECT USER_NAME AS 성명 FROM ( SELECT '홍길동' AS USER_NAME FROM DUAL)