Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: TRIM and SUBSTR not working

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US