Re: NUMBER vs NUMBER (n)

krislioe_at_gmail.com wrote:
> Hi all,
>
> I have some basic oracle question :
>
> 1) When do we use NUMBER and NUMBER (n) ?
>
> 2) For surrogate key, is it better to use INTEGER, or NUMBER or NUMBER
> (n) ? why ?
>
> Thank you,
> xtanto

CREATE TABLE t (
col1 NUMBER,
col2 NUMBER(10),
col3 INTEGER);

INSERT INTO t VALUES (100,100,100);
COMMIT; desc t

SELECT dump(col1), dump(col2), dump(col3) FROM t;

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group