Hi there! I want to know if there is a way Oracle batch job export Excel? I want to export data to Excel the easiest possible way. Please kindly help. Thanks.
Oracle batch job export Excel as the easiest way
Â
Dear user,
Â
I have researched via Google and have found some help for you. You need to make a worksheet within the same ExcelÂ
file, it should have locked the INSERT statements. When you receive the spreadsheet, copy and paste the INSERT statements of the spreadsheets in SQL*Plus, or you may stag them in SQL script.
Â
Hope this will help you.
Thank you.
Oracle batch job export Excel as the easiest way
Hello Samantha,
You first need to make a worksheet in the same Excel file. The worksheet should have locked the INSERT statements. Then, after you receive the spreadsheet, copy and paste the INSERT statements of the spreadsheets in SQL*Plus. I think it is the easiest way to export Data to Excel.