Re: Oracle SQL bug in

From: Noons <>
Date: Thu, 10 Feb 2011 19:23:42 +1100
Message-ID: <ij0785$tj3$>

DG problem wrote,on my timestamp of 10/02/2011 12:04 PM:
> On Feb 10, 10:34 am, Noons<> wrote:
>> Same in 10gr2. And I suspect it'd be the same in 11g.
>> I think you've been trapped by implicit conversion in Oracle, which
>> doesn't happen in the original MSSQL.
> But there is no conversion going on. It is looking for an exact match.
> Also, you can see that the spaces are still present in the output.
> The result displayed, 'WHY ', does not equal 'WHY'.

All I can say is: read the manual I pointed out. Implicit conversion means you don't see it. Otherwise it'd be explicit. Received on Thu Feb 10 2011 - 02:23:42 CST

Original text of this message