Related blog post has been drafted for menu drawer & hierarchical list template

Two column portlet

First two columns in the query are listed down the page. 
select  dname, loc, deptno
from dept

  • ACCOUNTING
    NEW YORK
  • RESEARCH
    DALLAS
  • SALES
    CHICAGO
  • OPERATIONS
    BOSTON

Value attribute pairs

Great for single row label:value lists, a bit like the old SQL*Plus script @print "select * from dept"
  • Dept# 10
  • Name ACCOUNTING
  • Location NEW YORK