• Main Features
  • Version History
  • Download(App/Manual)
  • Licenses
  • Subscription
  • Student License
  • Tech Support
  • Contact
  • Manage Licenses
  • Manage Subscription
  • User Profile
  • Change Password
  • Sign Out
  • Sign In
  • Find Password
  • Sign Up
  • 한국어
  • English
  • 한국어
  • menu
  • Product
  • Pricing
  • Customers
  • Docs
  • Support
  • Sign In
  • English
  • Download
  • Main Features
  • Version History
  • Download(App/Manual)

Main Features

Take a quick look at the main features of SQLGate in this video!

feature easyeasy feature smartsmart
feature beautifulbeautiful feature lightlight
Download product brochure Download free
[Link] Full video
Full Video

Quick links

  • Net Login
  • Themes
  • Object Explorer
  • Multiple SQL Execution & Auto-Completion
  • Grid Functions
  • Modifying Fetched Data
  • PL/SQL Editor
  • PL/SQL Debugger
  • SQL Execution Plan Viewer
  • SQL Formatting
  • Query Builder
  • ER design
  • Generating Database Report
Watch Video
Net Login

Net login allows users to connect to the Oracle server in the form of TCP/IP without installing an Oracle client.

Watch Video
Themes

There are 4 themes available. Choose the theme that best fits you!

Watch Video
Object Explorer

You can view lists, properties, and data of all objects stored in the database.

Watch Video
Multiple SQL Execution & Auto-Completion

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.

Watch Video
Grid Functions

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.

Watch Video
Modifying Fetched Data

Similar to Excel, you can edit data directly on the table. You can also paste data from the clipboard.

Watch Video
PL/SQL Editor

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.

Watch Video
PL/SQL Debugger

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.

Watch Video
SQL Execution Plan Viewer

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.

Watch Video
SQL Formatting

Various SQL customization options allow you to sort SQL in any way you like.

Watch Video
Query Builder

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.

Watch Video
ER design

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.

Watch Video
Generating Database Report

You can generate a report of the information about objects created in the database.

  • Product
  • Pricing
  • Customers
  • Docs
  • Support
    • Sign In
    • Sign In
    • Find Password
    • Sign Up
    • Language
    • English
    • 한국어
We use cookies to give you the best experience possible on our website. By continuing to use or browse our site, you consent to the use of our cookies. For more information, please read our Privacy Policy