Watch the SQLGate main features in video!
Net login can connect to the Oracle server in the form of TCP / IP without an Oracle client. You can easily connect to an Oracle server without installing an Oracle client on your local machine.
You can run multiple SQLs at once and see the results in the grid. It is easier to compare data. The subquery also automatically recognizes fields. After moving the cursor to the table location, press ALT + 1 to view the column information, and ALT + 2 to view the data immediately. The ALT hotkey option allows the user to add user queries up to ALT + 0.
Data can be efficiently viewed through filtering, sorting, and grouping of query results. You can also copy and paste like Excel, and you can add cells, total number, and so on.
Provides the ability to 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 and variable autocompletion, and provides related object recompilation.
You can view the execution plan in the SQL editor and analyze it in the form of tree view, text, and flowchart. In addition, the Show Execution Plan Object feature allows you to analyze objects in the execution plan with a single click.
You can create queries through drag and drop of tables in the Objects panel. You can select the fields that you are interested in and make the relationship through drag-and-drop.