Doru Ilasi wrote:

> ...
> -- run this as SYSDBA in a new database
> set autoddl on;
> create table test(f1 varchar(1),f2 varchar(1));
> create view test_vw(f1,f2) as select f1,f2 from test;
>
> set term ^; create trigger test_vw_bu for test_vw active before update
> as begin
> update test set f2 = new.f1;
> end^ set term ;^

Is it correct to use: "update test set f2 = new.f1;" ?

Will "update test set new.f2 = new.f1;" work ?

> ...

--
Aage J.