Sql*Loader

From: Johan Locke_at_i-Commerce Services <Locke_at_i-Commerce>
Date: Wed, 31 Jan 2001 13:15:59 +0200
Message-Id: <10758.127879@fatcity.com>

Hi

I've got the following entries in a sql*Loader import file

---

2000-02-25JOHN   0608
2000-02-28PETE   0718
---------------------

123456789012345678901

Char 1 to 9 and 18 to 21 make up the date and time, ie '2000-02-25 06:08'
('RRRR-MM-DD HH24:MI')
I need to import this information into a table with two columns, "USERNAME"
(1st) & "BIRTHDATE" (2nd), but I'm struggeling using Sql*Loader to
concatenate the two fieds.

create table USER_BIRTHDATES
(USERNAME varchar2(20),

 BDATE date); Received on Wed Jan 31 2001 - 05:15:59 CST