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

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

Question Posted / gretta

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

Please Help Members By Posting Answers For Below Questions

Why sql query is slow?

1004

What is data type in sql?

967

Explain spool.

1186

What are the benefits of pl sql?

1122

What is sp_helptext?

1070

How can we store rows in PL/SQL using array?

1225

The select into statement is most often used to create backup copies of tables or for archiving records?

1068

What is the difference between clustered and non-clustered indexes?

1093

Can we commit inside a trigger?

998

What is field delimiter?

1048

What are different types of statements supported by sql?

1165

what is sql server agent? : Sql dba

1110

What is case function?

1043

how to use in conditions? : Sql dba

1014

What are database links used for?

1049