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

"steph" <stephan0h_at_yahoo.de> a écrit dans le message de news: 2484d145-3fed-4eeb-9dbc-d4863935e82f_at_v39g2000pro.googlegroups.com... On 5 Nov., 17:19, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "steph" <stepha..._at_yahoo.de> a écrit dans le message de news: 96d5084c-f33d-474b-a225-b6989cddd..._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

Thanks! But I can only derive tables, not columns?

regards

The dependency is at object level.

Regards
Michel Received on Thu Nov 06 2008 - 10:02:17 CST