Sql Loder

From: San Sridharan <san_oracle_dba_at_yahoo.com>
Date: Wed, 26 Oct 2005 16:33:48 -0700 (PDT)
Message-ID: <20051026233348.56472.qmail@web36307.mail.mud.yahoo.com>

I have a flatfile in the following format,  

Row1col1,Row1col2,Row1col3,Row2col1,Row2col2,Row2col3,Row3Col1, Row3Col2,Row3col3  

(There is no line breaks between the different rows of data in the flatfile.)
 

I need to load the above data into a table with the following structure,  

Create table Temp_load
(

col1 varchar2(10),
col2 varchar2(10),
col3 varchar2(10)

);  

Can someone tell me how to load this data using SQLLOADER.  

Thanks,
San

David Sharples <davidsharples_at_gmail.com> wrote: I had the same problem, askTom to the rescuse need to create a function which returns an interval  

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:388480262167#49098749303720  

On 10/26/05, t_adolph_at_hotmail.com <t_adolph_at_hotmail.com> wrote: Hi all,

I'm trying to setup snapshots to run every 15 minutes during working hours, else hourly. I'm ignoring weekends for now,...                   

---

 Yahoo! FareChase - Search multiple travel sites in one click.

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

Received on Wed Oct 26 2005 - 18:35:59 CDT