RE: sql question

From: Eugene Pipko <eugene.pipko_at_unionbay.com>
Date: Fri, 17 Apr 2009 11:13:06 -0700
Message-ID: <34DB87F47199374280ADFD2968CDBCFA87D621F92D_at_MAIL01KT.seattlepacificindustries.com>

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_at_gmail.com] 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_at_unionbay.com<mailto:eugene.pipko_at_unionbay.com>> 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.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 17 2009 - 13:13:06 CDT