[% 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 %]