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 |
Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.
What is the difference between nested table and varray?
What are the properties of a transaction?
What is a column in a table?
What is a temporal data type?
How many commands are there in sql?
How to place comments in pl/sql?
What is a database trigger?
Explain lock escalation? : Transact sql
How does an execution block start and end in pl sql?
Explain commit, rollback and savepoint.
What is character functions?
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)