RE: sql question

Martin,
I am running 9.2 EE on Windows2K3.
I've tested union all solution and it works just fine.
Thanks,

Eugene Pipko
Seattle Pacific Industries
office: 253.872.5243
cell: 206.304.7726
P  Please consider the environment before printing this e-mail.

From: Martin Berger [mailto:martin.a.berger@xxxxxxxxx]
Sent: Saturday, April 18, 2009 5:19 AM
To: Eugene Pipko
Cc: Jared Still; oracle-l-freelists
Subject: Re: sql question

Eugene,

in this case maybe you can provide informations about the Oracle Version, 
SE/EE, OS, ... as this might affect possible solutions.

br
 Martin

Am 17.04.2009 um 20:13 schrieb Eugene Pipko:


Jared,
I understand what you're saying, but we're dealing with an application/database 
that we've purchased, so I guess I my case it is writing sql against it. 
Hopefully not horribly misshapen sql as you mentioned.

Eugene Pipko
Seattle Pacific Industries
office: 253.872.5243
cell: 206.304.7726
P  Please consider the environment before printing this e-mail.

From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: Friday, April 17, 2009 10:52 AM
To: Eugene Pipko
Cc: oracle-l-freelists
Subject: Re: sql question

Stephane exercise great restraint in not mentioning this,
but I am not feeling so restrained. :)

If you have in your power any ability to influence the
design of this database to make it something that
resembles normalized data, please do so.

It will save you hours of frustration in the future.

And if not, well, look forward to writing lots
of horribly misshapen SQL.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist



On Thu, Apr 16, 2009 at 4:47 PM, Eugene Pipko 
<eugene.pipko@xxxxxxxxxxxx<mailto:eugene.pipko@xxxxxxxxxxxx>> wrote:

Hi all,

I have a table with the following columns:



HTS_CODE                             HTS_DESC

-----------------------                 
-----------------------------------------

338K10_340W81                6109.10.0027 & 6205.20.2061

338K5_338K9_1                  6105.10.0030 & 6110.20.2069



I need to be able to select in the following format:



HTS_CODE                             HTS_DESC

-----------------------                 
-----------------------------------------

338K10_340W81                6109.10.0027

338K10_340W81                6205.20.2061

338K5_338K9_1                  6105.10.0030

338K5_338K9_1                  6110.20.2069



Is it possible to split hts_desc so for every value before and after "&" I will 
get a row using SQL?

Thanks,





Eugene Pipko

Seattle Pacific Industries

office: 253.872.5243

cell: 206.304.7726

P  Please consider the environment before printing this e-mail.

Other related posts: