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

Home -> Community -> Usenet -> c.d.o.server -> Re: Varchar truncating question

Re: Varchar truncating question

From: Steffen Göck <stevie-g_at_gmx.de>
Date: Wed, 30 Aug 2000 21:38:40 +0200
Message-ID: <8ojnok$qgg$12$1@news.t-online.com>

> The trigger should work, although it'll slow down update/insert
> transactions on the database.

I think the loss of time is in the range of nanoseconds. you won´t see any real difference.

> If you're doing custom development,
> developers should have enough discipline to use a SUBSTR in their own
> code.

you still have illusions? :-)

in my mind, as much as possible constraints and rules should be placed in the database. it is much more secure.

all the more security in the database, you will have less bad suprises when your system goes in production.

excuse my bad english
Steffen Received on Wed Aug 30 2000 - 14:38:40 CDT

Original text of this message

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