EMS SQL Query for Oracle

What is EMS SQL Query for Oracle?

EMS SQL Query for Oracle is a useful tool that allows you to create fast and simple SQL queries to Oracle databases. The visual query constructor for Oracle, as well as direct editing of query text, are available. The user-friendly graphical interface allows you to connect to Oracle databases, select tables and fields for a query to the Oracle server, define selection criteria, and more. Using this query utility, you can work with multiple Oracle queries at once, edit the query text in the powerful SQL editor, view the results of execution in different modes, create Oracle queries with unions and subqueries visually, create queries-based diagrams, view the execution of the Oracle query plans, and perform any other operations required in your work with queries to the Oracle database.

Core features

• Friendly graphical interface.
• UTF8 media.
• Asynchronous query execution.
• Connect through the SSH tunnel: Connect to an intermediate SSH server and route all Oracle commands through the secure tunnel.
• Using drag-and-drop operations when visually selecting tables and fields for a query.
• Working simultaneously with multiple queries in separate windows.
• Navigation in newly used queries and selection of the necessary queries.
• Syntax highlight, "fast code" and keyboard templates for faster editing of query text.
• Tools for grouping and filtering data.
• The ability to create queries with joints and subqueries visually.
• The ability to create diagrams based on queries.
• Resources for viewing query plans.
• Powerful BLOB viewer/editor with various types of BLOB data visualization.
• Flexible customization of the graphical user interface.
• Multilingual GUI support.

System requirements

300 MHz processor; Recommended 600 MHz (MHz) processor

Microsoft Windows NT4 com SP4 ou posterior, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows 2008 Server, Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8, Microsoft Windows 8.1, Microsoft Windows 10

64 MB of RAM or more; 128 MB or more recommended

20 MB of available HD space for program installation

Super VGA (800x600) or higher resolution video adapter and monitor; Super VGA (1024x768) or higher resolution video adapter and monitor is recommended

Microsoft mouse or compatible pointing device

Oracle Client 8.1.7 ou superior

Possibility to connect to any local or remote Oracle server as a destination and an ADO-compatible source