Re: substituting a space for a NULL

Roy Brokvam wrote
> IF :new.mycolumn IS NULL THEN
> :new.mycolumn := ' ';
> END IF;
Or:

    :new.mycolumn := nvl(:new.mycolumn, ' ');

>However, you are violating the idea of a not null constraint.

Very true!

Arjan. Received on Fri Mar 05 1999 - 11:35:32 CST