On The Edit tab, allows you can to view and write complex SQL statements that cannot be defined using the Design tab.

• When

...

• switching from the Design tab to the Edit tab, the SQL constructed in the Design tab is

...

• displayed as a complete SQL statement

...

• .

• You can also write dynamic SQL

...

• queries directly in the Edit tab.

...

• Refer

...

• to the section on writing dynamic SQL queries for more details.

The SQL statement written or modified in the Edit tab will be used as the final SQL for compilation.To prevent a complex query (defined

Handling SQL Overwrites

If you modify a query in the Edit tab) from being overwritten, when you switch over and later switch to the Design tab, make some changes, and get back return to the Edit tab; , you will be prompted with a dialog.If you select Yes, your changes encounter a prompt:

• Yes: The SQL in the Edit tab will be overwritten

...

• by the newly constructed SQL

...

• from the Design tab

...

• .

• No: The SQL in the Edit tab will remain intact and

...

• will be used as the final SQL.

This mechanism helps prevent accidental overwriting of complex queries.