This discussion is archived
1 Reply Latest reply: Mar 11, 2013 2:51 PM by rp0428 RSS

Upload FIle Contians 3 Different Types of Data Columns

996070 Newbie
Currently Being Moderated
Hi All

I Got a scnario like a upload file contains
1.Header(Contains the File Name,Branch Name,MIS date)
2.Body(Customer Details)
3.Footer (File Name,Contians Total Number of Records and Number of Customers)

Like

CustomerDet_11-12-2013.csv,Chennai,11-12-2013

101,AAA,Savings,'M',10000
102,BBB,Current,'O',2000
103,CCC,Deposit Acct,'F',3000

CustomerDet_11-12-2013.csv,3,15000


How to handle this scnario through UTL_File .PLs help me to proceed.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points