Take a quick look at the main features of SQLGate in this video!
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.
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 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.