Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience
Documentation Accessibility
Related Documents
Conventions

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
Tabs
Lists of Values
Breadcrumbs
Lists
Theme
Templates
Security
Navigation Bar
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
APP_ALIAS
APP_ID
APP_IMAGES
APP_PAGE_ID
APP_SESSION
APP_UNIQUE_PAGE_ID
APP_USER
AUTHENTICATED_URL_PREFIX
BROWSER_LANGUAGE
CURRENT_PARENT_TAB_TEXT
DEBUG
HOME_LINK
LOGIN_URL
IMAGE_PREFIX
HTML DB SCHEMA OWNER
PRINTER_FRIENDLY
LOGOUT_URL
PROXY SERVER
PUBLIC_URL_PREFIX
REQUEST
SQLERRM
SYSDATE_YYYYMMDD
WORKSPACE_IMAGES

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
Name
Display Attributes
Header and Footer
HTML Header
On Load
Security
Duplicate Submission
Configuration
On Error Text
Help
Comments
About Page Rendering Controls
Regions
Buttons
Items
Page Computations
Page Processes
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
Page Events
Objects
History
Export
Groups
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
Tabs
Trees
Themes
Templates
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
Calendar Display
Calendar Interval
Column Link
Day Link
Creating Charts
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
Search
Subscription
Utilization
History
Using Shortcuts
About Shortcut Types
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
Utilization
Unused
History
Creating Trees
Creating a Tree
Editing a Tree
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
Label Default
Report Defaults
Tabular Form Default
Form Defaults
About List of Values
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
URL_ENCODE Function
HTMLDB_MAIL
SEND Procedure
PUSH_QUEUE Procedure
HTMLDB_ITEM
CHECKBOX Function
DATE_POPUP 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
LOGIN Procedure
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
Editing a Table
Managing Views
Creating a View
Browsing a View
Summary of Available Views
Editing a View
Editing a View Manually
Using Find and Replace
Downloading a View
Compiling a View
Dropping a View
Managing Indexes
Creating an Index
Browsing an Index
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
Dropping a Package
Managing Procedures
Creating a Procedure
Browsing a Procedure
Summary of Available Views
Editing a Procedure
Editing a Procedure Manually
Compiling a Procedure
Downloading a Procedure
Dropping a Procedure
Managing Functions
Creating a Function
Browsing a Function
Summary of Available Views
Editing a Function
Editing a Function Manually
Compiling a Function
Downloading a Function
Dropping a Function
Managing Triggers
Creating Triggers
Browsing a Trigger
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
Managing Synonyms
Creating Synonyms
Viewing a Synonym
Dropping a Synonym

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
Using Bind Variables
Saving a SQL Command
Copying a Command
Using Saved Commands
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
Sessions
System Statistics
Top SQL
Long Operations
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

Index