Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 14821 invoked from network); 5 Dec 2007 13:27:03 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 5 Dec 2007 13:27:03 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9C30B7D180D; Wed, 5 Dec 2007 14:27:03 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18920-01; Wed, 5 Dec 2007 14:27:03 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 138A47D13ED; Wed, 5 Dec 2007 14:27:03 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 Dec 2007 13:40:06 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C3AB77D1D8C for ; Wed, 5 Dec 2007 13:40:06 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09860-08 for ; Wed, 5 Dec 2007 13:40:06 -0500 (EST) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.248]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7FC337D1E17 for ; Wed, 5 Dec 2007 13:39:59 -0500 (EST) Received: by an-out-0708.google.com with SMTP id b36so1967564ana for ; Wed, 05 Dec 2007 10:39:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=RPcsXo1DbNrW+WuQQhtpIEDPBNC1I0JpSyOX1j4dBgg=; b=URO4X7mqF1ZlwIciWX7ETwwU5/kZ9hI8pv3k1DCOfoj3JX/gEwHBZv+O4DAVz2uxDNAHSOFwlKVllWFGA38aCHTbMUbKL/bF3ZAHCi/xZNGL64zUVBpVZqjbbV+XFDibdYIb3xBSjMo3rKUfOj6CPE/AlogSfluU8FWmGVAY7y4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:mime-version:content-type; b=EvMYnB5mRReXCxf9sV8z07fPv0EfSD9Vc0Dk1uT4oCNay8lyNgXb42NEKjp6cFzXIM78Od3qoFNZ3TfNuCtggaXlqJjPpgQnJr8ZDDU981Z+koBENF51Ri0nJG5YWOPSxvA4XzWlQRZb/IBgAwSWwoWOdyYPxCTCKpm4FNDF02k= Received: by 10.142.110.3 with SMTP id i3mr1172707wfc.1196879993525; Wed, 05 Dec 2007 10:39:53 -0800 (PST) Received: by 10.70.67.8 with HTTP; Wed, 5 Dec 2007 10:39:48 -0800 (PST) Message-ID: <8e7ca0a00712051039j6edd40adl2e435c70ec44b9ad@mail.gmail.com> Date: Wed, 5 Dec 2007 13:39:48 -0500 From: "James Parkhurst" To: oracle-l@freelists.org Subject: NUMBER format question MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2106_15012340.1196879988457" X-archive-position: 3723 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: jfpark137@gmail.com Precedence: normal Reply-to: jfpark137@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_2106_15012340.1196879988457 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I have two tables on two different DB's, within two different servers. Both tables have the same structure and both DB's are of the same version ( 9.2.0.4). The column in question is of datatype NUMBER, w/o scale or precision. If I log on to Server1, connect to DB1, and query the table's column, the results are returned in SQL*Plus with the decimal portion of the value intact. If I log onto Server2, connect to DB2, and query the table's column, the results are returned in SQL*Plus w/o the decimal portion of the value. If I log onto Server1, start SQL*Plus, then connect to DB2 remotely and query the data, the results are returned in SQL*Plus w/o the decimal portion of the value. The session settings are identical via the SHOW ALL, and I've verified that the decimals are present on DB2 using a to_char and setting NUMFORMAT. Anyone have any ideas why? James ------=_Part_2106_15012340.1196879988457 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I have two tables on two different DB's, within two different servers. Both tables have the same structure and both DB's are of the same version (9.2.0.4). The column in question is of datatype NUMBER, w/o scale or precision.

If I log on to Server1, connect to DB1, and query the table's column, the results are returned in SQL*Plus with the decimal portion of the value intact.

If I log onto Server2, connect to DB2, and query the table's column, the results are returned in SQL*Plus w/o the decimal portion of the value.

If I log onto Server1, start SQL*Plus, then connect to DB2 remotely and query the data, the results are returned in SQL*Plus w/o the decimal portion of the value.

The session settings are identical via the SHOW ALL, and I've verified that the decimals are present on DB2 using a to_char and setting NUMFORMAT.

Anyone have any ideas why?

James
------=_Part_2106_15012340.1196879988457-- -- http://www.freelists.org/webpage/oracle-l