TRIM and SUBSTR not working

From: Matthias Wirtz <Matthias.Wirtz_at_gmx.net>
Date: Wed, 09 Feb 2005 19:49:01 -0500
Message-ID: <371iaiF56ep2uU1@individual.net>

Hi,

I jus wonder why TRIM and SUBSTR are not working on one Oracle9i database server:

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Feb 10 11:47:01 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

stat_at_STAT2> select TRIM('Hello ') o from dual;

O

---

Hello

You see that the string is not trimmed. I would expected (and actually it is on a different box) the output like this:

O

---

Hello

Same happen with SUBSTR, doesn't work. But why is this different? Are there any default sql*plus settings that I'm not aware off?

--

Matthias Wirtz - Norfolk, usa Received on Wed Feb 09 2005 - 18:49:01 CST