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 |
What is full join in sql?
What are triggers in sql?
what is the difference between to_char and to_date functions?
Can we use out parameter in function?
I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT
How do I pipe the output of one isql to another?
What is the difference between alter trigger and drop trigger statements?
what is inline view?
What are user defined stored procedures ?
Name the operator which is used in the query for pattern matching?
what are the advantages and disadvantages of views in a database? : Sql dba
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
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)