...
| No Format | ||
|---|---|---|
| ||
dbvrep> FILTER OFFLINE TABLE scott.emp ON PRE-UPDATE SET TO case when deptno in (select deptno from scott.dept where loc='NEW YORK') then 3000 when deptno in (select deptno from scott.dept where loc='DALLAS') then 2000 else 1500 end < sal or months_between(sysdate, hiredate) > 436 or scott.my_plsql_function(ename) = 1 |
| Note |
|---|
User defined function scott.my_plsql_function must be called using the schema name. User dbvrep must be granted an execute privilege on this function. |
...