RE: sql help, please

From: Stephens, Chris <Chris.Stephens_at_adm.com>
Date: Tue, 26 Jan 2010 12:44:53 -0600
Message-ID: <D95BD5AFADBB0F4E9BB6C53F14D3A050049CD5E29E_at_JRCEXC1V1.research.na.admworld.com>

In 11G R2 I believe there is a new function to do this as well.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Toon Koppelaars Sent: Tuesday, January 26, 2010 12:43 PM To: eugene.pipko
Cc: oracle-l_at_freelists.org
Subject: Re: sql help, please

Google for: "Tom Kyte stragg"
On Tue, Jan 26, 2010 at 7:21 PM, Eugene Pipko <eugene.pipko_at_unionbay.com<mailto:eugene.pipko_at_unionbay.com>> wrote: Hi all,
I am looking for a way for show the following

'AC_892_z30' 1,2,3
'BK_281_k16' 1,2
'FN_485_a30' 1,2

in one query if possible

Here is the data:

---

CREATE TABLE EP_FORM
(
  COL_1 VARCHAR2(30 BYTE),
  COL_2 NUMBER(3)
);

INSERT INTO EP_FORM (COL_1, COL_2) VALUES ( 'AC_892_z30', 1 );
INSERT INTO EP_FORM (COL_1, COL_2) VALUES ( 'AC_892_z30', 2 );
INSERT INTO EP_FORM (COL_1, COL_2) VALUES ( 'AC_892_z30', 3 );
INSERT INTO EP_FORM (COL_1, COL_2) VALUES ( 'BK_281_k16', 1 );
INSERT INTO EP_FORM (COL_1, COL_2) VALUES ( 'BK_281_k16', 2 );
INSERT INTO EP_FORM (COL_1, COL_2) VALUES ( 'FN_485_a30', 1 );
INSERT INTO EP_FORM (COL_1, COL_2) VALUES ( 'FN_485_a30', 2 );

Thanks,

Eugene Pipko
Seattle Pacific Industries
office: 253.872.5243
cell: 206.304.7726
P Please consider the environment before printing this e-mail

--
Toon Koppelaars
RuleGen BV
Toon.Koppelaars_at_RuleGen.com
www.RuleGen.com<http://www.RuleGen.com>
TheHelsinkiDeclaration.blogspot.com<http://TheHelsinkiDeclaration.blogspot.com>

(co)Author: "Applied Mathematics for Database Professionals"
www.RuleGen.com/pls/apex/f?p=14265:13<http://www.RuleGen.com/pls/apex/f?p=14265:13>

CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply.



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

Received on Tue Jan 26 2010 - 12:44:53 CST