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



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

Answer / 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

More SQL PLSQL Interview Questions

How to check if a column is nullable before setting to nullable?

0 Answers  


Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,


i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,


How do I know if I have sql express or standard?

0 Answers  


What is the difference between numeric and autonumber?

0 Answers  






how to load data files into tables with 'mysqlimport'? : Sql dba

0 Answers  


what is innodb? : Sql dba

0 Answers  


What is a temporal table?

0 Answers  


Explain what is table in a database?

0 Answers  


How to connect a sql*plus session to an oracle server?

0 Answers  


Does db2 use sql?

0 Answers  


what is the difference between ereg_replace() and eregi_replace()? : Sql dba

0 Answers  


Categories