SQL editor

SQL*XL home

This dialog is used to create SQL statements. You can create multiple statements but you need to end each statement with a semi-colon (;) symbol. Closing the editor will copy the SQL to the SQL dialog of SQL*XL.

The SQL editor shows a text editor pane to the right. To the left of the dialog there is a panel with different sections. In these sections you can find SQL templates and commands. You can also find a database objects list. You can drag and drop items from the sections to the editor. Right click on the items in the database objects list to create SQL statements. Each object or group will have its own SQL creators available.

Dialog Items:

• Return SQL to SQL*XL button
• SQL text area
• Database Objects section
• ANSI SQL section
• Database Specific section
• SQL*XL section
• Explanation area
• Statusbar

See also:

• Submit Multiple Select Statements
• Execute non SQL commands
• Explicit Column Formatting
• Dialogs
• Techniques
• Menu and Toolbar Items
• SQL*XL Home