RE: adding a check condition

From: William Beilstein <BeilstWH_at_obg.com>
Date: Wed, 14 Jun 2000 07:33:38 -0400
Message-Id: <10528.109196@fatcity.com>

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=20

> -----Original Message-----
> From: William Beilstein [SMTP:BeilstWH_at_obg.com]=20
> Sent: Tuesday, June 13, 2000 11:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: adding a check condition

>=20
> Why not make the column NOT NULL, then they couldn't have an empty =
column.

>=20

> >>> "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.

>=20

> -
> Chris J. Guidry P.Eng.
> ATCO Electric, Metering Services
> Phone: (780) 420-4142
> Fax: (780) 420-3854
> Email: chris.guidry_at_atcoelectric.com=20

>=20


> > -----Original Message-----

> > From:	Vadim Gorbunov [SMTP:dim_at_PROTEK.RU]=20

> > Sent:	Tuesday, June 13, 2000 6:57 AM

> > To:	Multiple recipients of list ORACLE-L

> > Subject:	Re: adding a check condition

> >=20

> >=20

> >=20

> > Rachel Carmichael wrote:

> >=20

> > > 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.
> > >
> >=20
> > 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.
> >=20
> > Vadim Gorbunov
> > Oracle DBA
> >=20
> > >
> > > Rachel
> > >
> > > >From: "Anand Raman" <araman_at_india-today.com>
> > > >Reply-To: ORACLE-L_at_fatcity.com=20
> > > >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=20
> > > >
> > > >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=20
> > >
> > > --
> > > Author: Rachel Carmichael
> > > INET: carmichr_at_hotmail.com=20
> > >
> > > 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 >>=20
> --=20
> Author: Guidry, Chris
> INET: chris.guidry_at_atcoelectric.com=20

>=20


> 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).

>=20

> --=20
> Author: William Beilstein
> INET: BeilstWH_at_obg.com=20

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

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 - 06:33:38 CDT