You can manually create a SQL file.
You can use an existing project to store the SQL file or create a project when you create the SQL file.
-
In the Database Development perspective, select
, expand SQL Development, select SQL File, and click Next.
The
New SQL File wizard opens.
-
Do one of the following:
- To use an existing project, in the
Enter or Select the Parent Folder field, enter or select the project name.
- To create a new project, click
Create Project and follow the wizard instructions.
-
Type the SQL file name in the field above the Advanced button.
-
(Optional) Click
Advanced to link to a file in the file system and to create, edit, or remove defined path variables.
-
Select a connection profile type from the
Connection profile type drop-down list.
-
To associate the SQL file with a connection profile, select from the
Connection profile name drop-down list.
Note: If the a connection profile does not appear, click
Create to create a new connection profile.
-
Narrow your database selection in the
Database Name field.
-
(Optional) Select the
Do not connect now check box if you do not want to connect to the server.
You cannot use the complete content assist feature if this check box is selected.
- Click
Finish.
A SQL file is created under the project in
the Navigator. The cursor moves to either the empty SQL file in the editor or to the beginning of the file if you linked it to an existing file.
-
Right-click in
the SQL Editor and select
Visual SQL to enter SQL statements.
- Use Content Assist to edit the SQL statement.
-
Right-click
in the SQL Editor and select
Save File.