Oracle Error ORA-30000: missing either trim specification or char expression in TRIM

Oracle Error Message

ORA-30000: missing either trim specification or char expression in TRIM

Reason for the Error

Since FROM is specified in TRIM function, either trim specification (TRAILING, HEADING, BOTH) or trim character or both must be specified.

Solution

Add either trim specification (TRAILING, HEADING, BOTH) or trim character or both.