How to run a job daily in Oracle and Generate excel file
-
Hi, Can any one tell me how to run a job in oracle which take all the data from one table(for ex: name,address,lastlogintime,etc) and generate output in excel format and save in one common folder everyday. If you have a sample code, could you share it please, it would be helpfull in understanding the concept better.
-
Hi, Can any one tell me how to run a job in oracle which take all the data from one table(for ex: name,address,lastlogintime,etc) and generate output in excel format and save in one common folder everyday. If you have a sample code, could you share it please, it would be helpfull in understanding the concept better.
What part of the concept is troubling you? Write a console-app that executes a query on your Oracle-database. There's quite some examples on the internet that show you how to achieve that part. Next, iterate through the results, and write them out to a file. Excel will accept almost everything, from CSV to XML. We got some nice articles on CP that explain how to write to Excel in various ways. Not much to concept there. If you have the first part of the assignment, we'll talk about writing those results to Excel.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
-
Hi, Can any one tell me how to run a job in oracle which take all the data from one table(for ex: name,address,lastlogintime,etc) and generate output in excel format and save in one common folder everyday. If you have a sample code, could you share it please, it would be helpfull in understanding the concept better.