Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Sqlldr help
I have file format like below.. it's only big line..
fields are seperated by '/' and '\' means end of a
record.
What is the best way to load this file using sqlldr.
929827081384/QMSL/965821846858#216.10.166.52/1/7775/7775/0/0/0/1077.524999995716/USD/965827868940/100/3/F/300////0/1B- -RN-26584356\963404816559/MNKN/965827167 777#172.153.170.192/1/850/0/0/0/0/1558.14999999708/USD/965827869212/25/1/F/25/7/11-13-5-10-30-29-39/$$/0/1-30-9-21-36-19-22-25-7-33-28-0\961264536939/CLSL/9658 7770775#63.76.159.204/1/22180/22180/0/0/0/1898.1949999965402/USD/965827869328/5/
![]() |
![]() |