RE: sql question
- From: Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>
- To: 'Martin Berger' <martin.a.berger@xxxxxxxxx>
- Date: Sat, 18 Apr 2009 09:54:22 -0700
Martin,
I am running 9.2 EE on Windows2K3.
I've tested union all solution and it works just fine.
Thanks,
Eugene Pipko
Seattle Pacific Industries
office: 253.872.5243
cell: 206.304.7726
P Please consider the environment before printing this e-mail.
From: Martin Berger [mailto:martin.a.berger@xxxxxxxxx]
Sent: Saturday, April 18, 2009 5:19 AM
To: Eugene Pipko
Cc: Jared Still; oracle-l-freelists
Subject: Re: sql question
Eugene,
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@xxxxxxxxx]
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@xxxxxxxxxxxx<mailto:eugene.pipko@xxxxxxxxxxxx>> 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.
Other related posts:
