1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / ramesh


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

Answer / gretta

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

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Can we enter data in a table in design view?

0 Answers  

Why truncate is faster than delete?

0 Answers  

Which one is better sql or oracle?

0 Answers  

Is sql an operating system?

0 Answers  

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,




What is the difference between join and natural join?

0 Answers  

Is sql similar to python?

0 Answers  

how to analyze tables with 'mysqlcheck'? : Sql dba

0 Answers  

What is memory optimized?

0 Answers  

What are the datatypes a available in PL/SQL ?

2 Answers  

How many clustered indexes can you have?

0 Answers  

What is Raise_application_error ?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories