RE: sql help, please

  • From: Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>
  • To: 'Michael McMullen' <ganstadba@xxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 26 Jan 2010 10:42:44 -0800

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@xxxxxxxxxxx]
Sent: Tuesday, January 26, 2010 10:45 AM
To: Eugene Pipko; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Eugene Pipko
Sent: Tuesday, January 26, 2010 1:22 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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)

Other related posts: