RE: SQL*LOADER - Trailing spaces

From: Jain, Akshay <Akshay.Jain_at_cit.com>
Date: Wed, 14 Jun 2000 11:45:01 -0400
Message-Id: <10528.109251@fatcity.com>

I say that if this field is a code, then it should be more strictly enforced as to length, and containing spaces. Perhaps if you can use a CHAR datatype, then the problem becomes moot.

Anyway, you can strip the blank with an RTRIM in your control file, on the fly.

Akshay Jain

---

Newcourt-CIT
Tel. (416) 507-5385
mailto:Akshay.Jain_at_cit.com

---

-----Original Message-----
From: Weerd de E.C. Kirsten [mailto:Kirsten.deWeerd_at_Oranjewoud.nl] Sent: Wednesday, June 14, 2000 9:35 AM
To: Multiple recipients of list ORACLE-L Subject: SQL*LOADER - Trailing spaces

Hi,

Question

We have several ASCII-files in some standard format that we need to upload. So we user a control-file in SQL*LOADER. Easy!

There is one field wich has a length of two (VARCHAR2) but is mostly only one position. Shouldn't the trailing space be left out ?

What I now get is a field 'A ' thus length(field) = 2 where I would want and expect 1 ...

Any ideas and/or hints ??

Oracle 7.2.3
HP-UX 10.20

Greets,

Kirsten
Netherlands, Europe

-- 
Author: Weerd de E.C. Kirsten
  INET: Kirsten.deWeerd_at_Oranjewoud.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Jun 14 2000 - 10:45:01 CDT