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>' from makes ...snip output... SQL> spool off
This will create a file in the current directory called options.sql which will contain one line for each row from the table, in the correct format to be placed into the HTML. (after a little trimming in a text editor).
