OraDeveloper Studio Details
OraDeveloper Studio simplifies interaction with Oracle, automates routine development tasks, and makes large projects easier to manage. OraDeveloper Studio is a comprehensive tool designed for PL/SQL developers and Oracle users who are looking for a more flexible database development environment.
Download trialMain Advantages of OraDeveloper Studio
Convenient Server Browsing
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 Studio 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.
Simple Object Creation and Modification
With OraDeveloper Studio you will no longer need to spend hours manually modifying database structure. OraDeveloper Studio 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 Studio 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.
Database Project Support
OraDeveloper Studio 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 Project 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. Built-in Object-view window lets you easily navigate project files and locate database objects created by the project scripts. With New Database Project Wizard you can easily create a new project or import an existing schema to a new project.
Advanced SQL Handling
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 Studio 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 also supports some SQL*Plus commands.
PL/SQL and SQL Script Debuggers
With OraDeveloper Studio, 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 Studio 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 variables.
Database Administration Tools
OraDeveloper Studio 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.
Powerful Data Editing
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.
Easy Data Export
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.
Database Export and Import
OraDeveloper allows you to export database to the Oracle Export Utility dump file You can use the Export Utility Wizard to back up part or all of a database in binary format. The versatility of Oracle Export and Import Utilities is now available in a short sequence of user-friendly dialogues. Import Utility Wizard 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.
Wide Oracle Server Support
We support all range of Oracle servers from 7.3 to 11g.
Direct Access to Oracle Server
OraDeveloper Studio does not require Oracle client software installed and can communicate directly with the Oracle server.
General OraDeveloper Studio View
Requirements
OraDeveloper Studio requires .NET Framework 1.1 or 2.0. Microsoft .NET Framework is included in Windows XP Service Pack 2 and Windows 2003 Server. If you do not have .NET Framework installed, you can download it from the Microsoft website. For a brief explanation of the .NET Framework, consult this article.
System requirements
- 800 MHz or higher processor
- 512 MB RAM
- 20 MB of free hard disk space
- Microsoft Windows 2000/XP/2003