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

LSX-00114: facet "~S" not in schema schema

1 Answers  


ORA-10920: Cannot offline tablespace belonging to default temporary tablespace group

1 Answers  


ORA-32591: connect string too long

1 Answers  


ORA-30379: query txt not specified

1 Answers  


ORA-39502: failed to notify CRS of a Startup/Shutdown event [number] (ignored)

1 Answers  






ORA-25444: invalid ROWID: string for table alias: string

1 Answers  


O2F-00324: Unable to convert from the database character set to the compiler character set

1 Answers  


TNS-12213: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

1 Answers  


DRG-10016: you must be the owner to modify this object

1 Answers  


TNS-00014: INTCTL: error while opening terminal input channel

1 Answers  


ORA-23467: flavor lacks object "string"."string"

1 Answers  


ORA-12032: cannot use rowid column from materialized view log on "string"."string"

1 Answers  


Categories