SQL: What are SQL Scripts?


This article has not been updated recently and may contain dated material.

 

A set of SQL commands saved as a file in SQL Scripts is what is called simply a SQL Script.  The SQL Scripts can contain more than one PL/SQL block or SQL statements.  SQL Scripts can be used to edit, create, view, run, and delete script files.

Remember the following when using SQL Scripts:

  • SQL Scripts and SQL Commands have no interaction between each other.
  • In a SQL script, SQL *Plus commands are ignored at run time.
  • Bind variables are not supported by SQL Scripts.
  • To run it in SQL Commands, a SQL Command can be cut and pasted from the SQL Script Editor.
     

Referenced From: MySQL

 

13605
8/11/2023 11:34:42 AM