If your table looks like colA, colB, colC,
don't unload your table by : select * but:
select colA||','||colB||','||colC ....
collado_at_my-dejanews.com a écrit dans le message
<6t0eu8$gqc$1_at_nnrp1.dejanews.com>...
>I use a simple query that I run in SQL*Plus in order to create spool files.
>I simply do a select * from myuser.mytable, but I am running into trouble
>when I uploaded with SQLLoader. The problem is that the spools I create
>fill up each column with blanks up to its defined size. Once SQLLoader
>loads them into a table, it also puts in the blanks, which Oracle
interprets
>as part of the field.For instance it gives me an invalid date error in a
>column that is empty (and not required). My question is: does anybody know
>how to get rid off all the trainling spaces in each column???I know there
>is command for that purpose in UNIX, but I am using NT.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Sep 07 1998 - 07:47:33 CDT
