Import txt files with fixed width
hi,
I have to do a procedure to import data from text files.
The fields have fixed width and are not delimited with "; " character or similar.
I can not use sql like this:
LOAD DATA INFILE '/ tmp / test.txt' INTO TABLE test FIELDS TERMINATED BY ';'
Thanks a lot
Subject
Views
Written By
Posted
Import txt files with fixed width
3466
June 27, 2014 06:46AM
1916
June 27, 2014 07:41AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.