Re: Help with a command

On Nov 18, 3:53 pm, nujcha..._at_googlemail.com wrote:
> On 18 Nov, 20:42, "shakespeare" <what..._at_xs4all.nl> wrote:
>
>
>
> > <nujcha..._at_googlemail.com> schreef in berichtnews:9c8fc657-2124-45fc-b755-6e0ce32e3ed8_at_d50g2000hsf.googlegroups.com...
>
> > >I have this web based application which hosted on a oracle database.
> > > Being an old legacy system, I have no documentation about this
> > > application / database e.g data dictionary etc...
> > > My approach is that I want to add a new value via the web application
> > > and look to see where the entered value appear in which table on the
> > > database.
> > > Obviously in reality I will need to view all tables hoping to find the
> > > value I enter and it could take a life time to do this.
> > > Is there any command I can use to acheive this? Say a command that I
> > > can use that give me a list of tables with most updated?
>
> > > Many thanks
>
> > If you have TOAD you can monitor the executed statements
>
> > Shakespeare
>
> Hi
> I should have mentioned that I dont know much about Oracle at all.
> What is TOAD? I think I have SQL Plus installed on my computer and
> thats about it.
> Please advice

My advice would be to get some training or bring in a contractor. (preferably both)
All the Oracle manuals are available on their web site, so self training is possible.

Ed Received on Sun Nov 18 2007 - 20:19:49 CST