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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Simple SQL Question

Re: Simple SQL Question

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 13 Feb 2001 22:27:36 -0800
Message-ID: <3A8A2558.E28DA8F0@exesolutions.com>

> Is there a simple way to query a table whose records are formatted as
> follows:
>
> FIELD1 VARCHAR(12) - Ex. Data: NORTH
> FIELD2 VARCHAR(12) - Ex. Data: 1000
> FIELD3 VARCHAR(12) - Ex. Data: 2000
> FIELD4 VARCHAR(12) - Ex. Data: 3000
>
> with a result set that contains multiple records in the following format:
>
> NORTH 1000
> NORTH 2000
> NORTH 3000
>
> without doing a UNION? We're trying to avoid changing the table structure
> and the overhead of runniing UNION statements.

Not that I am aware of.

But by all means change the data structure. You can either do it now or do it later but you will need to do it or you will be fighting this bad design forever.

Daniel A. Morgan Received on Wed Feb 14 2001 - 00:27:36 CST

Original text of this message

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