Re: SQLLDR Import of Flat files. How to handle Null fields properly

From: Tony <ar_at_hotmail.com>
Date: Mon, 20 May 2002 16:57:20 +0100
Message-ID: <1021910199.9440.0.nnrp-01.d4f0f429_at_news.demon.co.uk>


Please note I have attached the data file with this email.

Script to create the table is as follows :-

CREATE TABLE TABLE_IMP_TEST ( OBJID NUMBER, ORACLE_REF VARCHAR2 (80), ACCOUNT_NAME VARCHAR2 (80), ORG_ID VARCHAR2 (80), SITE_ID NUMBER, SITE_NAME VARCHAR2 (80), SHIP_REF VARCHAR2 (80), BILL_REF VARCHAR2 (80)) TABLESPACE USERS Received on Mon May 20 2002 - 17:57:20 CEST

Original text of this message