We help IT Professionals succeed at work.
Get Started

Batch file to load data in windows oracle

hi4ppl
hi4ppl asked
on
1,672 Views
Last Modified: 2012-11-08
Hi guys,

 I have files that are generated from server and their extension is .ul but inside the file the data is separated by "|" so I need a batch script to do the following for me:

- if the .ul is not recognized then the scrip just need to rename it to .csv or something
- pick the files and load them into the table,
- load the name of files to a separate table I have in  with their timestamp
- move the files to another folder so to avoid duplicate loads.

and yeah the database is in oracle, and the system is windows so I need a windows script a batch, already have that in linux but having issue creating the same in DOS

thanks for help
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 8 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE