Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL structure which enables selecting into and referencing by integers

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

From: Victor Engmark <victor.engmark_at_cern.ch>
Date: Wed, 27 Oct 2004 13:43:49 +0200
Message-ID: <clo1lk$5s$1@sunnews.cern.ch> 





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.


-- 
Victor Engmark


Received on Wed Oct 27 2004 - 06:43:49 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US