From: kushan <vikasmamta@my-deja.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: oracle database
Date: Fri, 02 Feb 2001 14:10:02 GMT
Organization: Deja.com
Lines: 56
Message-ID: <95ef3k$th3$1@nnrp1.deja.com>
References: <95c3uc$spv$1@nnrp1.deja.com> <981069471.669915@romulus.infonie.fr>
NNTP-Posting-Host: 208.170.104.71
X-Article-Creation-Date: Fri Feb 02 14:10:02 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.0 US-ICORP-PROXY2, 1.0 x53.deja.com:80 (Squid/1.1.22) for client 208.170.104.71
X-MyDeja-Info: XMYDJUIDvikasmamta


Ok I need to create  a temporary table from 30 or more different
tables. I want that temporary table to use in Crystal report. This
table should be updated to pull the data from database before running
the report.
Can you tell me more detail about audit option.

Thanks


In article <981069471.669915@romulus.infonie.fr>,
  "frank.sara" <frank.sara@infonie.fr> wrote:
>    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/
>
>

--
RICHARD


Sent via Deja.com
http://www.deja.com/