Online Documentation for SQL Manager for Oracle

Feature matrix


The FREE Lite version of SQL Manager for Oracle does not include all features of the Full version and has some limitations concerning the number and size of the databases (4Gb) that can be registered and the number of data manipulation and server maintenance tools. The detailed feature matrix is given below.

 

Note that when using the FREE Lite version of SQL Manager for Oracle you can activate a 30-day period of fully-functional usage. After the period expires, you will be able to continue using the Lite version.

 

For more information on activating the Full version features see Full Mode activation.

 

Full version Lite version
Latest Oracle versions support
Support of all server versions from 8.1.7 to 21c
+
+
Support of compressed tables, OLAP tables, read-only/read-write tables, virtual columns
+
+
Support of invisible indexes
+
+
Support of compound triggers, triggers with FOLLOWS clause
+
+
Powerful and easy management of object permissions, including column-level permissions
+
+
Support of Unicode data
+
+
Rapid database management and navigation
Multiple database connections
+
+
Connecting via local port forwarding through the SSH tunnel
+
-
Schema restriction to see only required schemas
+
+
Projects to work with the selected database objects only
+
+
Multiple user-defined tabs for any tree node to access it in one-click
+
+
Working with multiple selected objects at a time
+
+
Grouping/ungrouping registered databases
+
+
Database Registration Manager which allows adding and deleting database registrations quickly
+
-
Search in Metadata tool is implemented for performing the quick search within the scope of database metadata
+
-
Instance Manager service which allows checking the service status of Oracle server and starting/stopping the service
+
-
Powerful tools to make your work with Oracle Database as easy as it can be
PL/SQL Code Debugger for step-by-step code debugging of anonymous blocks, procedures, functions, packages, triggers, object types
+
-
Database Statistics to provide all essential statistics on the database: system statistics, statistics on sessions; statistics on storage, wait events, latches
+
-
Database Information to get all information on database instance and NLS parameters
+
+
Extracting metadata into text files or Execute Script editor
+
+
Powerful print metadata module to create customizable metadata reports
+
-
Search in metadata
+
-
Report Designer for building powerful reports visually
+
-
SQL Monitor
+
+
HTML Report Wizard to create a detailed HTML report about your database quickly
+
-
Client Checker to check the validity of Oracle client and provide common information on client settings
+
+
Database Comparer tool which allows getting a script to synchronize the database structure
+
-
Simple management of all Oracle Database objects (including create/edit/drop operations)
Managing tables and all their subobjects: fields, primary, unique and foreign keys, indexes, triggers, and check constraints
+
+
Managing views and all their subobjects: fields, triggers, primary, unique and foreign keys
+
+
Managing procedures, functions, sequences, packages and package bodies
+
+
Managing users, roles, profiles, consumer groups and resource plans
+
+
Managing database and schema triggers, clusters, synonyms, database links, materialized views and materialized view logs
+
+
Managing object and array types, object type bodies, libraries
+
+
Managing Java sources, resources and classes
+
+
Managing index types, operators, dimensions
+
+
Managing contexts, directories, tablespaces, rollback segments, redo log groups
+
+
Managing scheduler objects: schedules, programs, chains, job classes and jobs, window groups and windows
+
+
Managing jobs
+
-
Duplicating database objects
+
+
Viewing dependencies between database objects
+
+
Advanced data manipulation tools
Powerful BLOB viewer/editor with several modes of viewing BLOB data
+
-
Plenty of useful tools such as data grouping, summarizing, fast search and filtering
+
+
Master-detail view to work with two linked tables at the same time
+
-
Table and card views to see data the way you like
+
-
Ability to copy and paste selected records
+
-
Advanced printing system
+
-
Effective security management
Grant manager displaying all database object grants in the form of a grid
+
+
Ability to set permissions for table columns
+
+
Easy management of database users, roles and profiles
+
+
Viewing and changing object permissions in object editors
+
+
Excellent visual and text tools for query building
Query Designer allowing you to build complicated queries without any knowledge of SQL syntax
+
-
Multiple SQL editors with code completion, syntax highlight and code folding
+
+
Large script execution (Execute script editor)
+
+
Ability to view query plan as a diagram
+
-
SQL Formatter (available from Query Data editor context menu)
+
-
Favorite Queries (Save and use your frequently used queries easily)
+
+
Ability to format DML and DDL
+
-
Impressive data export and import capabilities
Exporting data to most popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF, etc.
+
-
Importing data from MS Excel, MS Access, DBF, XML, ODF, TXT and CSV
+
-
Exporting data to Execute Script as INSERT statements, with destination DMBMS specified
+
-
Report designer with a clear in use report construction wizard
Create Report Wizard allows you to create simple reports in a few clicks
+
-
Managing reports in the same way as if they were database objects: accessing reports directly through the DB Explorer tree
+
-
Visual Database Designer to handle database structure in a few clicks
Creating diagram of existing database using Reverse Engineering tool
+
-
Dividing diagram into different subject areas located on separate pages
+
-
Navigating through diagram using Diagram Navigator
+
-
Creating/editing/dropping tables and table fields, views, setting links between them visually
+
-
Ability to add comments to diagram
+
-
Saving as image or printing database diagram
+
-
Two diagram notations (IDEF1x and IE)
+
-
A lot of visual customization options
+
-
Easy-to-use wizards performing Oracle Database administrative tasks
Backing up database
+
-
Restoring database
+
-
Flashback
+
-
Collecting and managing optimizer statistics
+
-
Recompiling invalid objects
+
-
Enabling/disabling constraints
+
-
Truncating table or cluster data
+
-
New state-of-the-art graphical user interface
Well-described Wizard system
+
+
Improved database explorer for easy management of all Oracle objects
+
+
MDI and floating-window styles implementation
+
+
Windows Toolbar to switch between windows easily, like in Windows Task Bar
+
+
Navigation bars with hot actions in most of the windows
+
+
Ability to save all program settings
+
+
Customizable toolbars for all program windows
+
+
Fully customizable program interface
+
+
Localizable program interface
+
+
...and other useful features
Keyboard templates
+
+
To-Do list
+
+