RE: sql help, please
From: Eugene Pipko <eugene.pipko_at_unionbay.com>
Date: Tue, 26 Jan 2010 10:42:44 -0800
Message-ID: <34DB87F47199374280ADFD2968CDBCFA88160346E1_at_MAIL01KT.seattlepacificindustries.com>
Thanks, but I forgot to mention that I am on 9.2.0.8
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Eugene Pipko Sent: Tuesday, January 26, 2010 1:22 PM
To: 'oracle-l_at_freelists.org'
Subject: sql help, please
CREATE TABLE EP_FORM
(
COL_1 VARCHAR2(30 BYTE),
COL_2 NUMBER(3)
Date: Tue, 26 Jan 2010 10:42:44 -0800
Message-ID: <34DB87F47199374280ADFD2968CDBCFA88160346E1_at_MAIL01KT.seattlepacificindustries.com>
Thanks, but I forgot to mention that I am on 9.2.0.8
Eugene Pipko
Seattle Pacific Industries
office: 253.872.5243
cell: 206.304.7726
P Please consider the environment before printing this e-mail
From: Michael McMullen [mailto:ganstadba_at_hotmail.com] Sent: Tuesday, January 26, 2010 10:45 AM To: Eugene Pipko; oracle-l_at_freelists.org Subject: RE: sql help, please
Look up stragg on asktom.oracle.com or I believe 11GR2 has this now as an analytical
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Eugene Pipko Sent: Tuesday, January 26, 2010 1:22 PM
To: 'oracle-l_at_freelists.org'
Subject: sql help, please
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)
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 26 2010 - 12:42:44 CST