OraDeveloper Studio - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

OraDeveloper Studio by Devart (formerly Core Lab)

URLs: core-lab-oradeveloper-studio, core lab oradeveloper studio, corelaboradeveloperstudio, devart

Explore and maintain Oracle databases and simplify Oracle database development. OraDeveloper Studio is a tool designed to automate and simplify the Oracle database development process. OraDeveloper Studio also provides an easier way to explore and maintain existing databases, design compound SQL statements, query and manipulate data in different ways.

Using OraDeveloper Studio you can:

Create, modify and delete database connections

Display server specific database schema information in tree view

Create, modify and drop various database objects

Create and execute SQL statements using enhanced SQL editor

Visually design queries using Query Builder

Open and save SQL documents, view and edit table data using grid-based data editor

OraDeveloper offers you lots of additional useful features including:

Flexible connectivity

Easy data exporting with support for HTML, XML, MS Excel, Text file formats

Database export/import

Wide range of supported Oracle server objects

Convenient and flexible user interface

Comprehensive help system

OraDeveloper Studio does not require Oracle client software installed. Instead, it talks to the Oracle server directly. It supports all ranges of Oracle servers from 7.3 to 10g.

What's new in OraDeveloper Studio V2.55.167?

ObjectDisposedException on opening Database Explorer - bug fixed

Problem with retrieving data from the table with BLOB fields - bug fixed

Sorting DATE fields in Data Editor - bug fixed

Problem editing data of fields with Object Type data type - bug fixed

Compilation of PACKAGE BODY is working now

Actions with files now do not cause to encoding loss

Scale for columns with data type as TIMESTAMP retrived without errors now

OraDeveloper Studio V2.50x offers you following new features:

Advanced Context-sensitive Code Completion

Extended support of SQL and PL/SQL syntax

Code Completion now contains built-in Oracle functions

SQL*Plus Command Support

VARIABLE, @ and @@ commands in debugging

Exporting a project to an SQL*Plus run script

Following SQL*Plus commands are supported:

@

@@

ACCEPT

CLEAR

CONNECT

DEFINE

DESCRIBE

EXECUTE

PROMPT

REMARK

VARIABLE

Keyboard Shortcut Customization - A set of keyboard mapping schemes with full customization added.

DDL generation improved - DDL generation is now highly customizable. You can tune DDL generation with plenty of options.

New Schema Objects Supported - The number of database objects which can be created with visual editors has increased. Here is the list of newly supported schema objects:

Clusters

Database links

Cluster indexes

Partitioned indexes

Database Object Dependency - Schema objects in the Database Explorer now have folders 'Depends on' and 'Used by'. You can access to object dependents and dependencies through these folders. You can now also easily compile object dependents and dependencies.

User comments for schema objects - OraDeveloper now allows you to view and edit comments for tables, views, materialized views, table and view columns.

Enhanced Code Templates - Code Templates window now allows you to preview code templates. Code templates are now not organized in folders in the completion list and can be inserted with typing template shortcut and pressing key.

Schema Export to SQL script - Schema Export Wizard provides you flexible export of a database or of some database objects to a script. Schema export can be tuned with a lot of options. You can export objects' structure, tables' data or both of them. Schema Import Wizard can import database from a script in a few clicks.

New Database Project Wizard - New Database Project Wizard allows you to create new Oracle project easily and to import existing database objects to the new project.

Database Object Search Enhancements - Find Object window design enhanced. Added full-text search in the non-source objects and data search in tables and views.

Session Manager Improvements - Session manager was improved. Cursor list now contains first part of SQL for each cursor and allows you to view the entire SQL text. Session statistics can now be filtered.

Database Explorer Enhancements - Database Explorer now stores navigation history. Different icons are available for different types of tables and folders. Column type and size can be displayed in the Database Explorer.

Start Page - Now OraDeveloper loads Start Page on startup, that provides fast access to the recent projects, common tasks, OraDeveloper online resources and help topics.

Other New Features

PL/SQL compilation warning support added

Oracle Instant Client support added

Date format can now be set for the Data Editor

Same file can be included several times in the deployment order

Table columns can now be created using copy/paste operations

What's new in OraDeveloper Studio V2.0?

Supported database projects

Added PL/SQL and script debugging

Added a Security Manager for performing security administration tasks

Improved SQL editor

Improved working with data

Added support for XML schemas and tables, object, clustered, and index-organized tables, materialized views and materialized view logs

Added Session Manager for monitoring and manipulating sessions

Added Event Monitor for sending and receiving alerts and pipe messages

Database object search extended with searching for columns, constraints, and indexes, searching for data and PL/SQL source code

Added Document Outline window, that displays opened SQL document logical structure

Added an extensive collection of SQL and PL/SQL code templates

OraDeveloper Studio has been renamed and is now called dbForge Studio for Oracle.

If you require more information, please visit the pages above or Contact Us for pricing and availability.

Explore and maintain Oracle databases and simplify Oracle database development.

Operating System for Deployment: Windows 7, Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit

Product Type: Application

Compatible Containers: Oracle Database 9i, Oracle Database 10g

Keywords: ora developer

crlab corelab

Database DB Management

Development

SQL query language