Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Simple SQL Question
> > 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
(Lots of confusing stuff snipped . . .)
Why not:
select field1, field2 from yourtable
union
select field1, field3 from yourtable
union
select field1, field4 from yourtable;
Then go back and redesign the table properly.