Skip Headers
Oracle® HTML DB User's Guide
Release 2.0

Part Number B16373-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

2 Quick Start

This section offers a quick introduction to using Oracle HTML DB. It is assumed you have already completed the installation process.

This section contains the following topics:

Understanding Oracle HTML DB User Roles

To access the Oracle HTML DB development environment, users log in to a shared work area called a workspace. Users are divided into three primary roles:

Logging In to Oracle HTML DB

When you log in to Oracle HTML DB you log in to a workspace. A workspace is an area within the Oracle HTML DB development environment where developers can create applications.

How you log into Oracle HTML DB depends upon whether you have configured your development environment:

Topics in this section include:

About Browser Requirements

You open the Oracle HTML DB home page in a Web browser. To view or develop Oracle HTML DB applications, the Web browser must support Java Script and the HTML 4.0 and CSS 1.0 standards. The following browsers meet this requirement:

  • Netscape Communicator 7.0 or higher

  • Microsoft Internet Explorer 5.5 or higher

  • Mozilla 1.2 or higher

  • Mozilla Firefox 1.0 or higher

Configuring Your Oracle HTML DB Environment

Once you have successfully installed Oracle HTML DB, you need to configure your development environment as follows:


Note:

Before performing any of the previous steps, please review "Managing an Oracle HTML DB Hosted Service"

Logging In to Oracle HTML DB as a Developer

When you log in to Oracle HTML DB, you log in to a workspace. If you are a developer, an administrator must grant you access to a workspace.


Note:

Before users can request a workspace or change their passwords, an Oracle HTML DB administrator must configure Oracle HTML DB environment preferences.

Topics in this section include:

Requesting a Workspace


Note:

This section applies only if your Oracle HTML DB administrator has configured Oracle HTML DB to support workspace requests.

Before you can log in to Oracle HTML DB, an administrator must grant you access to a workspace. Each workspace has a unique ID and name.

To request a workspace:

  1. In a Web browser, navigate to the Oracle HTML DB Login page. By default, Oracle HTML DB installs to the following location:

    http://hostname:port/pls/database_access_descriptor
    
    

    Where:

    • hostname is the name of the system where Oracle HTTP Server is installed.

    • port is the is the port number assigned to Oracle HTTP Server.

      In a default installation, this number is 7777. You can find information about your Oracle HTTP Server installation's port number from the httpd.conf file, located in ORACLE_BASE\ORACLE_HOME\Apache\Apache\conf, by searching for Port.

      You can also find the port number in the portlist.ini file, located in ORACLE_BASE\ORACLE_HOME\install. However, be aware that if you change a port number, it is not updated in the portlist.ini file, so you can only rely on this file immediately after installation.

    • database_access_descriptor describes how Oracle HTTP Server connects to the database server so that it can fulfill an HTTP request. The default value is htmldb.


    See Also:

    ORACLE_BASE\ORACLE_HOME\Apache\modplsql\conf\dads.readme for more information on database access descriptors

    The Login page appears.

  2. Under Tasks, click Request a Workspace.

    The Request Service Wizard appears.

  3. Click Continue and follow the on-screen instructions.

Logging in to a Workspace

After an Oracle HTML DB administrator approves a workspace request and an e-mail arrives with your login credentials (the workspace name, user name, and password).

To log in to Oracle HTML DB:

  1. In a Web browser, navigate to the Oracle HTML DB Login page. By default, Oracle HTML DB installs to the following location:

    http://hostname:port/pls/htmldb/htmldb
    
    

    The Login page appears.

  2. Under Login, enter the following:

    • In the Workspace field, enter the name of your workspace.

    • In the Username field, enter your user name.

    • In the Password field, enter your case-sensitive password.

  3. Click Login.

Resetting Your Password

You can reset your password by clicking the Change Password link on the Oracle HTML DB home page.

To reset your password:

  1. Log in to Oracle HTML DB. See "Logging In to Oracle HTML DB".

  2. Click the Administration icon.

  3. Select Change Password from the Tasks list.

  4. In Change Password, enter the following:

    • In the Password field, enter your new password.

    • In the Confirm Password field, enter your new password again.

    • Click Apply Changes.

Logging Out of a Workspace

To log out of Oracle HTML DB, click the Logout icon in the upper right corner of the window.

About the Oracle HTML DB User Interface

Once you log in to Oracle HTML DB, the Workspace home page appears.

Figure 2-1 Workspace Home Page

Description of htmldb.gif follows
Description of the illustration htmldb.gif

