Re: oracle database

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_at_romulus.infonie.fr>,   "frank.sara" <frank.sara_at_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_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/
>
>

--
RICHARD


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