5.1 About SQL Scripts

A SQL script is a set of SQL commands saved as a file in SQL Scripts.

A SQL script can contain one or more SQL statements or PL/SQL blocks. You can use SQL scripts to create, edit, view, run, and delete database objects.

When using SQL Scripts, remember the following:

  • SQL*Plus commands in a SQL script are ignored at runtime.

  • There is no interaction between SQL Commands and SQL scripts.

  • You can cut and paste a SQL command from the SQL Script editor to run it in SQL Commands.

  • SQL scripts does not support bind variables.