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

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 5 Nov 2008 17:19:49 +0100
Message-ID: <4911c7a7$0$29900$426a74cc@news.free.fr>

"steph" <stephan0h_at_yahoo.de> a écrit dans le message de news: 96d5084c-f33d-474b-a225-b6989cdddfe3_at_i18g2000prf.googlegroups.com...
| 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

V$OBJECT_DEPENDENCY Regards
Michel Received on Wed Nov 05 2008 - 10:19:49 CST

Original text of this message