Oracle batch job export Excel as the easiest way

Asked By Samantha Elijahh 10 points N/A Posted on - 02/06/2013

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.

• Status: Open
• Question Views: 780
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by Henriy William

Go To Solution

Best Answer

Best Answer

Answered By Henriy William 0 points N/A #149575

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.

About Henriy William

Questions
3

Answers
101

Best Answers
14

• Vote Up 0 Vote Down

• Posted on - 02/25/2013
• Question Category: Oracle Database

Answered By Manning Wickersham 0 points N/A #149576

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.

About Manning Wickersham

Questions
1

Answers
33

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 05/21/2013
• Question Category: Oracle Database