RE: adding a check condition

Not quite. Blank spaces is what he said.

-
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: Wednesday, June 14, 2000 6:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: adding a check condition
>
> True,
> but he said that they were checking to see if anything was entered, which
> not null would take care of.
>
> >>> "Guidry, Chris" <chris.guidry_at_atcoelectric.com> 06/13/00 04:20PM >>>
> 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
> > also send the HELP command for other information (like subscribing).
> --
> 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
Received on Wed Jun 14 2000 - 09:06:52 CDT