Hrmm, kinda open ended question.

Start with the documentation that ships with DBI. From there check out the ORA book (Programming the Perl DBI, ISBN 0596005865). Between those two you'll be mostly set.

As for modules, check out things such as Class::DBI and DBIx::Recordset (and I'm sure there's others that people are going to chime in with their favourites).