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 |
How do you delete a table?
What does “select count(*) from tab” result?
15 Answers IBM, Student, Wipro,
What are the types of sql commands?
how to create a table index in mysql? : Sql dba
What jobs use sql?
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
explain the advantages and disadvantages of stored procedure? : Sql dba
How can we find duplicate records in a table?
What is an exception in PL/SQL? What are the two types of exceptions?
difference between pl/sql table and normal pl/sql table
How do I filter in sql profiler?
What are user defined stored procedures ?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)