Export data to excel

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.

email

Leave a Reply