[Oracle SQL] SELECT 실습_ ALIAS

[Oracle SQL] SELECT 실습_ ALIAS

I ALIAS

▶ ALIAS : Table Alias, Column Alias

1. 공백문자

SELECT ENAME, SAL+500 BONUS FROM EMP;

2. AS

SELECT ENAME, SAL*12 AS ANNUAL_SAL FROM EMP;

3. " " : 특수문자, 공백문자, 대소문자 구분이 필요한 경우

SELECT ENAME, COMM+500 AS "SPECIAL BONUS" FROM EMP;