view DDL

[Fabio]

Someone Know how can i extract DDL of an object, for exemple, a view with the columns name and with grant objects.

Thanks

 

[Marco Kalter]

For a view you can query the all_views view. The grants have to be queried from the all_tab_privs view. I don't have a complete example though.

------------------
Marco Kalter
Allround Automations