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



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

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NZE-28817: PL/SQL function returned an error.

1 Answers  


ORA-26049: Unscoped REF column has non-existent table name.

1 Answers  


TNS-00282: Connection Manager: Failed to force log, logging is off

1 Answers  


ORA-06555: this name is currently reserved for use by user SYS

1 Answers  


ORA-06445: ssvpstevrg: Incorrect parameters passed to function call

1 Answers  






ORA-01624: log string needed for crash recovery of instance string (thread string)

1 Answers  


ORA-09747: pw_detachPorts: server call pws_detach failed.

1 Answers  


ORA-02802: No idle servers available in parallel mode

1 Answers  


RMAN-06096: SWITCH required for newname of datafile string to take effect

1 Answers  


ORA-00264: no recovery required

1 Answers  


TNS-02526: server proxy type does not match client type

1 Answers  


RMAN-06551: error while looking up datafilecopy for file number: string

1 Answers  


Categories