Re: How to declare Number(20) ?

From: TurkBear <johng_at_mm.com>
Date: 2000/05/31
Message-ID: <393550de.16167938@news.news-ituk.to>#1/1

In 8.1.5 there is no problem...
what errors are you getting?
My experience:

---

Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.5 - Production With the Partitioning option
PL/SQL Release 8.1.5.0.5 - Production

SQL> Create table test_numbersize(
  2 num1 number(20,2),
  3 num2 number(35));

Table created.

SQL> desc test_numbersize

 Name                            Null?    Type
 ------------------------------- -------- ----
 NUM1                                     NUMBER(20,2)
 NUM2                                     NUMBER(35)

SQL>

---

Post more details, please...
John Greco
Oracle DBA

Krusty <danparker276_at_my-deja.com> wrote:

>number (20) won't go that high. How do I declare a number column in a
>database that's 20 digits? Sorry if this is a stupid question, I'm
>sorta new to this and couldn't find it in a book.
>
>Thanks
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Wed May 31 2000 - 00:00:00 CDT