HTML DB User's Guide

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Documentation Accessibility

What's New in Oracle HTML DB?

New Features in Oracle HTML DB Release 2.0

Part I Getting Started with Oracle HTML DB

1 What Is Oracle HTML DB?

About Oracle HTML DB

About Application Builder

About SQL Workshop

About Oracle HTML DB Administration

2 Quick Start

Understanding Oracle HTML DB User Roles

Logging In to Oracle HTML DB

About Browser Requirements

Configuring Your Oracle HTML DB Environment

Logging In to Oracle HTML DB as a Developer

Requesting a Workspace

Logging in to a Workspace

Resetting Your Password

Logging Out of a Workspace

About the Oracle HTML DB User Interface

Navigation Alternatives

Navigating Using Breadcrumbs

Accessing Online Help

Page-Level Help

Procedural Online Help

Field Level Help

Creating an Application Using a Wizard

Running an Application

3 Running a Demonstration Application

Viewing and Installing a Demonstration Application

Running a Demonstration Application

Running an Application from Demonstration Applications

Running an Application from the Application Home Page

Understanding Sample Application

About the Home Page

About the Customers Page

About the Products Page

About the Orders Page

About the Charts Page

About the Admin Page

Viewing Pages in Printer Friendly Mode

Modifying a Demonstration Application

About the Developer Toolbar

Editing a Demonstration Application

Viewing Underlying Database Objects

Part II Application Development

4 Application Builder Concepts

About the Workspace Home Page

What Is Application Builder?

What Is a Page?

About the Page Definition

About Page Rendering

About Page Processing

About Shared Components

Understanding Page Processing and Page Rendering

How the HTML DB Engine Renders and Processes Pages

Understanding Conditional Rendering and Processing

Current Page in Expression 1

Exists

PL/SQL Expression

Verifying User Identity

Controlling Access to Controls and Components

Understanding Session State Management

What Is a Session?

Understanding Session IDs

Viewing Session State

About the Session State Page

Managing Session State Values

Referencing Session State

Setting Session State

Clearing Session State

Clearing Cache by Item

Clearing Cache by Page

Clearing Cache for an Entire Application

Clearing Cache for the Current User Session

About Bind Variables

Using Bind Variables in Regions Based on a SQL Query or LOV

Using Bind Variables in PL/SQL Procedures

Understanding URL Syntax

Understanding the URL that Displays for a Page

Using f?p Syntax to Link Pages

Calling a Page Using an Application and Page Alias

Calling a Page from a Button URL

Using Substitution Strings

Built-in Substitution Strings

AUTHENTICATED_URL_PREFIX

BROWSER_LANGUAGE

CURRENT_PARENT_TAB_TEXT

5 Using Application Builder

Accessing Application Builder

About the Application Builder Home Page

About the Application Home Page

Page Display Alternatives

About the Tasks List

About Application Attributes

Configuring Standard Application Attributes

Accessing the Edit Application Attributes Page

Editing Application Attributes

Configuring Security Attributes

Accessing the Edit Security Attributes Page

Editing Security Attributes

Configuring Globalization Attributes

Accessing the Globalization Attributes Page

Editing Globalization Attributes

About the Page Definition

Accessing a Page Definition

Understanding the Page Definition

Using the Developer Toolbar

Editing a Page Definition

Accessing a Summary View of Controls, Components, and Application Logic

Copying or Creating a Control or Component

Editing Page Attributes

About Page Rendering Controls

About Page Processing Controls

Understanding Validations

Understanding Branches

Understanding Page Computations

Creating a Page Computation

Understanding Computation Points and Computation Syntax

Editing Page Computation Attributes

Understanding Page Processes

Creating a Page Process

Editing Process Attributes

Accessing Alternate Page Views

Accessing Alternative Page Views

Referenced Components

About the Shared Components Page

Accessing the Shared Components Page

Understanding the Shared Components Page

Application Items

Application Processes

Application Computations

Web Service References

Build Options

Authentication Schemes

Authorization Schemes

Session State Protection

Edit Security Attributes

Translate Application

Text Message

