Running a SQL script file using the Interactive SQL READ statement

You can also run a SQL script file without loading it into the SQL Statements pane with the Interactive SQL READ statement.

Prerequisites

The privileges required depend on the statements being executed.

In the SQL Statements pane, execute a statement like the following example:
READ 'C:\\LocalTemp\\filename.sql';
In this statement, C:\LocalTemp\filename.sql is the path, name, and extension of the file. Single quotation marks (as shown) are required only if the path contains spaces. If you use single quotation marks then the backslash characters are escaped by doubling them to prevent translation of escape sequences such as '\n' or '\x'.

Results

The SQL script file is run.