• Generation of DDL files for Tables, Types, Functions, Sequences, Packages, Procedures, Views and Java Source from the Oracle Database. One or many objects can be extracted at once from one or many Oracle Schemas. Once a DDL is generated it can then be opened programmatically in your favorite editor. WinDDL also has a built in ability to drill down and search both schemas and objects by name for the object you are looking for.
• Generate table record install scripts inside a generated DDL. This option is available from the setup tab for generating Table DDLs. Future versions will allow for the building of dynamic WHERE clauses and the ability to choose specific columns to add generating a table record install script.
• Generation of an install script for all objects generated. This is activated by checking off the "Build Install Script with DDL" checkbox on the "Gen DDL" tab. After selecting the objects you want to build and pressing the "Build Selected Object(s)" button an additional window will appear setting up to build a SQL file to install the DDLs you just generated. The grid that appears on this form is click and drag sortable and allows you to choose the order of install for the objects you have generated (the default sort is alpha by name).
• Generation of PL/Doc HTML documentation for the following objects: Tables, Views and Packages. Future releases will include all objects that a DDL can be generated for.
• Browse DDL Scripts in WinDDL using a searchable schema/object browser and tab control viewing window. Future versions will add color highlighted key words to the viewing window and may also allow a programmer to edit a DDL directly in the viewing window.
• Browse PL/Docs for Objects using a searchable schema /object browser and a tab controlled HTML viewing window. Currently this is a little buggy but future versions will improve upon this.

Download	Win DDL (Version 2.0.0 compiled on 1/9/2006): Updated with a whole list of new tools LATEST VERSION!!! Win DDL (Version 1.9.3 compiled on 10/24/2005): Built in PLDoc for Packages as well as triggers, views and tables. Win DDL (Version 1.9.2 compiled on 10/14/2005): Includes a PLDOC on Table/View Triggers as well as the table/view. Constraints and Indexes were also added in this release. Win DDL (Version 1.9.1 compiled on 10/13/2005): Converting PLDoc functionality to WinDDL executable. Currently works for tables and views only, all other objects still call SourceForge PlDoc Java App. Win DDL (Version 1.8.2 compiled on 12/8/2004): Based on certain a lack of grants to DBMS_JAVA calls like SELECT dbms_java.shortname('F_FUNCTION') FROM dual would cause a EOF loss of communication error. Win DDL (Version 1.8.1 compiled on 12/6/2004): Includes support for PlDoc Win DDL (Version 1.7.2 compiled on 9/9/2004): Standard DDLs using DBMS_METADATA You must comment your triggers in the following manner for the PLDoc to pick them up...
Grants Needed	The following grants are needed to run WinDDL for a user: GRANT SELECT ON SYS.ALL_OBJECTS TO > GRANT SELECT ON SYS.ALL_USERS TO > GRANT SELECT ON SYS.ALL_SYNONYMS TO > GRANT SELECT ON SYS.ALL_CONSTRAINTS TO > GRANT SELECT ON SYS.ALL_SOURCE TO > GRANT SELECT ON SYS.ALL_ARGUMENTS TO > GRANT SELECT ON SYS.ALL_TAB_COLUMNS TO > GRANT SELECT ON SYS.ALL_COMMENTS TO > GRANT SELECT ON SYS.ALL_TAB_COMMENTS TO > GRANT SELECT ON SYS.ALL_SOURCE TO > GRANT SELECT_CATALOG_ROLE TO > GRANT EXECUTE ON SYS.DBMS_JAVA TO > GRANT EXECUTE ON SYS.DBMS_METADATA TO > DBMS_METADATA and Security The object views of the Oracle metadata model implement security as follows: Nonprivileged users can see the metadata of only their own objects. SYS and users with SELECT_CATALOG_ROLE can see all objects. Nonprivileged users can also retrieve object and system privileges granted to them or by them to others. This also includes privileges granted to PUBLIC. If callers request objects they are not privileged to retrieve, no exception is raised; the object is simply not retrieved. If nonprivileged users are granted some form of access to an object in someone else's schema, they will be able to retrieve the grant specification through the Metadata API, but not the object's actual metadata.
Bug Fixes	Version 2.0.0 Addtions and fixes Installation Script Generator Added PLDoc Generator and PLDoc Browser Added DDL Browser Added Version 1.8.2 Includes a fix if certain grants are lacking for the SYS.DBMS_JAVA. These missing grants would cause a call to DBMS_JAVA.SHORTNAME or DBMS_JAVA.LONGNAME to knock you out of Oracle when called. Version 1.8.1 now supports building documentation on Packages, Views and Tables using PlDoc Open source tool.

If you find any bugs or want to contact me I can be reached @ doughjoe77@hotmail.com.