Monday, 10 November 2014

Important Interview Question for Sql* Loader


This is one of the interview question which I faced regarding the sql*loader concept.

If  you are loading the data into table using sql*loader, Discarded records should not cross more than 10 while loading. How?


We are having an option in the sql*loader DISCARDMAX

It holds the integer value and if you pass DISCARDMAX=10, it will stop loading the data into table if the discarded records exceeds more than 10.

No comments:

Post a Comment

Uploading PO Attachments from EBS to FTP Server

 create or replace PROCEDURE xx_upload_po_attachment(errbuff out varchar2, retcode out number)  IS CURSOR cur_new_attmt IS    select ponumbe...