This disclaimer is intended to cover all software/freeware, and other various files which are downloadable through or from this site. |
Joe Garrepy, isp, and web host can not be held responsible for any software downloaded from this site. All freeware is downloaded at your own risk. Software which is listed on this site is assumed to work properly, but may or may not have different effects on different computer systems. The same rules apply to these programs.
Joe Garrepy assumes no responsibility for those unusual occurrences where software has adverse effects on users computer. Joe Garrepy does not warrant these programs/files, and as such, can offer no guidelines in which to use them.
All freeware/software/files, trademarks, service marks, and copyrights are acknowledged as belonging to their owners. Any of these which the owner wishes to be removed will be done so immediately.
By downloading any software or viewing pages in which software can be downloaded, you agree to be bound to this agreement.
JoeGarrepy.com Oracle Tools and Widgets Win DDL
WinDDL is a tool for writing, documenting and researching database objects for Oracle 9.2 and above.
WinDDL primary purpose is for the generation of object DDLs using the SYS.DBMS_METADATA package
ensuring that the most "proper" DDL possible is generated. This also insures that as Oracle is updated
new objects and new ways of writing objects will be preserved in the SYS.DBMS_METADATA package. WinDDL
uses the .NET Framework 2.0 and MDAC 2.6.
WinDDL has the following capabilities:
Follow this link to the WinDDL Users Guide
- 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.
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.
- 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 are not running Windows XP or need to download the .NET Framework 2.0 you can
do so by following the directions on this link
If you get the error pertaining to you needing MDAC 2.6 or higher you may upgrade to MDAC 2.6
by following this link