my $dbh = ... connect ...;
$dbh->do("alter session set NLS_TIMESTAMP_FORMAT = 'RRRR-MM-DD HH24:MI:SS'");
... etc ...