At 10:21 PM 29/11/2011, ibmcom2011 wrote:

>Helen,
>
>I created a view as you said.

No, you didn't.

>CREATE OR ALTER VIEW V_T_BALANCE(
> F_ACD_ID,
> NUM1,
> NUM2,
> BALANCE)
>AS
>select F_ACD_ID, NUM1, NUM2, BALANCE from FIN_ACC_CASH_DIARY
>where 1 = 1
>with check option
>;

I said:

>>But for the view for the purpose described, you should leave it unfiltered and apply a WHERE clause to it when you access it in the table trigger.

You don't want CHECK OPTION.

./H