Re: Computed column?

Tomm Carr wrote:
>
> CREATE OR REPLACE TRIGGER c_compute
> before INSERT OR UPDATE OF A, B ON Test
> FOR EACH ROW
> Begin
> :new.C = Power(( :new.A + :new.B), 2 )
> End;

Oops. Make that:

    :new.C := Power(( :new.A + :new.B), 2 )

        ^-- forgot the colon

-- 
Tomm Carr
--
"Can you describe your assailant?"
"No problem, Officer.  That's exactly what I was doing when he hit me!"