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

Home -> Community -> Usenet -> c.d.o.server -> Re: Help writing SQL query

Re: Help writing SQL query

From: Tony Andrews <andrewst_at_onetel.com>
Date: 7 Dec 2004 05:25:26 -0800
Message-ID: <1102425926.806628.148740@c13g2000cwb.googlegroups.com>


DA Morgan wrote:
> If the data was normalized the query would be trivial. As you seem to
> prefer to not fix the underlying problem you have a much more
difficult
> problem. Perhaps someone else will help you swim upstream.

I think you are missing Barry's point somewhat. The fact is he has been GIVEN some data in this awful structure. Sure, he can define a new better structure but even then he still has to migrate the EXISTING data from the old structure to the new, which will require some SQL. That still requires a solution to the problem: how do you query the data that currently exists? Received on Tue Dec 07 2004 - 07:25:26 CST

Original text of this message

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