dbForge Studio for Oracle released

dbForge Studio for Oracle (formerly known as OraDeveloper Studio) is an Oracle database development tool. With dbForge Studio for Oracle, you can browse and edit database objects, run SQL statements and SQL scripts, debug PL/SQL statements, edit and export table data, and synchronize databases. You can also build visual representation of your schemas, create data reports. dbForge Studio for Oracle is focused on enhancing productivity and simplifying your daily database development tasks.

Features

• PL/SQL Editor - Type SQL code faster with dbForge Studio for Oracle. Together with the code completion, syntax highlighting, code folding features the Oracle development tool offers code snippets and code navigation that will let you write and check SQL code effectively.
• Data Editor - Data in Data Editor is displayed in a grid, where you can group, sort, display it in card view, copy it to clipboard, apply filtering, search for the data you need, edit foreign keys with a built-in editor. Data Editor supplied with the Oracle database tool lets you view and edit data with comfort.
• Database Explorer - Database Explorer available in the Oracle development tool will help you view detailed object properties and browse data using Object Viewer, perform multi-selection for batch operations on objects, manage all connections as easily.
• Integrated PL/SQL Debugger - PL/SQL Debugger provides such features as Step In, Step Over, Step Out, Breakpoints, Call Stack with navigation, Watches, etc. With PL/SQL Debugger available in the tool for Oracle database management, you can debug any PL/SQL code and scripts easily and effectively.
• Data Export/Import - dbForge Studio for Oracle database tool provides possibility to export data to and import it from the most popular formats (MS Access, Text, XML, MS Excel, etc.). Export and import can be tuned to meet all requirements. You can also automate data export and import using command line.
• Database Diagrams - Visual representation of such database objects as tables, views, procedures, functions will be of great help when designing new databases or working with the existing ones. Just drag the objects - and you will be able to view and edit their properties, relations between them, etc.
• Oracle Schema Compare Tool - Oracle schema compare tool provides highly customizable schema comparison and synchronization. Process automation using command line, generation of comparison reports and schema synchronization script, and many other features will be here for you if you choose to use the Oracle database development tool.
• Oracle Data Compare Tool - Try the Oracle data compare tool available in dbForge Studio to compare and synchronize data in your tables. Set different options, map your tables the way you want them to be mapped, generate comparison reports in different formats and automate data comparison using command line interface.
• Database Projects - Project management system facilitates database development as it allows creating database projects and integrating related database development files. When building a project, you can create a single ready-to-deploy script for deploying database to the server.
• Query Builder - Draw your queries with Query Builder. The Oracle development tool allows creating queries without typing any code: drag'n'drop the tables/views you need, specify the columns you want to retrieve data from, joins, where, group by, etc clauses and execute your query.
• Reporting and Analysis Tools - Design any data reports with parameters, customizable formatting, calculated summaries with the help of the dbForge Studio reporting tool. Streamline your work with multi-dimensional data, visualize data trends and dependencies with special charts, convert your data in pivot tables.
• Schema Export/Import - Schema export/import wizards will let you prepare dumps of your schemas and import them. You can select any of five compression levels to compress files, use auto delete of old dumps to free disc space, and use rich options set for a schema to export.
• Schema Object Editors - Schema object editors provide clear and comprehensive environment for managing existing schema objects and creating new ones. For each schema object, there is a separate object editor, where you can set or modify any properties available for this object.
• Administration Tools - Every Oracle developer will take advantage of possessing tools for manipulating user accounts, managing server sessions, etc., that can be used via graphical UI. With such Oracle development tool as dbForge Studio you will spare a lot of effort when performing database administration tasks.
• Query Profiler - View explain plan and session statistics in Query Profiler to monitor query performance. Possibility to compare profiling results is the key in Oracle queries optimizations, as you can see differences in profiling results for query executions before and after modifications highlighted in the grid.
• Find Database Objects - The Find Database Object functionality available in the dbForge Studio for Oracle development tool can effectively search databases and find a required database object by any fragment of its CREATE statement, as well as find a data fragment in one or several tables.

About Devart (formerly Core Lab)

Devart (formerly Core Lab) is a leading company working in the database connectivity area. They offer well-known native VCL/CLX components and dbExpress drivers for direct access to Oracle, MS SQL Server and MySQL. Provide advanced data access solutions for the Microsoft .NET Framework - ADO.NET data providers for native connectivity to Oracle, MySQL, and PostgreSQL database servers. Devart is also a vendor of powerful database tools designed to automate and simplify database development process.