how to format query results

Thu, 19 Aug 2004 13:04:53 -0700 

Task: Set the number format to 16 decimal positions for Oracle DBI session.

Versions: Perl 5.6.1, DBI 1.42,  DBD::Oracle 1.14, Oracle 8.1.7 on Solaris.

I guess Oracle doesn't have 'ALTER SESSION' command for setting Number Format at session level.
Basically how can i set those SQLPLUS options ( ex : set numwidth 16 ) in DBI..?

Any clues..?

Thanks,
Ravi Kumar

Reply via email to