Edit Globalization Attributes

Breadcrumbs

Lists

Navigation Bar Entries

User Interface Defaults

Lists of Values

Shortcuts

Cascading Style Sheets

Images

Static Files

Understanding Application Processes

About On Demand Application Processes

Running an On Demand Process from a Page Request

Application Process Example

Creating an Application Process

About the Application Process Page

Accessing Application Processes Reports

Utilization

History

Understanding Application Computations

About Application Computations

About Application Computations that Execute On New Instance

Creating an Application Computation

About the Application Computations Page

Accessing the Application Computation History Report

Viewing Application Reports

About the Database Object Dependencies Report

About the Region Source Report

6 Building an Application

Creating an Application

About Creating an Application Using a Wizard

About the Create Application Wizard

Creating an Application Based on Tables or Queries

About Application Models and User Interface Defaults

Leveraging Application Models and User Interface Defaults

About the Create Application from Spreadsheet Wizard

About Demonstration Applications

Accessing Demonstration Application

Deleting an Application

Deleting an Application from Application Builder

Deleting an Application from Edit Application Attributes

Adding Pages to an Application

Creating a Page from Application Home Page

Creating a Page from the Page Definition

Creating a Page from the Developer Toolbar

Running a Page or Application

About the Run Application Icon

Running an Application from the Application Builder Home Page

Running an Application from the Application Home Page

Running a Page from the Pages List on the Application Home Page

Running a Page from the Page Definition

Grouping Pages

Viewing the Page Group Report

Creating a Page Group

Assigning Pages to a Page Group

Locking and Unlocking a Page

Determining If a Page Is Locked

Locking a Page

Unlocking Pages

Accessing Alternative Locked Pages Views

Deleting a Page

Deleting a Page from the Page Definition

Deleting a Page While Editing Page Attributes

Creating Reports

Creating a Report Using a Wizard

Editing Report Attributes

Controlling Report Pagination

Including Pagination After the Rows in a Report

Including Pagination Before the Rows in a Report

Enabling Column Sorting

Adding a CSV Link to a Report

Enabling the CSV Output Option

Exporting a Report as an XML File or a CSV File

Creating a Column Link

Defining an Updatable Column

Defining a Column as a List of Values

Controlling When Columns Display

Controlling Column Breaks

Creating Forms

Creating a Form Using a Wizard

Creating a Tabular Form

Building a Master Detail Form

Creating a Form Manually

Processing a Form

Creating an Automatic Row (DML) Processing Process

Creating a Process that Contains One or More Insert Statements

Using a PL/SQL API to Process Form Values

Populating Forms

Validating User Input in Forms

Creating a Validation

Associating a Validation with a Specific Item

About Error Message

Creating Calendars

About Creating Calendars

Supported Calendar Substitution Strings

Creating a New Calendar

Adding a Calendar to an Existing Page

Adding a Calendar to a New Page

Converting an Easy Calendar to a SQL Calendar

Editing a Calendar Title

Editing Calendar Attributes

Accessing the Calendar Attributes Page

About SVG Plug-in Support

About Creating Charts

Creating a New Chart

Adding a Chart to an Existing Page

Adding a Chart to a New Page

Editing Chart Attributes

Understanding Chart Cascading Style Sheet Classes

Referencing a Custom Cascading Style Sheet

Specifying Custom CSS Styles Inline

Enabling Asynchronous Updates

Displaying Charts in Other Languages

Creating Buttons

Creating a Button Using a Wizard

Creating an HTML Button

Creating Multiple Buttons

Understanding the Relationship Between Button Names and REQUEST

About Branching with Buttons

Displaying Buttons Conditionally

Creating Items

Creating a Page-Level Item

About Item Naming Conventions

About Item Types

Referencing Item Values

Editing Page Item Attributes

Displaying Conditional or Read-Only Page Items

Working with a Multiple Select List Item

Using HTMLDB_UTIL.STRING_TO_TABLE to Convert Selected Values

Creating an Application-Level Item

About the Application Items Page

Accessing Application Item History

Populating an Alternative Date Picker Format

