Re: sql question

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@xxxxxxxxx> 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@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: