Oracle 11g - 12c Sql Loader Interview Questions and Answers Pdf - 2

Question: 6

How can you load Microsoft Excel data into Oracle?

You can save the data in text file with proper separators from Microsoft Excel.

After that, SQL * Loader can be used to load the data from any other text file.

Question: 7

Can you skip header records while loading?

You can use the SKIP parameter to skip number of records. In addition, you can use SKIP = 1 to skip the header record.