OraDeveloper Tools is a powerful add-in designed to simplify the Oracle database
application development process. It integrates into Microsoft Visual Studio and
Embarcadero RAD Studio (Delphi), making all database development and administration
tasks available from your favorite IDE. It provides an easier way to explore and
maintain existing databases, design compound SQL statements, query and manipulate
data in different ways.
OraDeveloper Tools brings Oracle development and administration power to the newest
development environments from Microsoft and Embarcadero.
Note: Express Editions of all versions of Microsoft Visual Studio are not
Drag database objects from DbExplorer to create preconfigured connection, data adapter,
or command objects of the following products:
OraDeveloper Tools provides some special features for
dotConnect for Oracle Professional Edition. Due to OraDeveloper Tools
dotConnect for Oracle gains enhanced component designers, which are extended
with additional commands. The commands provide easy access to useful operations
such as opening query builder, SQL editor, or any object editor that can assist
you in current situation.
Navigating through databases has never been easier. An integrated Database Explorer
window lets you effortlessly browse the entire server hierarchy. With one-click
access to data and property views, you can reach, view, and modify all database
schema objects in seconds. Database Explorer displays database object dependencies
for easy finding of depending objects, and stores user browsing history for easy
returning to visited objects and folders. OraDeveloper Tools allows you to search
for database objects in selected schemas by name. You can also search for PL/SQL
code in source objects and locate data in tables, views, and materialized views.
With OraDeveloper Tools you will no longer need to spend hours manually modifying
database structure. OraDeveloper Tools automates routine tasks and makes common
database operations easily accessible. You can create and duplicate schema objects
directly from the Database Explorer and visually modify objects, add constraints,
and set triggers with a set of powerful objects editors. Object editors are optimized
for efficient database interaction and feature intuitive and user-friendly layouts.
Moreover, OraDeveloper Tools gives you full control of the database engineering
process and lets you view the DDL statements of each schema object and generate
and edit DDL scripts for multiple database objects.
OraDeveloper Tools comes with an extensive project management system that you can
use create database projects and integrate related database development files. Database
project units make it easer to manage large development projects and automate routine
database maintenance tasks. You can use the Solution Explorer to bookmark and integrate
separate scripts, query files and favorite database objects into projects, work
on them from a single workspace, compile source objects, and easily deploy entire
project batches, specifying the order of execution. With New Database Project Wizard
you can easily create a new project or import an existing schema to a new project.
Enhanced SQL editor provides many useful features to make the development process
easier. It simplifies SQL scripting by highlighting syntax as you type and helps
you write queries with context-sensitive code completion and parameter information
features for both scripts and single statements. Moreover, a separate SQL history
keeps track of which SQL statements you have run and stores them so you can recall
any of them once you need it. OraDeveloper Tools contains a number of most frequently
used code examples to use in your SQL scripts or stored routines. Document Outline
window shows opened SQL document logical structure. It can be used to view document
elements and navigate to them. Navigation bar eases navigation between DDL statements.
Any SELECT statement in a script or PL/SQL object can be visually designed with
Query Builder. Advanced Visual Query Builder makes it possible to build even the
most complicated queries without typing a single line of text. OraDeveloper Tools
also supports some SQL*Plus commands.
With OraDeveloper Tools, you can debug all Oracle source objects with a built-in
PL/SQL Debugger and perform step-by-step execution of SQL commands with an integrated
SQL script debugger. OraDeveloper Tools lets you set breakpoints to stop execution
on any line of code. It includes a Call Stack window for viewing the currently active
stack of PL/SQL program and a Watches window and evaluating and modifying program
OraDeveloper Tools features a powerful database administration toolkit, including
Security and Session Managers and Schema Import and Export Wizards. Security Manager
allows you to perform the full range of database security administration tasks such
as manipulating users, granting and revoking roles and privileges, managing profiles.
Session Manager lets you control user sessions and watch their information.
Grid-based Data Editor has everything you might require when inspecting and editing
data. You can filter, group, and sort data in-place, as well as customize the grid,
cache updates on client, or control data manipulation with connection-level transactions.
A separate LOB Viewer and LOB Editor allow you to view and edit field values that
contain binary and long text data.
You can export all the selected data or only specific rows and columns. Data export
wizard helps you export data to Text, HTML, XML, and MS Excel file formats. Before
exporting you can customize export style attributes, such as text, background and
border color, font, and set output format of exported columns.
Use the Export Utility Wizard to back up part or all of a database in binary format.
The versatility of native Oracle Exp and Imp utilities is now available in a short
sequence of user-friendly dialogues. Import Utility provides you a very easy database
restoring from previously exported file.
Schema Export Wizard allows you to extract schema to script. You can extract any
database objects metadata, extract data from all or selected tables, set different
extracting options, which affect the result script. Schema Import Wizard provides
you a very easy schema restoring from a script.
We support all range of Oracle servers from 8i to 11g.
OraDeveloper Tools does not require Oracle client software installed and can communicate
directly with the Oracle server.
More features >
OraDeveloper Tools is available in two editions.
The OraDeveloper Tools for Visual Studio edition is
built on VSIP technology. It includes add-ins for the following environments:
The OraDeveloper Tools for RAD Studio edition is built
on Embarcadero integration technology. It includes add-ins for the following environments:
You might be also interested in:
Related development environment:
Oracle data access with the following technologies: