On Tue, 28 Sep 2004 18:39:08 GMT, Kenneth Koenraadt wrote:
>On Tue, 28 Sep 2004 17:08:34 +0200, Latyr_Dev
><Latyr_dev-remove.this-_at_hotmail.com> wrote:
>
>>Hi
>>
>>I have noticed something somehow strange.
>>The following SQL has been run against an Oracle8i & Oracle9i database
>>CREATE TABLE Team (
>> Portfolio_ID NUMBER ( 10 ) NOT NULL,
>> Project_ID NUMBER ( 10 ) NOT NULL,
>> Member_ID NUMBER ( 10 ) NOT NULL,
>> Role VARCHAR2 ( 3 ) NOT NULL,
>> R_ART NUMBER ( 1 ) DEFAULT 0,
>> R_GED NUMBER ( 1 ) DEFAULT 0,
>> R_LVS NUMBER ( 1 ) DEFAULT 0
>> )
>>/
>>
>>With Oracle8i, if no value is given during insert R_ART=R_GED=R_LVS=0
>>But with Oracle9i, I don't have any value in R_ART; R_GED; R_LVS
>>
>>Why ???
>>
>>Did I miss something ?
>>
>>Thanks in advance
>
>
>Cannot confirm your observation. Please post the exact INSERT
>statement(s).
>
>- Kenneth Koenraadt
>
And the SELECT statements that indicate that the columns have 'no
values' (Null??)
Received on Wed Sep 29 2004 - 07:35:41 CDT
