Re: "-." in number field

From: kyle Hailey <kylelf_at_gmail.com>
Date: Fri, 24 Jul 2009 14:10:52 -0700
Message-ID: <6f373fd20907241410u53e9a5a9y26569baf3a86393d_at_mail.gmail.com>

cool - nice observation, close but no cigar, unluckily

SQL> set numformat  999999999999999999.999999

SQL> select * from toto;

                       NUM


--------------------------

                   .000000
                  -.000000

might as well go for it (despite the 18,5 format)

SQL>  set numformat 9.999999999999999999999999999999999999

SQL> /

                                    NUM


---------------------------------------

  .000000000000000000000000000000000000
 -.000000000000000000000000000000000000

SQL> select dump (num) from toto;

DUMP(NUM)

---

Typ=2 Len=1: 128
Typ=2 Len=2: 63,102

Best Wishes
Kyle Hailey
http://oraclemonitor.com

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jul 24 2009 - 16:10:52 CDT