SQL Manager for Oracle

SQL Manager for Oracle allows efficient database administration from a single interface, while also providing the tools needed to execute DML and DDL commands against an Oracle database. The application aims to provide a high-performance yet user-friendly working environment for database administrators.

SQL Manager for Oracle provides compatibility with Oracle 8.1.7 or later and enables users to configure the database connection using a simple step-by-step wizard. For security purposes, it can be configured to use SSH tunneling.

Setting the connection details is not the only task that can be performed by a wizard. In fact, users can create new databases based on existing templates with the help of a wizard, and perform various other administrative operations by clicking "Next" buttons. For instance, one can generate advanced statistical data about the database content, perform database backups and restore them when needed, enable or disable constraints, compare databases, generate reports, and more, all using wizards.

SQL Manager for Oracle comes with an integrated SQL editor and a query builder, which enables users to create, debug, and run scripts and queries, be them simple or complex. With line numbering and syntax highlighting, the editor proves to be a valuable addition to the overall package.

Also, users can create database objects, perform in-database searches, extract content and print metadata information. The dependency tree can be easily generated by the application, both for functional and multivalued dependencies.

Moreover, the application features a PL/SQL code debugger and a visual database designer that you can use to build a database without writing code.

SQL Manager for Oracle brings everything users need to manage and administer an Oracle database under the same roof, which means they don't have to download and install additional tools to fulfill various tasks and perform certain operations. Its feature set is not limited to database routine operations, but it also focuses on security and development.