while loading data into database how can u skip header and
footer records in sql*loader

Answer Posted / gretta

The WHEN clause with POSITION can be used to skip header and footer records.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a trigger? : Sql dba

568


Can we change the table name in sql?

525


What is offset and limit in sql?

543


How do I view an execution plan in sql?

519


Is it possible to create the following trigger: before or after update trigger for each row?

714






What is ttitle and btitle?

568


What are some predefined exceptions in pl/sql?

543


What is the difference between functions, procedures, and packages in pl/sql?

479


Is sql better than excel?

512


What is normalization in sql?

518


How many triggers can be applied on a table?

498


What are the triggers associated with image items?

612


Can you upgrade sql express to full sql?

506


How many databases can sql express handle?

524


What are the possible values for the boolean data field?

510