Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NUMBER Datatype

Re: NUMBER Datatype

From: Nandakumar <N.Kumar_at_rocketmail.com>
Date: Tue, 16 Nov 1999 15:46:09 GMT
Message-ID: <80ru7v$3r1$1@nnrp1.deja.com>


Whether it is a number ( with or without fractional part), or a varchar2 , ( or any datatype, for that matter), unless a default value is explicitly set ( using DDL), the DEFAULT VALUE is NULL.

regards
Nanda

In article <80r3cq$g5f$1_at_nnrp1.deja.com>,   www_dba_at_my-deja.com wrote:
> Hi,
>
> When creating tables, if precision is not specified to a NUMBER
column.
> What will be the default value?
>
> Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Nandakumar

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 16 1999 - 09:46:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US