creating an HTML file with SQL*Plus

Here is an example of creating an HTML file with SQL*Plus:

1. Create a script, call it runhtml.sql, with the following code:

set ver off
set term off
set markup html on spool on

spool <drive>:\ex1.html

select * from table_name;
select * from table_name;

spool off

2. Execute this script using:

SQL> @runhtml.sql

3. Open the output file ex1.html, which, in our example, it is saved on the C:\ drive.

4. Now you can import this ex1.html in Excel 2000. You do not need to create a csv file anymore. You can also use an html file.