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 I find duplicates in sql?
What is keys and its types?
What is query syntax?
write sub query for eliminating duplicate rows using analytical function?
How can we make an if statement within a select statement?
What is the difference between DELETE and TRUNCATE?
15 Answers Johns Hopkins University, Tech Mahindra,
What is sap sql?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is an ndf file?
what is the functionality of the function htmlentities? : Sql dba
how to fetch common records from two tables? : Sql dba
How do I view a table in sql?
Oracle (3259)
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)