Skip to Main Content

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!

Using UTL_FILE create dat file

selvi mMay 17 2022 — edited May 17 2022

Hi Team,
I need urgent help for read input csv file to convert Dat file with proper format..
can you please help me
Input file : lower.csv
loc: AD/LP/log
8888,22222,4/2/2022,5/17/2022,5,5,MAC
8888,222228,4/2/2022,5/17/2022,5,5,MACH
8888,2222289,4/2/2022,5/17/2022,5,5,MACHE
OUTPUT: real.dat
loc: AD/LP/load
08888,0000022222,20220402,20220517,5,5,MAC
08888,0000222228,20220402,20220517,5,5,MACH
08888,0002222289,20220402,20220517,5,5,MACHE

Thanks

This post has been answered by BluShadow on May 18 2022
Jump to Answer
Comments
Post Details
Added on May 17 2022
4 comments
652 views