스트링 length 와 substring 구하기

SELECT 

ENAME, 

LENGTH(ENAME), 

HIREDATE,

SUBSTR(TO_CHAR(HIREDATE,'YYYY-MM-DD'),1,4),

TO_CHAR(HIREDATE,'YYYY') 

FROM EMP;

scott@[local]:5432 scottdb#SQL> SELECT 

ENAME, 

LENGTH(ENAME), 

HIREDATE,

SUBSTR(TO_CHAR(HIREDATE,'YYYY-MM-DD'),1,4),

TO_CHAR(HIREDATE,'YYYY') 

FROM EMP;

 ename  | length |  hiredate  | substr | to_char 

--------+--------+------------+--------+---------

 SMITH  |      5 | 1980-12-17 | 1980   | 1980

 ALLEN  |      5 | 1981-02-20 | 1981   | 1981

 WARD   |      4 | 1981-02-22 | 1981   | 1981

 JONES  |      5 | 1981-04-02 | 1981   | 1981

 MARTIN |      6 | 1981-09-28 | 1981   | 1981

 BLAKE  |      5 | 1981-05-01 | 1981   | 1981

 CLARK  |      5 | 1981-06-09 | 1981   | 1981

 SCOTT  |      5 | 1982-12-09 | 1982   | 1982

 KING   |      4 | 1981-11-17 | 1981   | 1981

 TURNER |      6 | 1981-09-08 | 1981   | 1981

 ADAMS  |      5 | 1983-01-12 | 1983   | 1983

 JAMES  |      5 | 1981-12-03 | 1981   | 1981

 FORD   |      4 | 1981-12-03 | 1981   | 1981

 MILLER |      6 | 1982-01-23 | 1982   | 1982

(14 rows)

Time: 71.738 ms

scott@[local]:5432 scottdb#SQL>