Re: sql question

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Sat, 18 Apr 2009 22:30:46 +0200
Message-Id: <76AE4AF9-6DBA-4C72-86EF-8B9EC69B2C59_at_gmail.com>



Hi Eugene,

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.
> Ive 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
Received on Sat Apr 18 2009 - 15:30:46 CDT

Original text of this message