Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Newbie-Question: Loader generates NULLs

Newbie-Question: Loader generates NULLs

From: Dieter Ratsch <extern.dieter.ratsch_at_volkswagen.de>
Date: Thu, 09 Dec 1999 15:16:20 +0100
Message-ID: <384FB9B4.4D0AF6EB@welfen-netz.de>


Hi,

I've tried out a lot of possible solutions - without success: I want to load Data of a sequential File by SQLLDR into a ORacle 8.0.5-table.

When a Field in the loaded File is blank/Space and the target-Column in the
table is i.e. a VARCHAR2-Field, it results in a NULL-Value. I want to get the original content of the loaded File: Spaces, not NULL! Can anyone give me a hint, how to do that??

By the way:
The HTML-Help-Pages of ORA 8.0.5 contents Synthax-Diagramms in such a small
size, that - in my opinion - no human programmer can read those small GIF's.
Or should I need a special glass???

Thanks in advance
Dieter Received on Thu Dec 09 1999 - 08:16:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US