You can create an SQL statement by using the SQL editor in the
Data perspective. The SQL editor supports any statement that can be run by
the database to which you are connected.
To meet the work process of multiple roles, the workbench provides several
approaches for creating SQL statements. You can create an SQL statement in
the SQL editor by using any of the following approaches:
- The File menu
- A data project; that is, a data development project or
a data design project
- A physical data model in a data design project
- A database connection
- The Database Explorer toolbar