You can create SQL and XQuery statements by using the SQL and XQuery editor
in the Data perspective.
The SQL and XQuery editor supports any statements that can be run by the database
to which you are connected. You can create single or multiple SQL statements,
single or multiple XQuery statements, XQuery statements that are nested in
SQL statements, and SQL statements that are nested in XQuery statements.
Restriction: The editor is not fully supported for creating triggers
or routines.
You can open the SQL and XQuery editor from any of the following places in the workbench:
- The File menu
- A data project
- A
physical data model in a data design project
- A database connection
- The Data Source Explorer toolbar