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

What is a merge query?

1 Answers  

What is scope and visibility in PL/SQL?

0 Answers  

What operators deal with null?

0 Answers  

write a query to find 4th max salary

7 Answers  

What is Difference Between Unique and Primary Key Constraints?

0 Answers   Wipro,




what is a view? : Sql dba

0 Answers  

Can you call pl/sql package functions from within a fast formula?

0 Answers  

What is graph sql?

0 Answers  

What does rownum mean in sql?

0 Answers  

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

0 Answers  

How do I trace sql profiler?

0 Answers  

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,

For more SQL PLSQL Interview Questions Click Here
Categories