Defining PICK_DATE_FORMAT_MASK as an Application Substitution String

Defining an Application-Level Item Named PICK_DATE_FORMAT_MASK

Creating Lists of Values

Creating Named LOVs at the Application Level

About the List of Values Page

About Static LOVs

Editing an Existing LOV

Bulk Edit of Static LOVs

Referencing Session State Within a LOV

Referencing a Null Value in an Item Based on a LOV

Accessing LOV Reports

Text with JavaScript Escaped Single Quotes

Message

Message with JavaScript Escaped Single Quotes

Defining Shortcuts

About the Shortcuts Page

Accessing Shortcut Reports

Subscribed Shortcuts

Shortcut History

Incorporating JavaScript into an Application

Referencing Items Using JavaScript

Incorporating JavaScript Functions

Incorporating JavaScript in the HTML Header Attribute

Including JavaScript in a .js File in the Page Template

Calling JavaScript from a Button

Creating Dependent Select Lists

Creating a Help Page

Creating a Help Page and Region

Defining Help Text

Editing Multiple Item Help Topics at Once

Creating a Help Navigation Bar Entry

7 Controlling Page Layout and User Interface

Understanding Page Layout

Displaying Components on Every Page of an Application

Customizing Regions

Creating a Region

How Region Attributes Affect Page Layout

Controlling Region Positioning

Specifying a Region Header and Footer

Enabling Users to Customize a Page

How Item Attributes Effect Page Layout

Incorporating Content from Other Web Sites

Managing Themes

Accessing the Themes Page

About the Themes Page

Changing Default Templates in a Theme

Creating a New Theme

Switching an Active Theme

Copying a Theme

Deleting a Theme

About Exporting and Importing Themes

Changing a Theme Identification Number

Viewing Theme Reports

Viewing All Templates in a Theme

Viewing Theme Template Counts

Viewing File References

Viewing Class References

Viewing Template Substitution Strings

Customizing Templates

About Cascading Style Sheets

Selecting a Default Page Template

Selecting a Page-level Template Within a Theme

Selecting a Page-level Template for a Specific Page

Viewing Templates

Viewing Templates on the Templates Page

Viewing Templates from the Page Definition

Creating a New Template

Viewing Template Reports

Editing Templates

Breadcrumb Templates

About Breadcrumb Style Navigation

Breadcrumb Template Attributes

Button Templates

Button Template Attributes

Calendar Templates

Calendar Template Attributes

Label Templates

Label Template Attributes

List Templates

About Hierarchical Lists

List Template Attributes

Page Templates

Supported Page Template Substitution Strings

Page Template Attributes

Popup LOV Templates

Popup List of Values Template Attributes

Region Templates

Region Template Attributes

Report Templates

About Generic Column Templates and Named Column Templates

Report Column Template Attributes for Generic Column Templates

Report Column Template Attributes for Named Column Templates

About Using JavaScript in Column Templates

Optimizing a Page for Printing

Setting a Print Mode Template for an Application

Using f?p Syntax to Toggle to Print Mode

Using Custom Cascading Style Sheets

Uploading Cascading Style Sheets

About the Cascading Style Sheets Page

Referencing an Uploaded Cascading Style Sheet in the Page Template

Uploading Images

Editing Image Attributes

Deleting an Image

Referencing Images

Uploading Static Files

Editing an Uploaded File

Downloading an Uploaded File

Deleting an Uploaded File

Creating a Multiple Column Layout

Creating Regions in Multiple Columns

Creating a Multiple Column Page Template

Rendering HTML Using Custom PL/SQL

8 Adding Navigation

Creating a Navigation Bar Entry

About Navigation Bars

Creating a Navigation Bar Entry

Creating a Navigation Bar Entry Referencing an Icon

Creating a Navigation Bar Entry without an Icon

Editing a Navigation Bar Entry

Editing Multiple Navigation Bar Entries Simultaneously

Accessing Navigation Bar Entry Reports

Navigation Bar Entry Subscription Report

Navigation Bar Entry History

Creating Tabs

About Template Support

About the Tabs Page

Accessing the Tabs Page from Shared Components

Accessing the Tabs Page from a Page Definition

Creating a New Tab from the Page Definition

Using the Standard Tab Task List

Editing Multiple Tabs at Once

Accessing Tab Reports

Standard Tab Utilization

Standard and Parent Tab History

Controlling Navigation Using Branches

Creating Breadcrumbs

About Breadcrumbs

Creating Breadcrumbs

Creating Breadcrumbs from the Shared Components Page

Creating Breadcrumbs from a Page Definition

Adding Breadcrumb Entries

Adding a Breadcrumb Region

About Creating a Dynamic Breadcrumbs

Editing Breadcrumbs

Accessing Breadcrumb Reports

Breadcrumb Utilization Report

Breadcrumb History Report

Creating Lists

Creating a List

Creating a List from the Shared Components Page

Creating a List from a Page Definition

Adding List Entries

Adding a List to a Page

Editing Lists

Editing Multiple List Entries Simultaneously

Accessing List Reports

Accessing Tree Reports

Tree Utilization

Tree History

9 Managing User Interface Defaults

Viewing Tables or Views Utilizing User Interface Defaults

Navigating to the User Interface Defaults Page

Viewing the UI Defaults Report in Object Browser

Editing Column Attributes

About the Column Definition

About the Database Column Definition Report

Comparing User Interface Defaults Across Applications

About Exporting and Importing User Interface Defaults

10 Debugging an Application

About Tuning Performance

Reviewing Session State

Accessing Debug Mode

Enabling SQL Tracing and Using TKPROF

Monitoring Application and Page Resource Use

Viewing Oracle HTML DB Reports

Debugging Problematic SQL Queries

Removing Controls and Components to Isolate a Problem

11 Deploying an Application

About the Oracle HTML DB Application Development Life Cycle

System Development Life Cycle Methodologies to Consider

About Deploying an Application in Oracle HTML DB

Deployment Options to Consider

Whether to Copy the Workspace

Whether to Copy the Database

About the Application ID

Whether to Install a New Oracle HTTP Server

How to Deploy an Application to Another Oracle HTML DB Instance

About Managing Database Objects

Exporting an Application and Related Files

Exporting an Application

Exporting a Page in an Application

Exporting Cascading Style Sheets

Exporting Images

Exporting Static Files

About Importing into Another Oracle HTML DB Instance

Exporting Script Files

Exporting Themes

Exporting User Interface Defaults

Importing Export Files

Installing Export Files

Installing Files from the Export Repository

Installing Export Files from SQL*Plus

Verifying If Source and Target Workspace IDs Are Identical

Using SQL*Plus to Install Export Files

About Publishing the Application URL

Using Build Options to Control Configuration

Creating Build Options

About the Build Options Page

Viewing the Build Option Utilization Report

12 Managing a Development Workspace

Understanding Administrator Roles

About the Workspace Administration Page

Changing Your Password

Monitoring Activity

Accessing the Monitor Page

Viewing Application Changes by Developer

Viewing Application Changes by Day

Viewing Active Sessions

Managing Users

Creating New User Accounts

Editing Existing User Accounts

Changing a User Password

Managing Groups

Creating a Groups

Editing an Existing Group

Viewing Group Assignment Reports

Adding Users to and Removing Users from a Group

Managing Services

Viewing a Workspace Overview Report

Managing Session State and User Preferences

Managing Session State and User Preferences for the Current Session

Purging Sessions by Age

Viewing Session Details Prior to Removing Session State

Viewing Preferences for Users

Purging Preferences for a Specific User

Purging Log Files

Purging the Developer Activity Log

Purging the External Clicks Log

Terminating a Workspace Service

Requesting a Database Schema

Requesting Additional Storage

Viewing Schema Reports

Disabling PL/SQL Program Unit Editing

Controlling PL/SQL Editing for an Oracle HTML DB Instance

Managing Application Models

Deleting an Application Model

13 Managing Security

About Cross-Site Scripting Protection

Protecting HTML Regions and Other Static Areas

Using the Cross-Site Scripting Protection Attribute

Protecting Dynamic Output

Protecting Report Regions

Protecting Form Items

Remembering to Follow Best Practices

Understanding Session State Protection

How Session State Protection Works

Enabling Session State Protection

Enabling Session State Protection from Edit Security Attributes

Enabling Session State Protection from Session State Protection

Configuring Session State Protection

Reviewing Existing Session State Protection Settings

Configuring Session State Protection Using a Wizard

Configuring Session State Protection for Pages

Configuring Session State Protection for Items

Configuring Session State Protection for Application Items

Establishing User Identity Through Authentication

Understanding How Authentication Works

Determining Whether to Include Authentication

Creating an Authentication Scheme

Using the Authentication Scheme Repository

Viewing the Current Authentication Scheme for an Application

Changing the Current Authentication Scheme for an Application

Viewing Authentication Scheme Utilization

About Preconfigured Authentication Schemes

About DAD Credentials Verification

About HTML DB Account Credentials

About LDAP Credentials Verification

About Single Sign-On Server Verification

About Creating an Authentication Scheme from Scratch

About Session Management Security

Building a Login Page

About Deep Linking

Providing Security Through Authorization

How Authorization Schemes Work

Creating an Authorization Scheme

Editing Attributes of an Existing Authorization Scheme

About the Evaluation Point Attribute

About Resetting Authorization Scheme State

Attaching an Authorization Scheme to an Application, Page, or Components

Attaching an Authorization Scheme to an Application

Attaching an Authorization Scheme to a Page

Attaching an Authorization Scheme to a Control or Component

Viewing Authorization Reports

Subscription

Utilization

14 Advanced Programming Techniques

Sending E-mail from an Application

Sending E-mail Using a Background Job

Sending E-mail Manually by Calling HTMLDB_MAIL

Accessing Data with Database Links

Using Collections

About the HTMLDB_COLLECTION API

About Collection Naming

Creating a Collection

About the Parameter p_generate_md5

Truncating a Collection

Accessing a Collection

Deleting a Collection

Deleting All Collections for the Current Application

Deleting All Collections in the Current Session

Adding Members to a Collection

About the Parameters p_generate_md5 and p_clob001

Updating Collection Members

Deleting a Collection Member

Determining Collection Status

Merging Collections

Managing Collections

Obtaining a Member Count

Resequencing a Collection

Verifying Whether a Collection Exists

Adjusting Member Sequence ID

Sorting Collection Members

Clearing Collection Session State

Creating Custom Activity Reports Using HTMLDB_ACTIVITY_LOG

Running Background PL/SQL

Understanding the HTMLDB_PLSQL_JOB Package

About System Status Updates

Using a Process to Implement Background PL/SQL

Implementing Web Services

Understanding Web Service References

Accessing the Web Service References Page

Specifying an Application Proxy Server Address

Creating a Web Service Reference

Creating a Web Service Reference by Searching a UDDI Registry

Creating a Web Service Reference by Specifying a WSDL Document

Using the Web Service Reference Repository

Testing a Web Service Reference

Creating an Input Form and Report on a Web Service

Creating a Form and Report Directly After Creating a Reference

Creating a Form and Report by Adding a New Page

Creating a Form on a Web Service

Creating a Form Directly After Creating a Reference

Creating a Form by Adding a New Page

Invoking a Web Service as a Process

Displaying Web Service Results in a Report

Editing a Web Service Process

Viewing a Web Service Reference History

Managing User Preferences

Viewing User Preferences

Setting User Preferences

Setting User Preferences Using a Page Process

Setting the Source of an Item Based on a User Preference

Setting User Preferences Programatically

Removing User Preferences Programatically

Resetting User Preferences Manually

Resetting Preferences Using a Page Process

15 Managing Oracle HTML DB Globalization

About Translating an Application and Globalization Support

About Language Identification

Rules for Translating Applications in Oracle HTML DB

How Translated Applications Are Rendered

About Translatable Components

About Shortcuts that Support Translatable Messages

About Messages

About Dynamic Translation Text Strings

About Translating Region Titles

About Translating Templates

Specifying the Primary Language for an Application

Using Format Masks for Items

Translating Applications for Multibyte Languages

Understanding the Translation Process

Step 1: Navigate to the Translate Application Page

Step 2: Map Primary and Target Application IDs

Step 3: Seed and Export Text to a Translation File

Seeding Translatable Text

Exporting Text to a Translation File

Step 4: Translate the XLIFF File

Step 5: Upload and Publish a Translated XLIFF Document

Translating Messages Used in PL/SQL Procedures

Defining Translatable Messages

HTMLDB_LANG.MESSAGE API

Translating Data that Supports List of Values

Defining a Dynamic Translation

HTMLDB_LANG.LANG API

About Oracle HTML DB Globalization Codes

16 Oracle HTML DB APIs

HTMLDB_UTIL

CHANGE_CURRENT_USER_PW Procedure

CLEAR_APP_CACHE Procedure

CLEAR_PAGE_CACHE Procedure

CLEAR_USER_CACHE Procedure

COUNT_CLICK Procedure

CREATE_USER Procedure

CREATE_USER_GROUP Procedure

CURRENT_USER_IN_GROUP Function

EDIT_USER Procedure

EXPORT_USERS Procedure

FETCH_APP_ITEM Function

FETCH_USER Procedure

FIND_SECURITY_GROUP_ID Function

FIND_WORKSPACE Function

GET_ATTRIBUTE Function

GET_CURRENT_USER_ID Function

GET_DEFAULT_SCHEMA Function

GET_EMAIL Function

GET_FILE Procedure

GET_FILE_ID Function

GET_FIRST_NAME Function

GET_GROUPS_USER_BELONGS_TO Function

GET_GROUP_ID Function

GET_GROUP_NAME Function

GET_LAST_NAME Function

GET_USERNAME Function

GET_NUMERIC_SESSION_STATE Function

GET_PREFERENCE Function

GET_SESSION_STATE Function

GET_USER_ID Function

GET_USER_ROLES Function

IS_LOGIN_PASSWORD_VALID Function

IS_USERNAME_UNIQUE Function

KEYVAL_NUM Function

KEYVAL_VC2 Function

PREPARE_URL Function

PUBLIC_CHECK_AUTHORIZATION Function

REMOVE_PREFERENCE Procedure

REMOVE_SORT_PREFERENCES Procedure

REMOVE_USER Procedure

RESET_PW Procedure

RESET_AUTHORIZATIONS Procedure

SAVEKEY_NUM Function

SAVEKEY_VC2 Function

SET_ATTRIBUTE Procedure

SET_EMAIL Procedure

SET_FIRST_NAME Procedure

SET_LAST_NAME Procedure

SET_USERNAME Procedure

SET_PREFERENCE Procedure

SET_SESSION_STATE Procedure

STRING_TO_TABLE Function

TABLE_TO_STRING Function

DISPLAY_AND_SAVE Function

HIDDEN Function

MD5_CHECKSUM Function

MD5_HIDDEN Function

MULTI_ROW_UPDATE Procedure

POPUP_FROM_LOV Function

POPUP_FROM_QUERY Function

POPUPKEY_FROM_LOV Function

POPUPKEY_FROM_QUERY Function

RADIOGROUP Function

SELECT_LIST Function

SELECT_LIST_FROM_LOV Function

SELECT_LIST_FROM_LOV_XL Function

SELECT_LIST_FROM_QUERY Function

SELECT_LIST_FROM_QUERY_XL Function

TEXTAREA

TEXT Function

TEXT_FROM_LOV Function

TEXT_FROM_LOV_QUERY Function

HTMLDB_APPLICATION

Referencing Arrays

Referencing Values Within an On Submit Process

Converting an Array to a Single Value

HTMLDB_CUSTOM_AUTH

APPLICATION_PAGE_ITEM_EXISTS Function

CURRENT_PAGE_IS_PUBLIC Function

DEFINE_USER_SESSION Procedure

GET_COOKIE_PROPS Procedure

GET_LDAP_PROPS Procedure

GET_NEXT_SESSION_ID Function

GET_SESSION_ID_FROM_COOKIE Function

GET_USERNAME Function

GET_SECURITY_GROUP_ID Function

GET_SESSION_ID Function

GET_USER Function

IS_SESSION_VALID Function

LOGOUT Procedure

POST_LOGIN Procedure

SESSION_ID_EXISTS Function

SET_USER Procedure

SET_SESSION_ID Procedure

SET_SESSION_ID_TO_NEXT_VALUE Procedure

HTMLDB_LDAP

AUTHENTICATE Function

IS_MEMBER Function

MEMBER_OF Function

MEMBER_OF2 Function

GET_USER_ATTRIBUTES Procedure

GET_ALL_USER_ATTRIBUTES Procedure

Part III SQL Workshop

17 Building Queries with Query Builder

About Query Builder

Accessing Query Builder

Understanding the Query Building Process

Using the Object Selection Pane

Searching and Filtering Objects

Hiding the Object Selection Pane

Selecting Objects

About Supported Column Types

Adding an Object to the Design Pane

Resizing the Design and Results Panes

Removing or Hiding Objects in the Design Pane

Specifying Query Conditions

Creating Relationships Between Objects

About Join Conditions

Joining Objects Manually

Joining Objects Automatically

Working with Saved Queries

Saving a Query

Editing a Saved Query

Deleting a Saved Query

Viewing Generated SQL

Viewing Query Results

18 Managing Database Objects Using Object Browser

About Object Browser

Accessing Object Browser

Searching For and Browsing Database Objects

Searching and Filtering Database Objects

Hiding the Object Selection pane

Selecting a Database Object

About Creating New Database Objects

Managing Tables

Creating a Table

Browsing a Table

Summary of Available Views

Summary of Available Views

Editing a View

Editing a View Manually

Using Find and Replace

Summary of Available Views

Managing Sequences

Creating a Sequence

Browsing a Sequence

Summary of Available Views

Managing Types

Creating a Type

Browsing a Type

Summary of Available Views

Managing Packages

Creating a Package

Viewing a Package

Summary of Available Views

Editing a Package

Editing a Package Manually

Compiling a Package

Downloading a Package

Summary of Available Views

Editing a Procedure

Editing a Procedure Manually

Compiling a Procedure

Downloading a Procedure

Summary of Available Views

Editing a Function

Editing a Function Manually

Compiling a Function

Downloading a Function

Summary of Available Views

Editing a Trigger

Editing a Trigger Manually

Compiling a Trigger

Downloading a Trigger

Dropping a Trigger

Managing Database Links

Creating a Database Link

Browsing a Database Link

Summary of Available Views

Managing Materialized Views

Creating a Materialized View

Browsing a Materialized View

Summary of Available Views

19 Using the SQL Script Repository

About the SQL Script Repository

Accessing the SQL Script Repository

About the SQL Scripts Home Page

About the Tasks List

Creating a SQL Script

Creating a SQL Script in the Script Editor

Uploading a SQL Script

Using the Script Editor

Editing a SQL Script

About the Script Editor

Deleting a SQL Script

Deleting Scripts from the SQL Scripts Home Page

Deleting a Script in the Script Editor

Copying a SQL Script

Executing a SQL Script

Executing a SQL Script in the Script Editor

Executing a SQL Script from the SQL Scripts Home Page

About the Run Script Page

Viewing the Status of a Long Running Script

Viewing SQL Script Results

Viewing Script Results

About the Manage Script Results Page

About the Results Page

Transferring SQL Scripts between Workspaces

Copying Scripts to an Export Script

About the Scripts Pane

About the Scripts to Export Pane

Importing Scripts from an Export Script

About the Import Scripts Pane

Viewing Script and Result Quotas

20 Using SQL Command Processor

About the SQL Command Processor

Accessing the SQL Command Processor

About the SQL Command Processor Home Page

About the Results Tab

About the Explain Tab

About the Describe tab

About the Saved SQL tab

About the History tab

Executing a SQL Command

About Transactions in the SQL Command Processor

About Unsupported SQL*Plus Commands

About Command Termination

Accessing Saved Commands

About the Saved SQL Pane

Using SQL Command History

Accessing a Command from Command History

About the History Pane

Displaying Results

About the Results Pane

Using Explain Plan

Viewing an Explain Plan

About Explain Plan Pane

21 Using SQL Workshop Utilities

Importing and Exporting Data To and From the Database

Accessing the Data Import/Export Page

Importing Data

Importing a Text File

Importing an XML Document

Importing Spreadsheet Data

Viewing the Import Data Repository

Exporting Data

Exporting to a Text File

Exporting to an XML Document

Using Text Data Import Repository

Generating DDL

Viewing Object Reports

Viewing All Objects Reports

Accessing the Data Dictionary

Viewing PL/SQL Reports

Viewing Program Unit Arguments

Viewing Unit Line Counts

Searching PL/SQL Source Code

Viewing Security Reports

Viewing Role Privileges

Viewing Object Grants

Viewing Column Privileges

Evaluating an Application for SQL Injection Vulnerability

Viewing Details about the Tables in Your Database

Monitoring the Database

Monitoring Database Activity

Monitoring Database Storage

Monitoring Database Configuration

Using the Recycle Bin to View and Restore Dropped Objects

Managing Objects in the Recycle Bin

Emptying the Recycle Bin

Part IV Administration

22 Managing an Oracle HTML DB Hosted Service

What Is an Oracle HTML DB Administrator?

Logging in to Oracle HTML DB Administration Services

Managing Schemas

Determining the HTML DB Engine Schema

Understanding Oracle Default Schema Restrictions

Granting the Privilege to Assign Oracle Default Schemas

Revoking the Privilege to Assign Oracle Default Schemas

Working with Restricted Schemas

Determining the Privilege Status

Managing Workspace to Schema Assignments

Viewing Workspace to Schema Assignments

Provisioning Workspaces

About Workspace Provisioning

Specifying a Provisioning Mode

Creating a Workspace Manually

Viewing Workspace Reports

Managing Service Requests

Viewing a Pending Service Request

Viewing a Pending Service Request on the Notifications List

Viewing Requests from the Service Requests Page

Approving or Declining a Pending Service Request

Changing an Existing a Service Request

Deleting a Service Request

Managing Change Requests

Viewing a Pending Change Request

Viewing a Pending Change Request from the Notifications List

Viewing a Change Request from the Workspace Utilization Report

Viewing Requests from the Change Requests Page

Approving or Declining a Pending Change Request

Managing Users in an Oracle HTML DB Instance

Creating New User Accounts

Editing an Existing User Account

Managing Existing Workspaces

About Purging Inactive Workspaces

Identifying Inactive Workspaces

Removing the Resources Associated with Inactive Workspaces

Deleting Inactive Workspaces

Removing a Workspace

Exporting and Importing a Workspace

Managing Logs

Deleting SQL Workshop Logs

Deleting Page View Activity Log Entries

Deleting Developer Activity Log Entries

Deleting Click Counting Log Entries

Deleting the HTML DB Mail Log Entries

Managing Session State

Purging Sessions by Age

Viewing Session Details Before Purging

Viewing Session Statistics Before Purging

Monitoring Activities

Managing Environment Settings

Viewing Current Environment Settings

Controlling PL/SQL Program Unit Editing

Including Demonstration Applications in a New Workspace

Configuring Oracle HTML DB to Send Mail

Configuring SQL Workshop

Enabling Database Monitoring

Configuring Security Settings

Disabling Access to Oracle HTML DB Administration Services

Disabling Access to Oracle HTML DB Internal Applications

Restricting User Access by IP Address

Managing Applications

Changing Application Build Status

Viewing the Application Attributes Report

Viewing the Parse As Schemas by Application Report

Managing E-mail

Viewing the Mail Queue

Viewing the HTML DB Mail Log

Creating a Site-Specific Tasks List

Adding a New Task

Editing an Existing Task

Deleting a Task

A Available Conditions

Conditions Available in Oracle HTML DB

Contents