question

OracleApprender avatar image
OracleApprender asked

How does one load multi-line records?

How can we load multiple lines of data into a record ? Please let me know if anyone have some idea on this. Thank you in advance.

oracleplsqldata-processing
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
OraLearner avatar image
OraLearner answered

One can create one logical record from multiple physical records using one of the following two clauses:

. CONCATENATE: - use when SQL*Loader should combine the same number of physical records together to form one logical record.

. CONTINUEIF - use if a condition indicates that multiple records should be treated as one. Eg. by having a '#' character in column 1.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.