Oracle export Excel and Excel import Oracle

I. oracle excel Export

Method 1: the simplest method is to use the tool plsql dev

Run File => new Report Window. Write the required SQL statement into the SQL tag. Click execute or press the shortcut key F8 to obtain the query result first. On the right-side toolbar, you can select the Save button as html, copy as html, and export results. The export results button can export excel files, csv files, tsv files, and xml files.

 

 

2. Import excel file data to a table in oracle.

Method 1: the most time-saving method requires the use of plsql dev.

A. copy the data in the entire workbook to a table.