|
Can anybody explain to me how to skip certain columns of rows/records while loading data ? Thank you in advance.
(comments are locked)
|
|
One cannot use POSTION(x:y) with delimited data. Luckily, from Oracle 8i one can specify FILLER columns. FILLER columns are used to skip columns/fields in the load file, ignoring fields that one does not want. Look at this example: -- One cannot use POSTION(x:y) as it is stream data, there are no positional fields-the next field begins after some delimiter, not in column X. --> LOAD DATA TRUNCATE INTO TABLE T1 FIELDS TERMINATED BY ',' ( field1, field2 FILLER, field3 )
(comments are locked)
|
Your answer
How are you loading data? Are those columns NULLable? If so, just omit that column in your load, whether that be INSERT or SQL*Loader.
We are loading the data from a file to a database. Columns may have data or NULL.
What is your load mechanism though? Running insert statements, using SQL*Loader, IMPORT, DataPump, 3rd party tool like Toad, what?
Direct Load mechanism. Running Insert statement is conventional mechanism.