RE: sql help, please

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Tue, 26 Jan 2010 13:44:37 -0500
Message-ID: <SNT130-ds17CDC31BA4B188A32D3261A65E0_at_phx.gbl>

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-l

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