From: "frank.sara" <frank.sara@infonie.fr>
Newsgroups: comp.databases.oracle.tools
Subject: Re: oracle database
Date: Fri, 2 Feb 2001 00:06:53 +0100
Organization: Infonie
Lines: 33
Message-ID: <981069471.669915@romulus.infonie.fr>
References: <95c3uc$spv$1@nnrp1.deja.com>
NNTP-Posting-Host: romulus.infonie.fr
X-Trace: vulcain.infosources.fr 981068379 6343 195.242.64.73 (1 Feb 2001 22:59:39 GMT)
X-Complaints-To: newsmaster@infosources.fr
NNTP-Posting-Date: 1 Feb 2001 22:59:39 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Cache-Post-Path: romulus.infonie.fr!unknown@195.242.66.99
X-Cache: nntpcache 2.4.0b3 (see http://www.nntpcache.org/)


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

  Good luck!


kushan <vikasmamta@my-deja.com> a écrit dans le message :
95c3uc$spv$1@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/