Export data to excel

Notice: get_currentuserinfo is deprecated since version 4.5.0! Use wp_get_current_user() instead. in /home/dbascrip/public_html/wp-includes/functions.php on line 3828

Cyrille Modiano

OCP Oracle DBA in Montreal at DBSoft

who never needed to export data to excel from sqlplus ? everybody had one day needed to do that.
Sqlplus support the HTML markup which provides an excellent result once opened in excel.
With the HTML markup, sqlplus create a table with all columns from your query including the name of your columns as table header.
Here is a small exemple:

my output file has already the xls extension, I just have to open it, here is how it looks like:

export data to excel

from there it is easy to generate a chart for example:

host utilization percent

Thanks for reading.

Leave a Reply