|
DreamCoder for Oracle Standard
DreamCoder empowers developers to be more productive by providing an intuitive graphical user interface to Oracle.
DreamCoder for Oracle is a powerful Integrated Development Environment for Oracle Databases. Using the intuitive
DreamCoder's GUI will increase your code quality and reduce the development process time.
DreamCoder for Oracle easily enables you 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, enable user session monitoring and database
monitoring among other features.
DreamCoder for Oracle offers powerful visual tools to increase your productivity such as a SQL editor, procedure builder,
master detail table browser, parameter manager, code inspector, describe objects, SQL Formatter, SQL Plus Console, Lov
Viewer, object extractor, database reports and more.
Software Information |
System Requirements |
Version: |
1.9 |
- Windows 9X, NT4, 2000, 2003 and XP, Vista
- supported Oracle Server versions are 8i, 9i and 10g on any platform
- To connect to an Oracle database, DreamCoder only requires a 32-bit SQL*Net or Net 8 or Net 9 version to debugger.
|
File Size: |
Full version: 13.00 MB |
License: | Free to try, $150.00 to buy |
Screenshot: | View Screenshot
|
Rating : | |
The DreamCoder for Oracle Standard Main Features:
- 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
- Fully customizable program interface.
The 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.
RELATED SOFTWARE DOWNLOADS FOR DREAMCODER FOR ORACLE STANDARD
|
|