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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: adding a check condition

RE: adding a check condition

From: Guidry, Chris <chris.guidry_at_atcoelectric.com>
Date: Tue, 13 Jun 2000 12:46:45 -0600
Message-Id: <10527.109033@fatcity.com>


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_at_atcoelectric.com

> -----Original Message-----
> From: William Beilstein [SMTP:BeilstWH_at_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" <chris.guidry_at_atcoelectric.com> 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_at_atcoelectric.com
>
> > -----Original Message-----
> > From: Vadim Gorbunov [SMTP:dim_at_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" <araman_at_india-today.com>
> > > >Reply-To: ORACLE-L_at_fatcity.com
> > > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > >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_at_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_at_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_at_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_at_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_at_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_at_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_at_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_at_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
Received on Tue Jun 13 2000 - 13:46:45 CDT

Original text of this message

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