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=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.co=
m=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
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 - 11:41:47 CDT
