sqlldr- combine and insert two values - position(1:10) and position(20:30) into one column
Posted on 2012-04-03
i have to load a text file into oracle table using sqlldr.
I want to load characters from position(1:10) and position(20:30) into one column into my oracle table
I donot want to load characters from 10-20 since they are some invalid charactesr(like carriage returns etc) and it messes up my dataload of characters from position-20:30)
How can i do that using sqlldr
options( SKIP = 0 )
infile 'myfile.txt' "str '\n'"
but that failed, I also tried using || concatenator but it did not work