SQL Editor

The SQL Editor is a graphical user interface that enables you to create and modify objects that use SQL statements. Using the SQL Editor, you can:

• Create and modify SQL documents.
• Execute SQL statements.
• View returned data (including text and supported image data type).
• Save SQL documents.
• Save returned data as text.

Plug-in modules can extend the functionality of the SQL Editor. For example, the SQL Manager module adds support for data LOAD/UNLOAD statements, Code Completion, Query Designer, Query Execution Plan Analyzer, printing, color coding and other features.  For additional information on plug-in modules, see the Plug-in Modules topic .

You create SQL documents by entering, executing, and saving SQL statements in the SQL Editor pane. You can use SQL documents to store useful SQL scripts and object definitions. You can view and save returned data in the Output page of the SQL Editor pane.

Tips

• You execute SQL statements using the SQL Editor controls. The statements are submitted to the database server selected in the Database list box.
• The SQL Result History Dockable window on the SQL page displays summary information about the SQL statements that you execute.

See Also

• Creating SQL Documents
• Modifying SQL Documents
• Query Output Data
• Cell Viewer Window