SQL Loader questions

From: Bob Pierce <bpierce_at_cablehealth.com>
Date: 1996/11/26
Message-ID: <329B8790.1F0C_at_cablehealth.com>#1/1


I've been using SQL*Loader to quickly load data from ascii files. I've figured out most things, but there are two things I still can't get it to do:

  1. Can you skip over a field in comma-separated data without loading it into a table? I've been creating dummy fields in my tables to load fields I don't need because I can't get it to skip over anything.
  2. Is there any way to load a date field as a date type with a format specifier if the input date has a comma in it? The data files I'm loading have the date and time as separate comma-separated fields (like yyyymmdd, hh:mi). The loader pukes if I try to put a comma in the date format specifier. I have worked around this by loading the date by itself into a date-type field, loading the time into a character field, then converting and combining the two in an insert trigger! This works, but leaves me with a character time field in the table that I don't need.

Thanks,

BoB Pierce

-- 
He that buys land buys many stones,
He that buys flesh buys many bones,
He that buys eggs buys many shells,
He that buys good ale buys nothing else.
Received on Tue Nov 26 1996 - 00:00:00 CET

Original text of this message