On Fri, Aug 20, 2004 at 10:34:07AM -0600, Reidy, Ron wrote: > I looked in NLS*PARAMETERS (NLS_DATABASE, NLS_INSTANCE, and NLS_SESSION) in the data > dictionary and saw nothing. That is why I suggested using type_info().
Found it: NLS_NUMERIC_CHARACTERS e.g. http://www.cise.ufl.edu/help/database/oracle-docs/server.920/a96529/ch3.htm#50693 Tim. > ----------------- > Ron Reidy > Senior DBA > Array BioPharma, Inc. > > > -----Original Message----- > From: Tim Bunce [mailto:[EMAIL PROTECTED] > Sent: Friday, August 20, 2004 10:34 AM > To: Ravi Kongara > Cc: DBI-Users > Subject: Re: how to format query results > > > On Thu, Aug 19, 2004 at 01:04:36PM -0700, Ravi Kongara wrote: > > 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. > > I'm sure there's an NLS setting for this you can alter for the session. > But I can't remember the name or find it in the quick ref guide I have handy. > Read the Oracle docs. > > Tim. > > This electronic message transmission is a PRIVATE communication which contains > information which may be confidential or privileged. The information is intended > to be for the use of the individual or entity named above. If you are not the > intended recipient, please be aware that any disclosure, copying, distribution > or use of the contents of this information is prohibited. Please notify the > sender of the delivery error by replying to this message, or notify us by > telephone (877-633-2436, ext. 0), and then delete it from your system. > >