You can edit a SQL file using Content Assist.
-
Right-click the SQL file that you want to edit in the Navigator
and select
Open.
The SQL file displays in the SQL Editor and a connection state, connected or not connected, is displayed in the status bar at the bottom left edge of the Workbench.
-
If the SQL file is not connected to a database, right-click the file and select
Attach Connection Profile.
This enables you to use the full capabilities of content assist and to execute the SQL file or selected statements.
-
Edit the SQL file using content assist or enter edits manually.
-
(Optional) To remove edits since your last save, select
.
-
Save the file to its project.