Home -> Usenet -> comp.databases.oracle -> Re: SQLLDR: Mapping 1value in .dat file to 2 Columns in Table - LONG

Re: SQLLDR: Mapping 1value in .dat file to 2 Columns in Table - LONG

From: Jürgen Meurisch <juergen.meurisch_at_t-online.de>
Date: 30 Oct 2002 07:29:55 -0800
Message-ID: <2ebfa77d.0210300729.2fe55887_at_posting.google.com> 







rajah_james_at_yahoo.com (Rajah James) wrote in message news:<86114a1a.0210291424.5e118499_at_posting.google.com>...



Hello James,



try this at the end of the ctl-file



dEndOffset DECIMAL EXTERNAL,


sOperationNumber CHAR(:SOperationUniqueIdentifier)
)



or 



dEndOffset DECIMAL EXTERNAL,


sOperationNumber CHAR "concat(:SOperationUniqueIdentifier,'')")



I think this works


Jürgen
Received on Wed Oct 30 2002 - 16:29:55 CET












Original text of this message