Re: force inclusion of certain fields in update (trigger?)

> How about:
>
> SELECT user INTO :NEW.USERNAME FROM DUAL;

Yeah, this works. In my case, however, all developers connect to the database using the same user. So it is in their own responsibility to set the column "username" to an individual mnemonic to identify themselves. That's the problem.

But I'm considering creating a seperate user for each developer right now, then your suggestion would be certainly implemented ;)

Thanx,
Alex Received on Thu Feb 21 2002 - 07:08:06 CST