Re: Questioning Oracle Documentation

From: Matt <mathewbutler_at_yahoo.com>
Date: 21 Jul 2004 02:56:59 -0700
Message-ID: <19f48a45.0407210156.2a20b45@posting.google.com>

Interesting.

Have a read of:

http://otn.oracle.com/tech/pl_sql/files/CodeOrder.zip

I guess that it is something to do with the fact that a character cannot have an overflow exception raised and so the compiler can make some additional optimisations not available when manipulating the number datatype.

Like I said, I guess.

I'm interested to find out what people think of the paper.

Mat.

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1089492156.252777_at_yasure>...
> In Tuning PL/SQL Applications for Performance
> http://download-west.oracle.com/docs/cd/B13789_01/appdev.101/b10807/12_tune.htm#LNPLS012
> I found the following and decided it could make a good demo for my students.
>
> So here's what I wrote:
>
> DECLARE
>
> c CHAR(5);
> i PLS_INTEGER;
> j PLS_INTEGER;
> n NUMBER := 0;
Received on Wed Jul 21 2004 - 04:56:59 CDT