Re: Questioning Oracle Documentation

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 10 Jul 2004 16:52:06 -0700
Message-ID: <1089503541.986917@yasure>

Jonathan Lewis wrote:

> Is the example the same in the 9i manual ?
>
> I believe 10g has mechanisms for promoting constant
> assignments to a position outside the loop - but possibly
> this only works in a restricted number of cases.
>
> You might try:
> n := 15
> n := 15.0
>
> c as a varchar2()
> c as char(2) -- to match the size of '15'

The example is from the 10g Tuning Guide to which I provided the link.

I can understand an implicit conversion being optimized. But faster than no conversion? I am at a loss to explain this one.

Daniel Morgan Received on Sat Jul 10 2004 - 18:52:06 CDT