Sql*Loader

From: Johan Locke_at_i-Commerce Services <Locke_at_i-Commerce>
Date: Wed, 31 Jan 2001 03:51:16 -0800
Message-ID: <F001.002A56E3.20010131031601@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);

Any ideas.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johan Locke_at_i-Commerce Services
  INET: Johan.Locke_at_za.didata.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Wed Jan 31 2001 - 05:51:16 CST