Re: PL/SQL structure which enables selecting into and referencing by integers

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 27 Oct 2004 19:03:59 -0700
Message-ID: <1098928980.603783@yasure>

Victor Engmark wrote:

> DA Morgan wrote:
>

>> If you have a table with more than 200 columns the problem is not your
>> SQL ... the problem is the table. Take a serious look at Cobb and Date's
>> rules of normalization and act on them.

>
>
> No can do, as I have no control over it and it is used by a lot of
> people, but I managed to get a solution using a normal table which is
> dropped at the end of the procedure. Ugly, but it works, and the code is
> now a lot easier to read.
>
> Thanx anyway.

Ouch!

Never create or drop tables in a procedure. Look at global temporary tables.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Wed Oct 27 2004 - 21:03:59 CDT