This is a tool for Oracle database server administration and development.
Oracle Maestro is a tool for Oracle server administration and development. It supports all the current versions of the database in the market. That includes version 8 to version 11. It has the features of database objects management as well as a database designer. It also has SQL query designer and PL/SQL debugger. Data management features available let you do viewing, editing, grouping, sorting and filtering abilities of data elements. Oracle Maestro allows you to build diagrams based on Oracle data. Data analysis features will let you create a multi-dimensional model with analytical analysis so that it is easy to build the data cubes for OLAP analysis. Such cubes could effectively be re-oriented. View data in various ways very quickly so that the analyst is able to focus on business rules. He does not have to create a lot of reports to bring out the underlying relationship. This re-orientation, quite often involves re-summarizing very large amounts of data.
The Data Analysis tool allows you to save the created OLAP cube, print it, or export it to Excel, HTML, XML, and text file. SQL editor has the features that make it very handy to develop such query for day to day use. The SQL editor has code folding, code syntax highlighting, SQL formatter, multi-threading that all contribute to the development ease and speed of development. Creating a SELECT statement becomes easy and quick through the visual features. You are able to import/export code in several formats. The tools also include a BLOB Viewer/Editor. The tool itself can be customized in several ways. All that makes for a very handy tool for use with Oracle databases in your organization.