ABS(-12)
→ 12ROUND(12.345, 2) -- 12.35
ROUND(12345, -1) -- 12350
TRUNC(12.345, 2)
→ 12.34MODE(12, 10)
→ 2CEIL(12.345)
→ 13FLOOR(12.345)
→ 12POWER(3, 2)
→ 12SELECT MEMBER_ID, UPPER(MEMBER_ID) AS 대문자 FROM MEMBER;
SELECT MEMBER_ID, LOWER(MEMBER_ID) AS 대문자 FROM MEMBER;
SELECT * FROM MEMBER WHERE INSTR(LOWER(MEMBER_ID), LOWER('kh')) > 0;
SUBSTR('STRING', 3) -- 3번째 문자부터 끝까지 출력
SUBSTR('STRING', 3, 2) -- 3번째 문자부터 총 2개 출력
LPAD('ORACLE', 10, '+') -- '++++++++++ORACLE'
SELECT SUM(PRICE) AS 합계, AVG(PRICE) AS 평균 FROM PRODUCT;