[% USE oracleDB = DBI("dbi:Oracle:xe", "LP", "lpdba") %]
[% 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") %] [% USE Dumper %] [% FOREACH res IN query.execute() %][% Dumper.dump(res) %][% END %]