sql help, please

  • From: Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 26 Jan 2010 10:21:33 -0800

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2010