Non-table ddl

[Vinny]

PL/SQL Developer does a great job of creating the DDL scripts for creating (and modifying) tables. Is there a way to extend this feature to non-table objects too?

What I am looking for are permission tabs on all object types and some others, such as key constraints on views (I know this sounds strange, but if a view has a PK defined, then java mapping utilities out there use it effectively, since they require that a PK be defined). Does this functionality exist? If not can it be added?

Thanks,
Vince

 

[Vinny]

Is it even possible to see such constraints on a view? ALTER VIEW pack_cont ADD CONSTRAINT pack_cont_pk PRIMARY KEY (pack_cont_id) DIABLE NOVALIDATE. I cannot find this information even under the view's node in the browser.

 

[Marco Kalter]

This is currently not possible, but it is on the list of enhancement requests.

 

[rbrooker]

use dbms_metadata.get_ddl, that will produce ddl for any object visible to the logged in schema.