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 is nosql example?

1026

What is the use of function in sql?

1082

How do you go back in sql?

983

Mention what is the function that is used to transfer a pl/sql table log to a database table?

976

Can we connect to postgresql using sql developer?

993

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

1215

How do rank () and dense_rank () differ?

1041

What are different types of tables in sql?

990

What does varchar include?

942

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1193

How is data stored in sql?

1048

What is the difference between having and a where in sql?

1094

What can I use instead of union in sql?

958

Is sql low level language?

1011

How to get list of all tables from a database?

1148