Re: reg : SQL LOADER
From: Marlaine Handler <handler_at_merck.com>
Date: 1996/06/25
Message-ID: <4qp9n2$hro_at_merck.com>#1/1
Date: 1996/06/25
Message-ID: <4qp9n2$hro_at_merck.com>#1/1
You can use the POSITION parameter described in the Utility/SQL*loader User's Guide. Example extracted from manual:
LOAD DATA
INFILE 'emp.dat'
INTO TABLE emp
(EMPNO POSITION(01:04) INTEGER EXTERNAL, ENAME POSITION(06:15) CHAR, DEPTNO POSITION(50:51) INTEGER EXTERNAL) The contents of this message express only the sender's opinion. This message does not necessarily reflect the policy or views of my employer, Merck & Co., Inc. All responsibility for the statements made in this Usenet posting resides solely and completely with the sender.Received on Tue Jun 25 1996 - 00:00:00 CEST