Take a quick look at the main features of SQLGate in this video!
Net login allows users to connect to the Oracle server in the form of TCP/IP without installing an Oracle client.
There are 4 themes available. Choose the theme that best fits you!
You can view lists, properties, and data of all objects stored in the database.
You can run multiple SQLs at the same time and view the results in the grid. It makes data comparison a lot more convenient. The subquery also automatically recognizes fields. Place the cursor to the table and press ALT + 1 to view the column information and ALT + 2 to view the data immediately. You can add user queries up to ALT + 0 with ALT hotkey option.
Data can be efficiently viewed through filtering, sorting, and grouping query results. Like in Excel, you can copy and paste, add cells, sum columns and rows, etc.
Similar to Excel, you can edit data directly on the table. You can also paste data from the clipboard.
You can create PL/SQL, functions, procedures, packages and check for errors using the PL / SQL editor. (Sample Load / Error -> Fix / Invalid Object Recompile) It provides parameter, variable auto-completion, and related object recompilation.
The PL/SQL Debugger helps you debug procedures, functions, and packages. Like a general compiler, it provides the ability to set breakpoints and check the value of a parameter or variable.
You can view the execution plan in the SQL Editor and analyze it in tree view, text, and flowchart formats. In addition, the Show Execution Plan Object allows you to analyze objects in the execution plan with a single click.
Various SQL customization options allow you to sort SQL in any way you like.
You can create queries by dragging and dropping tables in the Objects Panel. Simply drag the fields of your interest and drop them on the collection of data to create relationships.
In the ER design window, you can create an entity-relationship diagram (ERD) that represents the relationship between tables. It also provides basic functions for ERD editing such as group area and text box, ERD output, file saving and retrieval function.
You can generate a report of the information about objects created in the database.