[oracle] initcap

Published: 2020-04-16 by mascaradee

• Categories:
• oracle 14

• Tags:
• initcap 1

첫 글자를 대문자로

SELECT INITCAP('abc') FROM DUAL;
--Abc

SELECT INITCAP('abc de') FROM DUAL;
--Abc De

SELECT INITCAP('abc_de') FROM DUAL;
--Abc_De