[% USE oracleDB = DBI("dbi:Oracle:dbname", "username", "password") %] [% query = oracleDB.prepare(" SELECT u.name, u.adress, u.idontknow FROM user u, anothertable t, athirdtable d WHERE u.id = t.user AND t.id = d.something ORDER BY u.name DESC") %] [% FOREACH user = query.execute( ) %]

col1	col2	col3
[% user.u.name %]	[% user.u.adress%]	[% user.u.idontknow %]