: 문자열끼리 연결
SELECT CONCAT('Hello','bye') , CONCAT('good','bad')
FROM dual
;
SELECT CONCAT('good','bad') , 'good' || 'bad'
FROM dual
;
SELECT INITCAP('good morning')
FROM dual
;
SELECT LOWER('GooD'), UPPER('good')
FROM dual
;
SELECT LPAD('good', 5) "LPAD1"
, LPAD('good', 7, '#') "LPAD2"
, LPAD('good', 8, 'L') "LPAD3"
FROM dual
;
SELECT RPAD('good', 5) "RPAD1"
, RPAD('good', 7, '#') "RPAD2"
, RPAD('good', 8, 'L') "RPAD3"
FROM dual
;
SELECT LTRIM('goodbye','g')
, LTRIM('goodbye','o')
, LTRIM('goodbye','go')
, LTRIM('oooooodbye','o')
FROM dual
;
SELECT RTRIM('goodbye','e')
, RTRIM('goodbye','i')
, RTRIM('goodbye','ye')
, RTRIM('goodbyeoooooo','o')
FROM dual
;