I've done things like:
$dbh->do( q(ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY') );
through the DBI before if that's the kind of thing you're after.

I've tended to avoid SQL*PLUS in favour of the dbish whenever possible, though....