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: SQL Loader with EBCDIC File

Re: SQL Loader with EBCDIC File

From: <tedchyn_at_yahoo.com>
Date: Sat, 12 Jun 1999 16:50:57 GMT
Message-ID: <7ju35e$d81$1@nnrp1.deja.com>


In article <7jth9u$pjl$1_at_bgtnsc03.worldnet.att.net>,   "Juan Carlos" <jc_va_at_hotmail.com> wrote:
> Thanks for the responses to my personal e-mail. The EBCDIC file I am
> dealing with is extremely large. What I want to do read it and
convert it
> with SQL Loader. Is there any way to do that?
>
>

juan, you can incorporate oracle function - decode,translate,nvl etc in your control file to convert ebdic data before loading.

Ted

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jun 12 1999 - 11:50:57 CDT

Original text of this message

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