Re: oracle database

Kushan,

write update triggers for every of your "many" tables. The triggers insert needed data into your "temporary" table.

Dennis

In article <95c3uc$spv$1_at_nnrp1.deja.com>,   kushan <vikasmamta_at_my-deja.com> wrote:
> 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/
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Feb 02 2001 - 12:22:22 CET