Re: sql question

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 17 Apr 2009 10:51:37 -0700
Message-ID: <bf46380904171051h55b04eax104eea93e23d33bb_at_mail.gmail.com>

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>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 - 12:51:37 CDT