This software utility is a powerful tool for Oracle PL/SQL development
DreamCoder for Oracle is a strong IDE application (Integrated Development Environment) for Oracle Databases. With the intuitive DreamCoder's GUI increase your code quality and reduce the development process time.
DreamCoder for Oracle you will easily be able to build and execute queries, build and execute scripts, compile and debug SQL and PL/SQL code, create and modify database objects, import and export data, user session monitor and database monitor among others.
DreamCoder for Oracle offers powerful visual tools for increase your productivity like SQL editor, procedure builder, master detail table browser, parameter manager, code inspector, describe objects, SQL Formatter, Data Synchronization , Structure Synchronization SQL Plus Console, Lov Viewer, object extractor,database reports among others features.
Here are some key features of "DreamCoder for Oracle Enterprise Edition":
· Powerful PL/SQL Editor
· Procedure Builder
· Master detail Table browser
· Parameter Manager
· Value List for foreign keys
· Code Inspector
· Procedure Evaluator
· Synonym Manager
· Describe all objects (F4)
· SQL and PL/SQL Code Formatter(Only Enterprise Edition)
· Database system monitor (Only Professional Edition)
· SQL Plus Console
· Lov Viewer
· CLOB support
· Database Session monitor
· SQL Window
· Administration of project
· Object Browser
· Non-PL/SQL Objects
· Template List
· Compare User Objects
· Export User Objects
· Advanced Query Builder
·
Describe Object
· Object Finder
· Filter of Objects
· Recycle bin (10g)
· Object extractor
· SQL History
· Database reports
· Object compiler assistant
· Support partition tables and partition indexes
· DML code generator
· Integrated Debugger (requires Oracle 7.3.4 or later)
· Direct connection without SQL*Net.
· Account Password Encryption.
· MDI Interface - Microsoft Office Style
· Workgroup development
· Dockable environment
· Easy installation
DBA
· Create/View/Drop /Edit Users
· Create/View/Drop /Edit Roles
· Create/View/Drop /Edit Profiles
· Create/View/Drop /Edit Resource Group
· Create/View/Drop /Edit Tablespaces
· Create/View/Drop /Edit Rollback Segments
· Create/View/Drop /Edit Redo Log Groups
· Storage Monitor
· SGA Monitor
Synchronization
· Database Data Synchronization
· Database Structure Synchronization
Easy management of all Oracle objects
· Create/View/Drop /Editing tables
· View/Drop /Drop key, unique, trigger, Indexes and synonyms of the tables
· Create/View/Drop/Edit Packages
· Create/View/Drop/Edit Procedures
· Create/View/Drop/Edit Functions
· Create/View/Drop/Edit Triggers
· Create/View/Drop/Edit Jobs
· Create/View/Drop/Edit Java Objects
· Create/View/Drop/Edit Object types
· View/Drop Clusters
· Create/View/Drop/Edit Synonyms
· Create/View/Drop/Edit Index
· Create/View/Drop/Edit Sequences
· View/Drop Dimensions
· Create/View/Drop/Edit Links (database)
· Create/View/Drop SnapShots
· View/Drop Queue Tables
· View/Drop Refresh Group
View/Drop Security and Storage
· View/Drop Users
· View/Drop Roles
· View/Drop Profiles
· View Datafiles
· View Tablespaces
· View Rollback Segments
· View Redo Log Groups
Data Grid Manipulation
· Advanced grid options enable you to copy and paste records from MS Excel , delete selected recods, perform column customization, execute many export options and perform customization.
· Data Grouping
· Data Filtering
· Automatic Sorting
· Filter Builder
· Record count
· Create Summary Data Groups (Sum,Min,Max,Count,Average)
PL/SQL processing
· Multiple PL/SQL and SQL Editors
· Script Executing (PL/SQL Script Editor)
· SQL Monitor
· Powerful Print Metadata Module for creating customizable metadata reports
· Extracting metadata INTO text files or SQL Script editor
Powerful data manipulation tools
· Export data in to 14 popular formats like MS Access, MS Excel, MS Word , HTML,XML,TXT, PDF.
· Import data from in 7 popular formats like MS Excel, MS Access, DBF, XML, TXT and CSV.
· Export data to SQL script as INSERT statement.
· Fully customizable program interface
· Program options: windows, fonts, grid colors, etc.
· Editors: custom colors, fonts etc.
· Toolbars for all program windows
· Powerful Visual Options Module
· Possibility of saving all the program settings
· Localizable program interface
Down:
http://rapidshare.com/files/126950408/DreMCodROracL3025_Ent_lipripr.rar
Pass:
thephoenix-forums
