Oracle batch job export Excel as the easiest way

Asked By 10 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Henriy William
Best Answer
Best Answer
Answered By 0 points N/A #149575

Oracle batch job export Excel as the easiest way

qa-featured

 

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.
Answered By 0 points N/A #149576

Oracle batch job export Excel as the easiest way

qa-featured

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.

Login/Register to Answer

Related Questions