Re: TRIM and SUBSTR not working

From: Anurag Varma <avoracle_at_gmail.com>
Date: 10 Feb 2005 13:18:27 -0800
Message-ID: <1108070307.726966.116010@o13g2000cwo.googlegroups.com>

ah ... then I recall incorrectly.
How about cursor sharing?

ORA92> select trim('Hello ') from dual;

TRIM('HELLO')

---

Hello

ORA92> show parameter cursor_sharing

NAME                                 TYPE

VALUE
------------------------------------ --------------------------------

---

cursor_sharing                       string

SIMILAR
ORA92> alter session set cursor_sharing=exact;

Session altered.

ORA92> select trim('Hello ') from dual;

TRIM(

---

Hello

Anurag Received on Thu Feb 10 2005 - 15:18:27 CST