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

What are the basic sql commands?

1036

What sql does db2 use?

923

How to test for null values?

978

Explain character-manipulation functions?

1066

what are the properties and different types of sub-queries? : Sql dba

966

What is sql query optimization?

1018

Describe sql comments?

959

what is an alias command? : Sql dba

1006

What is a constraint?

959

What is normalization sql?

994

How do you use collections in procedure to return the resultset?

2179

Why do we use function in pl sql?

1005

What are the two types of exceptions in pl/sql?

962

what is union, minus and interact commands? : Sql dba

1115

explain the difference between myisam static and myisam dynamic. : Sql dba

880