Re: Trigger to convert null->' ' - performance hit?

SFidai (sfidai_at_aol.com) wrote:
: If I write a trigger for each table that contain VARCHAR2(n) columns,
: to convert '' or null values before insert/update to ' ' resulting in
: spaces. Say we have 400 tables and around 1500 such columns. Can
: anyone estimate performance hit due presence of this triggers? (very
: little, little, moderate impect, high impect)

I don't understand why you would do this, but it might be much easier to set the DEFAULT value of a column to ' ', so it will be set to a space when no value (i.e. NULL) is passed. You do this in a CREATE TABLE or ALTER TABLE statement.

Sandor Nieuwenhuijs
Oracle Netherlands Received on Sat Jun 11 1994 - 16:50:39 CEST