How to run sql file in oracle sql developer

This chapter helps you learn to write and edit scripts containing SQL*Plus commands, SQL commands, and PL/SQL blocks. It covers the following topics:

Read this chapter while sitting at your computer and try out the examples shown.

Before beginning, make sure you have access to the sample schema described in Chapter 1, "SQL*Plus Overview".

Editing Scripts

In command-line SQL*Plus, the use of an external editor in combination with the @, @@ or START commands is an effective method of creating and executing generic scripts.

You can write scripts which contain SQL*Plus, SQL and PL/SQL commands, which you can retrieve and edit, and which can be executed in either command-line or iSQL*Plus user interfaces.

How to run sql script in sqlplus command line in windows

This is especially useful for storing complex commands or frequently used reports.

You can load any valid SQL script into iSQL*Plus that you can access from your workstation. Some web browsers may require you to create a MIME type or application association for files with a .SQL extension in order to load them into iSQL*Plus.

See "Adding MI

how to execute multiple sql files in sqlplus

how to run sql script in sqlplus command line in linux