Re: sql question

From: Mathias Magnusson <mathias.magnusson_at_gmail.com>
Date: Fri, 17 Apr 2009 20:12:21 +0200
Message-ID: <8580d4110904171112y266c93f8s5b6d57b7ba9dbc55_at_mail.gmail.com>

Amen to that! If that is in fact a possibility, then I think we'd all cheer you on as you(op) take on that task.

Mathias

On Fri, Apr 17, 2009 at 7:51 PM, Jared Still <jkstill_at_gmail.com> wrote:

> 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 - 13:12:21 CDT