You can use the File menu to create an SQL
statement in the SQL editor.
The SQL editor supports any statement that can be run by the database
to which you are connected. The statement that you create is stored in a file
with the extension .sql.
To create an SQL statement in the SQL editor by using the File menu:
- Open the Data perspective.
- Click .
- Complete the New SQL Statement wizard and then click Finish.
On the Statement Type page of the wizard:
- Under Edit using, click SQL
editor.
- In the Statement template field, select
the template for the type of statement that you want to create. If you do
not want to use a template, select None. If you want
to see sample statements, select Sample statements.
The SQL statement is added to the SQL Scripts folder
of the data development project that you selected in the wizard. The statement
opens in the SQL editor.
- Complete the SQL statement in the SQL editor, and then save the
statement.