Re: "-." in number field

SQL> set numformat .
SQL> select num from toto;
Press {ENTER} To Continue ..

NOS
___
 -.

1 row selected.

SQL> set numformat 999999.99999
SQL> /
Press {ENTER} To Continue ..

          NOS

      -.00001

1 row selected.

Jay

• Original Message ----- From: kyle Hailey To: ORACLE-L Sent: Friday, July 24, 2009 2:29 PM Subject: "-." in number field

  anyone every see this or know how it could happen:

  SQL> select * from toto;

         NUM

           0


          -.

          -.

          -.

          -.

          -.

           0

  7 rows selected.

  SQL> desc toto;

   Name                                      Null?    Type
   ----------------------------------------- -------- --------------
   NUM                                                NUMBER(18,5)

  Thanks
  Kyle
  http://oraclemonitor.com

--
http://www.freelists.org/webpage/oracle-l