SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlldr - can you skip last row from a data file

483336Jan 19 2006 — edited Jan 23 2006

Hi
I need to skip last line from the data file when I load the data into the tables. Is that possible to do using sqlldr, if yes How?

Also, the first row in the data file, which has a single column needs to be loaded into all the rows of the table. How can i do that?

Example

020051213
1088110 0047245 A 000000000000GB 00000496546700
1088110 0719210 A 000000000000GB 00001643982200
1088110 0727871 A 000000000000GB 00000083008900
9010163

The first line needs to go into all the rows, and the last row needs to be skipped. Remaining can be loaded normally. I think this would take multiple loads. Can anybody please help.

TIA

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2006

Added on Jan 19 2006

12 comments

1,893 views