Re: sql question

in this case maybe you can provide informations about the Oracle Version, SE/EE, OS, ... as this might affect possible solutions.

br
  Martin

Am 17.04.2009 um 20:13 schrieb Eugene Pipko:

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




application/pkcs7-signature attachment: smime.p7s