Re: sql question

just an idea, but maybe you want to create 2 function based indexes on this column.
this might make your query faster (as the result is pre-calculated and stored in a hidden column)

I don't know if you have any performance-problems, but I prefer to calculate once and use often than other way round ;-)

best regards,
  Martin

> Martin,
> I am running 9.2 EE on Windows2K3.
> I’ve tested union all solution and it works just fine.
> Thanks,
>
> 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,
>

--
http://www.freelists.org/webpage/oracle-l




application/pkcs7-signature attachment: smime.p7s