Sqlloader

  • June 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Sqlloader as PDF for free.

More details

  • Words: 127
  • Pages: 1
1)Extensions of all files? 2)Control file syntax? 3)How to issue commit issue inside of control file? 4)what are the modes or Paths we have what is the diff between those paths? 5)How to insert data into multiple tables at a time? 6)How to insert data into from multiple file at a time? 7)How to ignore a perticulre column? FILLER 8)how to mention discard file path in control file? DISCARDFILE 9)Where do we will keep Control file ? BIN 10)How to pass parameters to Control file? '&1' 11)What are the different loads we have? -insert append truncate 12)What is Trailing Nullcols? 13)How to register SQl*Loader file as Concurrent Program? 14)how to issue where clause inside of Control file? WHEN COLUMNnAME = 'ASFD' 15)What is Data and Discard files?

Related Documents

Sqlloader
June 2020 1