An example of a SQL*Plus script that writes employee last names and first names, separated by a comma, on individual lines of a file named “name.txt” is shown next.

A.1 Sample SQL Scripts Spatial Cartridge provides sample SQL script files to show how to use dynamic SQL in a PL/SQL block to create layer tables for spatially indexed data or to administer and ...

As illustrated in Figure 1, first, the build process runs a SQL script on a database management system (e.g., MySQL) to create the database and fill it with sample data.