Re: sql question

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


Other related posts: