SQL*LOADER newline problem
From: sslee <sslee_at_210.124.31.1>
Date: Fri, 31 Jul 1998 18:16:41 +0900
Message-ID: <35C18B79.45E59110_at_210.124.31.1>
For example.
Date: Fri, 31 Jul 1998 18:16:41 +0900
Message-ID: <35C18B79.45E59110_at_210.124.31.1>
For example.
LOAD DATA
INFILE *
INTO TABLE DEPT
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(DEPTNO, DNAME, LOC)
BEGINDATA
12,RESEARCH,"SARA <-- Column including newlineTOGA"
10,"ACCOUNTING",CLEVELAND 11,"ART",SALEM 13,FINANCE,"BOSTON" 21,"SALES",PHILA. 22,"SALES",ROCHESTER 42,"INT'L","SAN FRAN"
I must insert rows which have columns including newlines. How to insert newline in SQL*LOADER?
help me!!! :) Received on Fri Jul 31 1998 - 11:16:41 CEST