To select individual scripts, click the check box to the left of the Edit icon. To select all scripts visible in the current page, click the check box in the column heading. Click Delete Checked to permanently remove the selected scripts from the Script Repository. You are prompted to confirm this action before the script is deleted. I was wondering if there was a way that I could generate an insert script based on only certain rows returned from a select statement. I know how to script all data from a table into a sql file of inserts however if possible I would like to only script inserts for rows that meet certain search criteria.

This section provides information on how to use SQL Scripts to create, edit, view, run, and delete script files.

This section contains the following topics:

What is 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 script files.

When using SQL Scripts, remember the following:

SQL*Plus commands in a SQL script are ignored at run time.
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.

Accessing SQL Scripts

To access SQL Scripts:

Log in to the Workspace home page.
To view SQL Scripts page you can either:
- Click the SQL Workshop icon and then SQL Scripts to drill-down to the SQL Scripts page.
- Click the down arrow on the right side of the SQL Workshop icon to view a drop down menu. Then select the SQL Scripts menu option.
Description of the illustration scripts.gif
Note:
For the purposes of consistency, this document uses the primary navigation path (or drill-down approach) when explaining navigation.

About the SQL Scripts Page

The SQL Scripts page display all SQL scripts created by the current user. You can control the appearance of the page by making a selection from the View list. The default view, Icons, displays each script as an icon. Details view displays each script as a row in a report.

Description of the illustration script_home.gif

The SQL Scripts page features the following controls:

Script. Search for a script by entering the script name, or a partial name, in the Script field and clicking Go. You control how many rows display by making a selection from the Display list.
Owner. Search for the owner of the script you want to view by entering the user name in the Owner field and clicking Go.
View. Change the appearance of the SQL Scripts page by making a selection from the View list and clicking Go. Available View options include:
- Icons (default) displays each script as an icon identified by the script name. Click the Show Results check box to additionally display run results as icons identified by the script name.
- Details displays each script as a line in a report. Each line includes a check box to enable the selection of scripts for deletion, an edit icon to enable the script to be loaded into the script editor, the script name, the script owner, when the script was last updated and by who, the size in bytes, the number of times the script has been run linked to the run results, and an icon to enable the script to be run.
  Details view offers the following additional controls:
  - Delete Checked. In Details view, select the check box associated with the script you want to delete and click Delete Checked. See 'Deleting a SQL Script'.
  - Sort. In Details view, click a column heading to sort the listed scripts by that column.
Upload. Click Upload to upload a script from your local file system into SQL Scripts. See 'Creating a SQL Script'.
Create. Click Create to create a script in the Script Editor. See 'Creating a SQL Script'.

Switching to Another SQL Workshop Component

You can navigate to another SQL Workshop component by making a selection from the Component list located on the upper right side of the page:

Object Browser. See 'Managing Database Objects with Object Browser'.
SQL Commands. See 'Using SQL Commands'.
SQL Scripts. See 'Using SQL Scripts'.
Query Builder. See 'Building Queries with Query Builder'.

About the Tasks List

A Tasks list displays on the right side of the SQL Scripts page.

Description of the illustration script_tasks.gif

The Task list contains the following links:

Manage Results enables you to view, search, and display results. See 'Viewing SQL Script Results'.
Show Quotas displays the Script Quotas page. The Script Quotas page shows the maximum size of a single result, the maximum size of all results, the quota used and the quota free. It also shows the maximum size of a SQL Script.
Export enables you to export multiple scripts from the current SQL Script Repository for import into SQL Scripts in a different workspace. The scripts you select to export are encoded in a single export script written to your local file system. The export script is named workspace_name_script.sql by default. See 'Exporting and Importing SQL Scripts'.
Import enables you to import a script exported by this workspace, or a different workspace. Import only imports scripts encoded in an export script created using Export. The export script to import must be accessible on your local file system. See 'Exporting and Importing SQL Scripts'.

Creating a SQL Script

You can create a script in the Script Repository by:

Creating a script in the Script Editor
Uploading a script from your local file system

Topics in this section include:

Creating a SQL Script in the Script Editor

To create an SQL script in the Script Editor:

On the Workspace home page, click SQL Workshop and then SQL Scripts.
The SQL Scripts page appears.
Click the Create button.
The Script Editor appears.
Enter a name for the script in the Script Name field.
Script name extensions are optional.
Enter the SQL statements, PL/SQL blocks and SQL*Plus commands you want to include in your script.
Remember that SQL Command Line commands are ignored at run time.
Click Save to save your script to the repository.
The SQL Scripts page appears listing your newly saved script.

Uploading a SQL Script

To upload a script from your local file system:

On the Workspace home page, click SQL Workshop and then SQL Scripts.
The SQL Scripts page appears.
Click the Upload Download android file transfer for macbook. button.
The Upload Script dialog appears.
To upload a script you can either:
- Enter the name and path to the script you want to upload to the Script Repository.
- Click Browse to locate the script you want to upload.
Optionally rename the script by entering the new name in the Script Name field.
This is the name given to the script in the Script Repository.
Click Upload to add the script to the Script Repository.
The SQL Scripts page appears listing your newly uploaded script.
The script is parsed during upload. If it has a syntax error, an error icon appears in place of the run icon in the SQL Scripts page Details view.
If a script of the same name exists in the Script Repository, you ar

Scripte Select