Re: SQL*Loader problem
From: Stephane Chiche <Stephane_at_Chiche.com>
Date: 1996/09/16
Message-ID: <323DE5D8.1148_at_Chiche.com>#1/1
Date: 1996/09/16
Message-ID: <323DE5D8.1148_at_Chiche.com>#1/1
You are not saying if you are loading a Fixed Width or delimited file.
If it's fixed width
Let's say that you have now a line loooking something like:
......
YOUR_FIELD POSITION (68:71),
........
replace it with:
YOUR_FIELD POSITION (68:71) ":YOUR_FIELD/10", (note: use double quotes!)
Voila! Received on Mon Sep 16 1996 - 00:00:00 CEST