Re: HELP how to load ascii-data to oracle???

From: John Strange <jstrange_at_imtn.dsccc.com>
Date: 1995/11/11
Message-ID: <4830c6$ch5_at_tpd.dsccc.com>#1/1

Use the SQL LOADER. The following is a control file with your # as a field terminator and optionally you can have an unprintable character.
Here the X'1F' is a Unit Separator I use for enclosing text strings which can have just about anything.

• srlexp.ctl -------------- load data infile * insert into table srlexp_prb fields terminated by '#' optionally enclosed by X'1F' (FIXED_ITEM_NUM, CREATION_DATE date "YYMMDD", CREATED_BY, LAST_UPDATE_DATE date "YYMMDD", LAST_UPDATED_BY, CR_NUM, APC_NUM, ARA_NUM, APPLICATION_NAME, ITEM_NAME_NUM, DISPOSITION_NUM, FI_CREATE_DATE date "YYMMDD", COMMAND_CODE, REFERENCE_NUM, ITEM_VERSION, SRL_ACCEPTANCE_DATE date "YYMMDD", FM_APPROVAL_DATE date "YYMMDD", FI_STATUS_FLAG, SRL_MGR, MGRBY) begindata 1#900309#0#900309#0#3901#1#1#SRL#6417#1#900309#NULL#102317#1019#900309#900309##0#JANDERSO#

Konstantinos Agouros (elwood_at_rumba.m.isar.de) wrote:
:> Hi,
 

:> we have Oracle WG2000 running on a Solaris Intel platform. I need a quick
:> way to get some tables filled with data that's provided in lists with field-
:> separators like #. What I saw from the loader looked like I can only fill
:> if I say this field is so many characters wide. Is this right?
 

:> Konstantin
:> --
:> Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood_at_rumba.m.isar.de
:> Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 6914268
:> ----------------------------------------------------------------------------
:> "Treason, like beauty, lies in the eye of the beholder." Garak

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.

Received on Sat Nov 11 1995 - 00:00:00 CET