Thursday, August 29, 2013

Generate HTML Web Pages from SQL Query Outputs

Sometime we want to put our SQL query results on web pages. With sqlplus option "set markup html on", this can be done easily. The following query returns plain text output.
Now we turn on the html option and run the same query. The output of the select query becomes a html document.

I copy the html document into this post, change width to 40% and get the following table as you see.

ITEM NAME
Apple John
Banana John
Banana John
Apple John
Apple John
Pear John
Pear John
Peach John
Peach John
Peach John

We can turn off the option by running "set markup html off",

1 comment:

Sonia Bray said...

This kit is so perfect, especially if you’ve never tried her products before. It gives you a few goodies to try out at once! Dark Web vpn for torrenting