¡á¿¹ 5_4_16 || CONCAT ÇÔ¼ö »ç¿ë ¿¹
SELECT CONCAT ('KO' , 'REA') FROM DUAL;
¡á¿¹ 5_4_17 || LTRIM ÇÔ¼ö »ç¿ë ¿¹
____SELECT LTRIM('##2013³â', '#') AS YEAR FROM DUAL;
¡á¿¹ 5_4_18 || RTRIM ÇÔ¼ö »ç¿ë ¿¹
SELECT RTRIM ('##2013³â' , '³â') YEAR FROM DUAL;
¡á¿¹ 5_4_19 || INITCAP ÇÔ¼ö »ç¿ë ¿¹
SELECT INITCAP('KOREA') AS NATION FROM DUAL;
¡á¿¹ 5_4_20 || SUBSTR ÇÔ¼ö »ç¿ë ¿¹
SELECT SUBSTR('KOREA', 1, 3) AS NATION FROM DUAL;
¡á¿¹ 5_4_21 || LPAD ÇÔ¼ö »ç¿ë ¿¹
SELECT LPAD('KOREA', 7, '$' ) AS NATION FROM DUAL;
¡á¿¹ 5_4_22 || REPLACE ÇÔ¼ö »ç¿ë ¿¹
SELECT REPLACE('KOREA', 'A', 'AN') AS NATION FROM DUAL;
¡á¿¹ 5_4_23 || ASCII ÇÔ¼ö »ç¿ë ¿¹
SELECT ASCII('K') FROM DUAL;
¡á¿¹ 5_4_24 || LENGTH ÇÔ¼ö »ç¿ë ¿¹
SELECT LENGTH('DRAGON') FROM DUAL;
¡á¿¹ 5_4_25 || TO_CHAR ÇÔ¼ö »ç¿ë ¿¹
SELECT TO_CHAR(SYSDATE, 'YY-MM-DD-DY') AS DAY FROM DUAL;
¡á¿¹ 5_4_26 || ¼ýÀÚ Å¸ÀÔÀÇ µ¥ÀÌÅÍ Çü º¯È¯
SELECT TO_CHAR(SALARY, '$99,999') AS SALARY FROM INSA;
¡á¿¹ 5_4_27 || INSTR ÇÔ¼ö »ç¿ë ¿¹
SELECT INSTR('ABCDABBBCD', 'B', '3', '2' ) AS SEARCH_B FROM DUAL;
¡á¿¹ 5_4_28 || SYSDATE »ç¿ë ¿¹
SELECT SYSDATE FROM DUAL;
SELECT TO_CHAR(SYSDATE, 'MONTH') AS MONTH FROM DUAL;
SELECT TO_CHAR(SYSDATE, 'DAY') AS DAY FROM DUAL;
SELECT TO_CHAR(SYSDATE, 'YYYY-MM-DD-HHAM-MI-SS')
AS F_D
FROM DUAL;
¡á¿¹ 5_4_29 || LAST_DAY ÇÔ¼ö »ç¿ë ¿¹
SELECT LAST_DAY( TO_DATE( '20130214', 'YYYYMMDD'))
AS MONTH_LASTDAY
FROM DUAL;
¡á¿¹ 5_4_30 || MONTHS_BETWEEN ÇÔ¼ö »ç¿ë ¿¹
SELECT ROUND( MONTHS_BETWEEN (
TO_DATE( '20130201', 'YYYYMMDD'),
TO_DATE( '20130101', 'YYYYMMDD')), 3) MONTH
FROM DUAL;
¡á¿¹ 5_4_31 || TO_DATE ÇÔ¼ö »ç¿ë ¿¹
SELECT TO_DATE('20130214', 'YYYYMMDD') AS MONTH
FROM DUAL;
¡á¿¹ 5_4_32 || ADD_MONTHS ÇÔ¼ö »ç¿ë ¿¹
SELECT ADD_MONTHS(TO_DATE('20130214', 'YYYYMMDD'), 3) AS MONTH
FROM DUAL;
¡á¿¹ 5_4_33 || NEXT_DAY ÇÔ¼ö »ç¿ë ¿¹
SELECT NEXT_DAY(TO_DATE('20130127', 'YYYYMMDD'),
'SUNDAY') AS MONTH
FROM DUAL;
¡á¿¹ 5_4_34 || NVL ÇÔ¼ö »ç¿ë ¿¹
SELECT ROWNUM, T1.*
FROM (
SELECT SABUN, ENG_NAME, ZIP,
NVL(ZIP, 'unknown') AS ZIPCODE
FROM INSA
WHERE JOIN_GBN_CODE='RGL'
) T1
WHERE ROWNUM <= 10;
¡á¿¹ 5_4_35 || DECODE ÇÔ¼ö »ç¿ë ¿¹
SELECT ROWNUM, T1.*
FROM (
SELECT SABUN, ENG_NAME, JOIN_GBN_CODE,
DECODE(JOIN_GBN_CODE, 'RGL', 'Á¤Á÷¿ø', 'CMP', '¾÷üÁ÷¿ø',
'CNT','°è¾àÁ÷¿ø', 'ÇÁ¸®·»¼') AS Á÷¿øÇüÅÂ
FROM INSA
) T1
WHERE ROWNUM <= 10;
¡á¿¹ 5_4_36 || CASE ÇÔ¼ö »ç¿ë ¿¹
SELECT ROWNUM, T1.*
FROM (
SELECT SABUN, ENG_NAME, SEX, (CASE SEX WHEN 'M' THEN '³²'
WHEN 'F' THEN '¿©'
ELSE '¸ð¸§'
END) ¼ºº°
FROM____ INSA
) T1
WHERE ROWNUM <= 11;