Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Varchar truncating question
> 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