Right, but this defines group separators for thousands, millions, etc., and decimal characters. I am under the impression the OP wants to set the precision/scale of numeric columns.
----------------- Ron Reidy Senior DBA Array BioPharma, Inc. -----Original Message----- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Friday, August 20, 2004 11:40 AM To: Reidy, Ron Cc: Tim Bunce; Ravi Kongara; DBI-Users Subject: Re: how to format query results 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. > > 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.