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

[% Dumper.dump(query.execute()) %]