URGENT:SQLLDR, concatenating 2 columns
From: <pmohanan_at_my-deja.com>
Date: 2000/07/18
Message-ID: <8l2j9r$dh1$1_at_nnrp1.deja.com>#1/1
Date: 2000/07/18
Message-ID: <8l2j9r$dh1$1_at_nnrp1.deja.com>#1/1
[Quoted] Hi....Oracle Gurus,
I am having a problem while loading records into oracle. One of the column is a text field in sybase. when i downloaded the data it puts "\n" or newline between the 2 rows i.e the row looks like this
dskfjdskf|3242432|ksdjfksdfj|Hi Please help me|324324234234
Now, my problem is that the stmt "Hi Please help me" is one line with delimiter "|". All the rows doesn't have this problem. The data is variable length. How do i tell the SQLLDR to scan the current column till it reaches "|" in case it doesn't get the data for all fields.
TIA, Praveen
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Jul 18 2000 - 00:00:00 CEST