SQLGrid is an interactive query tool for Oracle
developers. This is a SQL Worksheet replacement with a host of
additional commands. SQLGrid provides a way to execute arbitrary
SQL or PL/SQL code and also investigate how it is execute and it's resource
Using the SQLGrid, you can enter, edit, and
execute SQL and PL/SQL code.
The SQLGrid maintains a history of the
commands you have issued, so you can easily retrieve and re-execute
SQLGrid has a scrap book that allows you to save SQL
commands between sessions.
SQLGrid can produce DDL and data population scripts.
An integrated schema explorer allows you to use drag
and drop SQL editing.
This is the SQLGrid workspace. The top pane
contains SQL editor with context highlighting. The bottom pane
contains the output and is generated in HTML so you can copy and paste
into into Word documents, etc... Click here
to see the HTML report.
The login dialog saves a history of connections. If
you omit a user name and password, a connection will be attempted using
This screen shot shows the schema browser on the
right. You can use drag-and-drop editing from the browser to the
The sample output on the bottom shows the execution plan and statistics
for the executed query. Click here to see
the actual HTML report.
This is an example of a describe on a table. Note
that not only is the table described, but also it's constraints,
indexes, etc... Click here to see
the full HTML description.
The options dialog allows you to specify how you want
SQLGrid to behave. You can control the contents of the report, the
size of the font user to generate the report, where the report is
This is the Scrapbook dialog. The scrapbook allows
you to build a library of commonly executed queries. The scrapbook
supports drag-and-drop editing.
This is the history window which allows you to review and
reuse the queries you've executed. The history tool also supports
The analyze tool allows you to analyze tables and their
indexes and compute statistics used by the Oracle optimizer to ensure
that queries are executed in the most performant manor.
The repair tool utility allows you to repair by
compilation, any objects that have become invalid in the current Oracle
Using the statistics tool, you can connect statistic for
any query you execute. This is extremely useful with performing
database tuning exercises.
This dialog can be opened from the statistics dialog and
allows you to select what statistics you would like to collect from