Re: document tables and columns used in arbitrary sql-statements

From: joel garry <>
Date: Wed, 5 Nov 2008 11:27:55 -0800 (PST)
Message-ID: <>

On Nov 5, 2:22 am, steph <> wrote:
> hi,
> a collegue of mine came up with an interesting question: he wants to
> document all tables/columns used in sql-statements. doing this
> manuallly is cumbersome as this statements tend to be very large. i
> wonder if it is possible querying oracle's system tables to get this
> information. i just had a quick look at the V$SQL% tables but there
> was nothing obvious. any ideas?
> regards,
> stephan

As with any other usage probing, beware of things that happen outside of your tracking period. Things that happen once a year or less can be particularly gluteal-biting.

I'm happy to be able to search source code.


-- is bogus.
Those darn terrorist geeks!
Received on Wed Nov 05 2008 - 13:27:55 CST

Original text of this message