Re: reg : SQL LOADER

From: Marlaine Handler <handler_at_merck.com>
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

Original text of this message