Re: Help with simple PL/SQL

DFS wrote:

> Wow. 18x speedup is plenty awesome.

It is.

> I ran your code and got 1.04 and 0.01 for the slow and fast ways (I'm
> running Oracle 9.2).

But you realize you beat 100% in your test confirming my statement.

So when I say there is almost no excuse in Oracle 9i or above for using cursor loops ... you understand why.

Demos with many variations of this including exception handling are in my library at www.psoug.org.

> The procedure I use, with the cursor loop as Will Robertson suggested,
> registers Elapsed: 00:00:00.00 so I don't think array processing will be a
> time-saver for my small datasets.

It may not be about time. It may be about multiple users and internal resources. Even with 0 time you are consuming resources. Now if you have 0 time and 1 user ... that might be another matter.

> (btw, I know you like Access, so I'll tell you it takes Access about 4
> seconds using the cursor loop equivalent, and about 2 seconds using DAO
> recordset edits).

I love M$ Access. Much of my income, in the past, was derived from consolidating junk built in Access into relational schemas in Oracle.

> The more I use Oracle the better I think of it. It's just a fantastic dbms.
>
> Thanks for the demo - I may be able to incorporate those techniques in other
> ways.

Glad I could help.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)