Re: oracle database

[Quoted]    There's the AUDIT option in the database that could help you because it [Quoted] trace change to a table. Your question is not very clear for me, could you [Quoted] give an example?

  Good luck!

kushan <vikasmamta_at_my-deja.com> a écrit dans le message : 95c3uc$spv$1_at_nnrp1.deja.com...
> Hi
>
> I have a question.
> I need to insert data to a temporary table from many database tables. I
> want that temporary table should be updated when any changes in the
> database tables occurs. what should the procedure I need to follow. I
> know i can write stored procedures. but triggers can be written on one
> table. Do i need to create a view for pulling data from different
> tables & then inserting it in to temporary table by creating a update
> trigger for each row on the view.
>
>
> Any suggestions.
>
> Thanks
>
> --
> kushan
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Feb 02 2001 - 00:06:53 CET