SQL*Loader load '"' ?
From: WANG SHIANG HUEY <wshiang_at_a.cs.okstate.edu>
Date: 1996/12/12
Message-ID: <58ps6p$11h_at_news.cis.okstate.edu>#1/1
Date: 1996/12/12
Message-ID: <58ps6p$11h_at_news.cis.okstate.edu>#1/1
Anyone knows how to use SQL*Loader to load a '"' ?
Control file
LOAD DATA
INFILE "xxxx.DAT"
APPEND INTO TABLE xxxx
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
( text1 char(10),
text2 char(10));
Data
"xxx" xxx", "122343b"
"xxx"xxx", "122343b"
-- Shiang-Huey Wang Leather Center, Inc. sherry_at_leathercenter.com wshiang_at_a.cs.okstate.eduReceived on Thu Dec 12 1996 - 00:00:00 CET