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

How do we use distinct statement? What is its use?

745


How do you explain an index number?

742


What is sqlite format?

807


Is a view faster than a stored procedure?

711


What is sql analyzer?

753






How do I view a procedure in sql?

721


What is the difference between join and natural join?

649


How would you convert date into julian date format?

786


What is the use of & in pl sql?

716


What are joins in sql?

715


How do I view tables in sql developer?

676


Which command is used to delete a trigger?

946


What is percent sign in sql?

920


Can a procedure in a package be overloaded?

746


What are the different set operators available in sql?

751