Re: LTRIM/RTRIM returning NULL

From: Tim X <timx_at_spamto.devnul.com>
Date: 08 Feb 2003 14:41:30 +1100
Message-ID: <87lm0rsal1.fsf_at_tiger.rapttech.com.au>

>>>>> "Vattekkat" == Vattekkat Satheesh Babu <vattekkat.babu_at_verizon.net> writes:

Vattekkat> Folks, Anyone knows the rational behind LTRIM(' ') or Vattekkat> RTRIM(' ') returning NULLs instead of blank strings ''?

Vattekkat> Curious

Oracle treats '' as NULL - its a bit irritating and they don't guarantee this will always be the situation, but for now....

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!

Received on Sat Feb 08 2003 - 04:41:30 CET

This message: [ Message body ]
Next message: Tim X: "Re: Multiple triggers on the same table"
Previous message: Tim X: "Re: ORA-00904 when selecting from database link"
Maybe in reply to: Guido Konsolke: "Re: LTRIM/RTRIM returning NULL"
Next in thread: Tim X: "Re: Multiple triggers on the same table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message