START
STA[RT] filename [arg1 [arg2...]]

Runs a series of SQL*Plus commands, and/or SQL and/or PL/SQL statements contained in a file.

Keywords

filename

Specifies the name of an operating system file containing SQL and/or PL/SQL statements.

arg

One or more arguments to be passed to the script. These arguments may be referenced within the SQL or PL/SQL script as &1, &2, etc. Arguments are positional and are separated by spaces.

This command is equivalent to specifying @filename.

Command files may be nested; in other words, a command file may contain another START filename command.

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.