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-24085: operation failed, queue string is invalid

1 Answers  


ORA-13332: invalid LRS point

1 Answers  


PLS-00656: field 'string' not available in input argument

1 Answers  


ORA-29547: Java system class not available: string

1 Answers  


PCB-00638: This attribute is only valid for internal or external LOB types

1 Answers  






NNL-00854: Fastest rename processing time: string

1 Answers  


ORA-26011: Cannot load type string into column string in table string

1 Answers  


QSM-02170: tables must be identical across the UNION operator

1 Answers  


EXP-00017: feature "string" is needed, but not present in database

1 Answers  


ORA-33024: (XSAGDNGL11) AGGMAP workspace object contains duplicate information.

1 Answers  


ORA-02404: specified plan table not found

2 Answers  


ORA-26536: refresh was aborted because of conflicts caused by deferred transactions

1 Answers  


Categories