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

ORA-01619: thread string is mounted by another instance

1 Answers  


ORA-31657: data filter name can not be defaulted

1 Answers  


DRG-50951: Unable to resolve element name for attribute string

1 Answers  


TNS-12642: No session key

1 Answers  


ORA-13051: failed to initialize spatial object

1 Answers  






TNS-01024: Trace Level string

1 Answers  


ORA-27200: skgfpgo: sbtpcstart returned error

1 Answers  


ORA-01565: error in identifying file 'string'

1 Answers  


ORA-27213: failed to unload Media Management Library

1 Answers  


KUP-11009: data for row: string

1 Answers  


ORA-01117: adding file 'string' with illegal block size: string; limit is string

1 Answers  


ORA-19037: XMLType result can not be a fragment

1 Answers  


Categories