Message-Id: <10527.109033@fatcity.com> From: "Guidry, Chris" Date: Tue, 13 Jun 2000 12:46:45 -0600 Subject: RE: adding a check condition A blank is not the same as null. - Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: chris.guidry@atcoelectric.com > -----Original Message----- > From: William Beilstein [SMTP:BeilstWH@obg.com] > Sent: Tuesday, June 13, 2000 11:49 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: adding a check condition > > Why not make the column NOT NULL, then they couldn't have an empty column. > > >>> "Guidry, Chris" 06/13/00 12:27PM >>> > Hello, > Without getting into the database vs application constraint enforcment > debate, > this may be one situation better handled by the application. Just a > thought. > > - > Chris J. Guidry P.Eng. > ATCO Electric, Metering Services > Phone: (780) 420-4142 > Fax: (780) 420-3854 > Email: chris.guidry@atcoelectric.com > > > -----Original Message----- > > From: Vadim Gorbunov [SMTP:dim@PROTEK.RU] > > Sent: Tuesday, June 13, 2000 6:57 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: adding a check condition > > > > > > > > Rachel Carmichael wrote: > > > > > yes it adds to the overhead! and it will affect performance on every > > insert > > > and update. Oracle has to get the check condition from the data > > dictionary. > > > > > > since you want this check on EVERY column, it might be faster to do it > > all > > > at once in a before-insert/before-update trigger. > > > > > > > Hi, all > > I think, trigger is slower and more expensive than check constraint(s) > > because > > of PL/SQL engine is not as much efficient as Oracle core functions. One > > table > > level check constraint would be the most effective solution. > > > > Vadim Gorbunov > > Oracle DBA > > > > > > > > Rachel > > > > > > >From: "Anand Raman" > > > >Reply-To: ORACLE-L@fatcity.com > > > >To: Multiple recipients of list ORACLE-L > > > >Subject: adding a check condition > > > >Date: Mon, 12 Jun 2000 22:57:04 -0800 > > > > > > > >Hi guys > > > >In a database which i am desiging to prevent users from entering > blank > > > >spaces into columns i am also > > > >adding a check condition like check column <> ' ' to almost every > > column.. > > > >Does this add to the overhead of the table and will it have any > > performance > > > >effect .. > > > >Thanx > > > >Anand > > > > > > > >-- > > > >Author: Anand Raman > > > > INET: araman@india-today.com > > > > > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > >San Diego, California -- Public Internet access / Mailing > Lists > > > >-------------------------------------------------------------------- > > > >To REMOVE yourself from this mailing list, send an E-Mail message > > > >to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > > > >the message BODY, include a line containing: UNSUB ORACLE-L > > > >(or the name of mailing list you want to be removed from). You may > > > >also send the HELP command for other information (like subscribing). > > > > > > > ________________________________________________________________________ > > > Get Your Private, Free E-mail from MSN Hotmail at > http://www.hotmail.com > > > > > > -- > > > Author: Rachel Carmichael > > > INET: carmichr@hotmail.com > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California -- Public Internet access / Mailing Lists > > > -------------------------------------------------------------------- > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > << > > File: Card for Vadim Gorbunov >> > -- > Author: Guidry, Chris > INET: chris.guidry@atcoelectric.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Author: William Beilstein > INET: BeilstWH@obg.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may