RE: sql query help please

From: Kenneth Naim <kennethnaim_at_gmail.com>
Date: Thu, 28 Apr 2011 14:45:34 -0400
Message-ID: <015901cc05d4$75e29150$61a7b3f0$_at_gmail.com>

Look at multi table inserts. It'll work perfectly for what you need.  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Eugene Pipko
Sent: Thursday, April 28, 2011 2:42 PM
To: oracle-l_at_freelists.org
Subject: sql query help please  

Hi all,

Oracle 9i on Win2K3.

I am loading data from external file and need to convert it into different format.  

Current format:

---

DIV CUST JAN FEB MAR   New format:

---

DIV CUST JAN DIV CUST FEB DIV CUST MAR   Could you please point me to a reference from where I can learn how to do it?  

Thanks,

Eugene      

---

Checked by AVG - www.avg.com
Version: 10.0.1325 / Virus Database: 1500/3602 - Release Date: 04/28/11

---

Checked by AVG - www.avg.com
Version: 10.0.1325 / Virus Database: 1500/3602 - Release Date: 04/28/11

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 28 2011 - 13:45:34 CDT