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

DRG-10833: feedback failed

1 Answers  


ORA-16629: Database reports a different protection level from the protection mode.

2 Answers  


RMAN-06074: file string is not an ORACLE datafile

1 Answers  


LFI-01507: fwrite() failed(OSD return value = string) in string.

1 Answers  


ORA-38465: failed to create the privilege checking trigger due to: string

1 Answers  






NNL-00352: Cancelled save config

1 Answers  


SQL*Loader-00258: Maximum number of SORTED INDEXES (number) exceeded on table string

1 Answers  


ORA-38445: TOP clause not allowed with no statistics

1 Answers  


ORA-02271: table does not have such constraint

1 Answers  


ORA-00703: maximum number of row cache instance locks exceeded

1 Answers  


ORA-08465: input mask contains more than 32 characters

1 Answers  


ORA-26514: object 'string.string' not found

1 Answers  


Categories