Mentat Technologies
DreamCoder for Oracle - Description

DreamCoder for Oracle
DreamCoder for Oracle is a powerful Integrated Development Environment (IDE) 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.

Feature matrix comparison



Principal 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
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

System requirements
DreamCoder will run on Windows 95, 98, NT4, 2000, 2003 and XP. The 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.

Trial version
You can download a fully functional 30-day trial version to try out DreamCoder yourself. If after 30 days you can't imagine how you’ve ever been able to work without DreamCoder, you can visit our ordering page for ordering details and price information.


Data Synchronization
Data Synchronization

Synchronize data among different
databases quickly.

Zoom Video

Structure Synchronization
Structure Synchronization

Synchronize the structure of your
databases in few steps.

Zoom Video



Mentat Technologies products are designed to work individually or as part of a suite of solutions. You only need to license the tools that you plan to you use.

XML:
Alchemist XML IDE

MySQL manager and code generator:
DreamCoder for MySQL
Alchemist XML IDE

Oracle development, monitoring, code generator:
DreamCoder for Oracle
DreamCoder for PostgreSQL
Alchemist XML IDE

Product Screenshots


Workspace
Workspace

Whole environment for Oracle PL/SQL development.

Zoom

Import Table
Import Table

Powerful module for importing data from various sources including MS Excel, MS Access, DBF, XML, TXT and CSV.

Zoom

Debugger
Debugger

Powerful debugger for Oracle PL/SQL.

Zoom

Session Monitor
Session Monitor

Powerful session monitor tool.

Zoom


SQL Editor

SQL Editor

Powerful SQL editor with autocomplete and Highliter features.

Zoom Video

Advanced Query Builder
Advanced Query Builder

Now build SQL's with the most
advanced query builder.

Zoom Video


SQL and PL/SQL Code Formatter
SQL and PL/SQL Code Formatter

Format your SQL and PL/SQL code using the included code formatter.

Zoom Video


Storage Monitor
Storage Monitor

Powerful Storage Monitor tool.

Zoom Video

 


Copyright © 2004 Mentat Technologies, All Rights Reserved
Privacy Policy | Terms of Use