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

Home -> Community -> Usenet -> c.d.o.server -> Re: Importing TAB-delimited data

Re: Importing TAB-delimited data

From: Erwin Dondorp <erwindon_at_wxs.nl>
Date: Wed, 15 Dec 1999 20:48:29 +0100
Message-ID: <3857F08D.5F1FDF57@wxs.nl> 







NetComrade wrote:


> Any advice on how I can import TAB delimited file into Oracle?


> I cannot use DELIMITED BY WHITESPACE b/c





Use something like DELIMITED BY CHR(9)


[You need a tab after the last column as well unless you specify
"TRAILING NULLS"!]


Erwin


-- 


Erwin Dondorp


<http://www.dondorp.com/>
Received on Wed Dec 15 1999 - 13:48:29 CST












Original text of this message













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