From: Dennis <dwehlman@my-deja.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: oracle database
Date: Fri, 02 Feb 2001 11:22:22 GMT
Organization: Deja.com
Lines: 36
Message-ID: <95e59b$m3b$1@nnrp1.deja.com>
References: <95c3uc$spv$1@nnrp1.deja.com>
NNTP-Posting-Host: 62.225.151.138
X-Article-Creation-Date: Fri Feb 02 11:22:22 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)
X-Http-Proxy: 1.0 extendnet.internal:8080 (Squid/2.3.STABLE2), 1.0 x55.deja.com:80 (Squid/1.1.22) for client unknown, 62.225.151.138
X-MyDeja-Info: XMYDJUIDdwehlman


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@nnrp1.deja.com>,
  kushan <vikasmamta@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/