K
K
KTG2019-04-04 20:03:24
Oracle
KTG, 2019-04-04 20:03:24

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 question

Ask a Question

731 491 924 answers to any question