Re: Need Help w/ Number Datatype

Sign is not part of the precision.

It takes you less time to execute this example than us to answer your question:

v734>create table t (col number(3));

Table created.

v734>insert into t values (-387);

1 row created.

v734>select * from t;

       COL

      -387

1 row selected.

Use but not misuse our time.

Chris Durward a écrit dans le message ...
>I have a quick question. In the data type "number" if I declare it
>Number(3) is it possible to have the following number:
>
>-387
>
>What I'm wondering is, does the negative sign take up a digit in that data?
>
>Thanks for your help
>
>
Received on Tue Sep 21 1999 - 04:38:59 CDT