sql question
- From: Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>
- To: 'oracle-l-freelists' <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Apr 2009 16:47:59 -0700
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:
