Oracle DB Error ORA-30000 missing either trim specification or char expression in TRIM

Oracle DB Error ORA-30000 missing either trim specification or char expression in TRIM

The following is the cause of this error:

Since FROM is specified in TRIM function, either trim specification (TRAILING, HEADING, BOTH) or trim character or both must be specified.

Action you can take to resolve this issue: Add either trim specification (TRAILING, HEADING, BOTH) or trim character or both.


Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution