|
Oracle® HTML DB
Release 2.0 |
|
 Previous |
 Next |
To access the SQL Script Repository:
Log in to Oracle HTML DB.
The Workspace home page appears.
To view the SQL Script repository home page you can either:
Click the SQL Workshop icon and then SQL Scripts to drill-down to the SQL Scripts home page.
Click the down arrow on the right side of the SQL Workshop icon to view a pull-down menu. Then select the SQL Scripts menu option.
|
Note: For the purposes of consistency, this document uses the primary navigation path (or drill-down approach) when explaining navigation. |
By default, the SQL Scripts home page lists all SQL scripts in the SQL Script repository created by the current user.
On the SQL Scripts home page you can:
Search for a script. Enter a script name or partial name in the Find field and click Go. To view all scripts, leave the Find field blank, select - All Users - from the Owner list and click Go. You control how many rows display by making a selection from the Display list.
Change the Page View. You can change the appearance of the home page by making a selection from the View list. Available View options include:
Icons 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.
Delete a script. In Details view, select the check box associated with each script you want to delete, and click Delete Checked. See "Deleting a SQL Script".
Sort scripts. In Details view, click a column heading to sort the listed scripts by that column.
Upload a script. Click Upload to upload a script from your local file system into the SQL Script Repository. See "Editing a SQL Script".
Create a script. Click Create to create a new script in the Script Editor. See "Creating a SQL Script".
A Tasks list displays on the right side of the SQL Scripts home page.
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. These limits are set by the HTML DB Administrator. See "Managing Environment Settings".
Export enables you to export multiple scripts from the current SQL Script Repository for import into the SQL Script Repository 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 "Transferring SQL Scripts between Workspaces".
Import enables you to import a script exported by this, 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 "Transferring SQL Scripts between Workspaces".