All this is documented in the CPAN entry for DBD::Oracle, in the other data types section. And as a side note, you might consider getting in the habit of using placeholders and bind values to avoid unpleasant surprises.