Re: Trigger to convert null->' ' - performance hit?
From: Sandor Nieuwenhuijs <snieuwen_at_nl.oracle.com>
Date: Tue, 14 Jun 1994 20:26:23 GMT
Message-ID: <CrEM3z.CLx_at_nl.oracle.com>
Date: Tue, 14 Jun 1994 20:26:23 GMT
Message-ID: <CrEM3z.CLx_at_nl.oracle.com>
SFidai (sfidai_at_aol.com) wrote:
: In article <Cr8MKF.EEL_at_nl.oracle.com>, snieuwen_at_nl.oracle.com (Sandor
: Nieuwenhuijs) writes:
: That is not correct. Default values take into effect when you do not
: specify those columns in the insert statements. If you list columns
: in insert stmt and have null value, that record will contain null
: value. Also, a problem you have with update statements.
I suppose you're right, allthough I do not see any point in specifying NULL on insert statements, when you might as well not specify the column as well. Might save some network traffic.
: Fidai.
Sandor Received on Tue Jun 14 1994 - 22:26:23 CEST