Answer the question
In order to leave comments, you need to log in
How to load only the second row [Oracle, SqlLoader, CTL]?
There is a file with arbitrary content for an indefinite number of lines. (in one column).
You need to load the date from it. She is currently in the second line.
OPTIONS (SKIP=1,ROWS=1) - doesn't help for some reason.
Those. it is meant that I pass 1 line and I load only 1 line.
Alternatively, can the APPEND WHEN condition check whether the date is currently being loaded?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question