Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

PLS-00626: partitioned/clustered/ordered parameter must be a function argument

1 Answers  


NNL-00907: NOT ALLOWED responses sent: number

1 Answers  


PLS-00649: method "string" can be overridden only once per object type

1 Answers  


LFI-00111: No other flags allowed in fixed length format.

1 Answers  


SQL*Loader-00650: incomplete lob data written for column string, row number, table string

1 Answers  






DGM-16952: unable to describe configuration

1 Answers  


ORA-09924: Can't spawn process - core dump directory not created properly

1 Answers  


ORA-25271: queue table not found for the given queue

1 Answers  


TNS-12204: TNS:received data refused from an application

1 Answers  


TNS-01081: Started with pid=string

1 Answers  


ORA-13381: table:string not found in network:string

1 Answers  


O2U-00203: Type to be declared must be an object type or a named collection type

1 Answers  






Categories