SQL Files

SQL files provide a convenient way to store SQL code for reuse in a project, such as creating complex procedural objects.

You can group related SQL statements into a project and use Content Assist tools to add to or modify the contents. The SQL Editor allows off-line mode for SQL files, so you can work on SQL code development without connecting to a database and attach to a database only for deployment or execution. You can also save a procedural object definition as a SQL file.

Unlike stored procedures, SQL files have the following characteristics:

Related concepts
SQL Editor
Content Assist
Database Development Perspective
Related tasks
Creating a SQL File
Opening a SQL File
Editing a SQL File
Saving a SQL File
Executing a SQL File
Setting SQL Editor Preferences
Related reference
SQL Editor Preferences