OracleString FunctionsTRANSLATE
INITCAP

TRANSLATEString Functions

TO_CHAR

Performs character-by-character substitution.

Syntax

TRANSLATE(str, from, to)

Example

Enter values below to update the example in real time.

comment_text
masked
comments
-- 한글 모음 제거 (예시)
SELECT TRANSLATE(comment_text, 'aeiou', '*****') AS masked
FROM comments;