document tables and columns used in arbitrary sql-statements

From: steph <>
Date: Wed, 5 Nov 2008 02:22:28 -0800 (PST)
Message-ID: <>


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?

stephan Received on Wed Nov 05 2008 - 04:22:28 CST

Original text of this message