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 properties of a transaction?

1118

What is sql exception?

949

What is the difference between cluster and non-cluster index?

1092

How do you sort in sql?

990

what is foreign key? : Sql dba

1001

What is exception? What are the types of exceptions?

1060

Can we use pl sql in sql server?

1063

Explain select statements in sql?

1043

Why join is faster than subquery?

1094

Is not equal in sql?

997

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1046

What is union and union all keyword in sql?

1018

What is oracle sql called?

903

Why is pl sql used?

965

What are pl sql data types?

996