Re: NEED HELP ON SQL LOADER

From: miguel <jmiguel_at_cet.pt>
Date: 1997/10/22
Message-ID: <01bcded3$7bd5b4c0$0a0a2c0a@jmiguel.cet.pt>#1/1

FIREWALL <ubsram_at_pacific.net.sg> wrote in article <344cc1ff.3358308_at_news.pacific.net.sg>...
> Dear Friends,
>
> I need help on SQL Loader. How do I load ASCII files from UNIX to
> Oracle Database 7 using SQL Loader.
>
> Please help me with the syntax.

% SQLLDR username/password,
´....../test.ctl´,´....../test.log',´.....test.bad',' ...../test.txt´

Where test.txt is the file to be load,like: lisboa,10
porto,20

and test.ctl:

load data
into table test
( a char terminated by ",",
b integer external terminated by ",")

Miguel
Portugal

>
> In addition, how do I schedule a job to be run on a weekly basis in
> UNIX AIX ??
>
>
> Please e-mail
>
> ubsram_at_pacific.net.sg
>
>
> Thank you
>
Received on Wed Oct 22 1997 - 00:00:00 CDT