Re: sql help, please

  • From: Toon Koppelaars <toon@xxxxxxxxxxx>
  • To: "eugene.pipko" <eugene.pipko@xxxxxxxxxxxx>
  • Date: Tue, 26 Jan 2010 19:42:41 +0100

Google for: "Tom Kyte stragg"

On Tue, Jan 26, 2010 at 7:21 PM, Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>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@xxxxxxxxxxx
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com

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

Other related posts:

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