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 different sql languages?

1091

How do you update sql?

1036

how can we repair a mysql table? : Sql dba

1040

how to calculate the difference between two dates? : Sql dba

1112

What is benefit of creating memory optimized table?

1032

What is trigger and stored procedure in sql?

1092

How do sql triggers work?

1090

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1271

How does sql*loader handles newline characters in a record? : aql loader

1089

What do you mean by dbms? What are its different types?

1062

Name the operator which is used in the query for pattern matching?

1004

Explain scalar functions in sql?

1104

What is the basic structure of an sql?

1155

How many subqueries can be nested in a statement?

1039

define data blocks ? : Sql dba

1045