Blog Archive for February 26, 2010

SQL Plus Producing HTML

February 26, 2010

I had a need to mock up some HTML from a database table for droplists to support a JavaScript training course I was writing. I did this using Oracle sql*plus and spooling an output file.

SQL> spool options.sql
SQL> select '<option value="' || make_serial || '">' || make_description || '</option>' …