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
> 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.