The Workspace home page contains three components:

Navigation Alternatives

You can move between pages in Oracle HTML DB by clicking large graphical icons such as the Application Builder icon, SQL Workshop icon, or Workspace Administration icon on the Workspace home page. When using these icons, you have two navigation options:

  • Primary Navigation (drill-down). Click the large icons in the center of the page to drill-down to the appropriate page.

  • Secondary Navigation (pull-down menus). Click the down arrow on the right side of the icon to view a pull-down menu. Select an option from the menu.


Note:

For the purposes of consistency, this document uses the primary navigation path (or dill-down approach) when explaining navigation.

Navigating Using Breadcrumbs

Breadcrumbs (also called locator links) appear at the top of every page in Oracle HTML DB. Each breadcrumb entry indicates where the current page is relative to other pages within the Oracle HTML DB development environment. You can use breadcrumbs to instantly link to a previous page. For example, clicking on Home takes you to the Workspace home page.

Accessing Online Help

Oracle HTML DB feature three types of online help:

  • Page-level Help

  • Procedural online Help

  • Field-level Help

Page-Level Help

Many pages in Oracle HTML DB include page-level Help. Page-level Help displays in a text box on the right side of the page and offers a brief description of the page functionality.

Procedural Online Help

You can access an HTML-based online Help system by clicking the Help icon in the upper right corner of the window. Context sensitive help that describes the current page appears. If a context-sensitive topic is not available, the Contents window appears.

The top of the window features a gray bar. Click Find to perform a keyword search of the entire help system. When the search field appears, enter a case insensitive query in the field provided and click Find. To search for an exact phrase, enclose the phrase in double quotation marks.

Field Level Help

Most select lists, check boxes, and fields in Oracle HTML DB include item help. When item help is available, the item label changes to red when you pass your cursor over it. Click the item label to display a description in a separate window.

Creating an Application Using a Wizard

A quick way to make data in the Oracle database accessible to end users is to run the Create Application Wizard. You can access the wizard by clicking the Create button on the Application Builder home page. The procedure that follows describes how to create an application based on an the EMP table.

To create an application based on an existing table:

  1. Log in to Oracle HTML DB. See "Logging In to Oracle HTML DB".

    The Workspace home page appears.

  2. Click the Application Builder icon.

  3. Click the Create button.

  4. Select Create Application and click Next.

    Next, specify a name and select a schema.

  5. For Name:

    1. In Name, enter MyApp.

    2. From Schema, select the appropriate schema.

    3. Accept the remaining defaults and click Next.

    Next, add pages to your application.

  6. Under Add Page:

    1. For Select Page Type, select Report.

      Notice that Action describes the type of page you are adding.

    2. From Table or View, select EMP.

    3. (Optional) To create additional summary reports and charts, select the Include Analysis Pages check box and follow the wizard prompts.

    4. Click Add Page.

      The new page (or pages) appears at the top of the page. To delete a page, click [delete].

    5. Click Next.

  7. For Tabs, accept the default and click Next.

  8. For Shared Components, accept the default and click Next.

    This option enables you to import shared components from another application. Shared components are common elements that can display or be applied on any page within an application.

  9. For Authentication Scheme, Language, and User Language Preference Derived From, accept the defaults and click Next.

  10. Select a theme and click Next.

    Themes are collections of templates that can be used to define the layout and style of an entire application.

  11. Confirm your selections. To return to a previous wizard page, click Previous. To accept your selections, click Create.

Running an Application

To view a rendered version of an application, you run or submit it to the HTML DB engine. As you create new pages you can run them individually, or run an entire application. You can run a page from numerous locations within Application Builder by clicking the Run Application icon. The Run Application icon resembles a traffic light.

To run an application:

  1. Navigate to the Workspace home page.

  2. Click the Application Builder icon.

    The Application Builder home page appears.

  3. Select an application (for example, MyApp).

  4. Click the Run Application icon.

    The Login page appears.

  5. Log in to your application by enter your workspace username and password and click Login.

    Your application appears. Note the Developer toolbar at the bottom on the page. The Developer toolbar offers a quick way to edit the current page, create a new page, control, or component, view session state, or toggle edit links on an off.

  6. Explore your application.

  7. To exit your application and return to Application Builder, click Edit Page on the Developer toolbar.

    The Page Definition appears.

    A page is the basic building block of an application. You use the Page Definition to view, create, and edit the controls and components that define a page.

  8. To return to the Application Builder home page, select the Application Builder breadcrumb.