SQL Manager for Oracle

SQL Manager for Oracle Description

SQL Manager for Oracle is a professional and straightforward software solution that enables you to manage tables and all their objects such as fields, unique and foreign keys and check constraints.SQL Manager for Oracle works with any Oracle versions from 8.1.7 to the newest one and supports the latest Oracle Database features and data types including compressed, OLAP, read-only and read-write tables; invisible indexes; compound triggers, triggers with FOLLOWS clause and others. It offers plenty of powerful Oracle tools such as PL/SQL Code Debugger, Backup/Restore Database wizards, Visual Database Designer to create Oracle database in few clicks, Visual Query Builder to write complex Oracle SQL queries, Database Statistics to monitor Oracle performance, Grant manager for effective Oracle security management and many more useful features for efficient Oracle administration. SQL Manager for Oracle has a state-of-the-art graphical user interface with a well-described wizard system, so clear in use that even a newbie will not be confused with it. Here are some key features of "SQL Manager for Oracle":Rapid database management and navigationPowerful tools to make your work with Oracle Database as easy as it can beEffective security managementVisual Database Designer to handle database structure in a few clicksConnecting via local port forwarding through the SSH tunnelWorking with multiple selected objects at a timePL/SQL Code Debugger for step-by-step code debugging of anonymous blocks, procedures, functions, packages, triggers, object typesHTML Report Wizard to create a detailed HTML report about your database quicklyDatabase Comparer tool to get a script for synchronizing the database structureManaging tables and all their subobjects: fields, primary, unique and foreign keys, indices, triggers, and check constraintsManaging object and array types, object type bodies, librariesPowerful BLOB viewer/editor with several types of viewing BLOB dataVisual query builder allowing you to build complicated queries without any knowledge of SQL syntaxExporting data to most popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF etc.Navigating through diagram using preview navigation toImproved database explorer for easy management of all Oracle objectsCustomizable toolbars for all program windows Requirements:300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended64 MB RAM (128 MB or above is recommended)50MB of available HD space for program installationSuper VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommendedMicrosoft Mouse or compatible pointing deviceOracle Client 8.1.7 or higherPossibility to connect to any local or remote Oracle server Limitations:30 days trialNag screen What's New in This Release: [ read full changelog ]Use of sequences in fields editor. Support of autoincrement fields.DEFAULT ON NULL option of column editors.Size of varرپhar type fields is up to 32767 bytes.PL/SQL subprograms in WITH … SELECT queries.Partitioning mechanism is improved:Online move of partitions (without demounting database);Delete and remove several partitions at once;Split and merge partitions.Granting and revoking program module roles.Support of limits when uploading table and view data.Support of KEEP … SESSION option in sequences.Extract Database. Option "Delete existing records" is added.Role editor. Support of IDENTIFIED USING option.HTML Report. Operating procedure is significantly improved; HTML reports are created much faster now.When connecting through SSH, if SID and alias in tnsnames.ora were different, the connection error ORA-12514 occurred. Fixed now.When saving the diagram of Visual Database Designer as image, it was cut. Fixed now.Despite the restrictions set in "Schema Restriction... �.You can free download SQL Manager for Oracle from Softpedia now.