Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Sqlldr help

Sqlldr help

From: Ashish Shah <ar_shah_at_yahoo.com>
Date: Fri, 22 Sep 2000 08:26:10 -0700 (PDT)
Message-Id: <10627.117667@fatcity.com>


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/



Ashish
Toronto, Canada

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/ Received on Fri Sep 22 2000 - 10:26:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US