Sql Loder
- From: San Sridharan <san_oracle_dba@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 26 Oct 2005 16:33:48 -0700 (PDT)
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@xxxxxxxxx> 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@xxxxxxxxxxx <t_adolph@xxxxxxxxxxx> 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.
Other related posts:
