2 Quick Start

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

This section contains the following topics:

Understanding Oracle HTML DB User Roles
Logging in to Oracle HTML DB
About Oracle HTML DB User Interface
Creating an Application Using the Create Application Wizard

See Also:

Understanding Oracle HTML DB User Roles

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

Developer
Workspace administrator
Oracle HTML DB administrator

A developer can create and edit applications. A Workspace administrator performs administrator tasks specific to their workspace. An Oracle HTML DB administrator manages an entire Oracle HTML DB development environment instance.

See Also:

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 multiple developers can create applications.

Topics in this section include:

Requesting a Workspace
Logging in to a Workspace
Resetting Your Password
Logging Out of Your Workspace

Note:

Before users can request a workspace or change their passwords, an Oracle HTML DB administrator must configure the engine settings.

See Also:

"Managing Engine Settings"

Requesting a Workspace

Note:

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

See Also:

"Specifying a Provisioning Mode" for more information on enabling workspace requests

Before you can log in Oracle HTML DB, you must request a workspace. Each workspace has a unique ID and name. Only an administrator with the appropriate credentials can create a new workspace.

To request a workspace:

In a Web browser, navigate to the Oracle HTML DB Login page. By default, Oracle HTML DB installs to the following location:
```
http://server:port/pls/Database Authentication Descriptor/htmldb
```
The Login page appears.
Under Tasks, click Request a Workspace.

The Request Service Wizard appears.
Click Continue and follow the on-screen instructions.

See Also:

"Creating a Workspace"

Logging in to a Workspace

Once your workspace request has been approved, an Oracle HTML DB administrator provides you with a workspace name, username, and password.

To log in to Oracle HTML DB:

In a Web browser, navigate to the Oracle HTML DB Login page. By default, Oracle HTML DB installs to the following location:
```
http://server:port/pls/Database Authentication Descriptor/htmldb
```
The Login page appears.
Under Login, type the following:
- In Workspace, type the name of your workspace.
- In Username, type a username.
- In Password, type a case sensitive password.
Click Login.

Resetting Your Password

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

To reset your password:

In a Web browser, navigate to the Oracle HTML DB Login page. By default, Oracle HTML DB installs to the following location:
```
http://server:port/pls/Database Authentication Descriptor/htmldb
```
Under Tasks, click Reset Password.
Type you workspace name and e-mail address and click Reset Password. A new password is sent to your e-mail address.

Logging Out of Your Workspace

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

About Oracle HTML DB User Interface

Once you log in to Oracle HTML DB, the Oracle HTML DB Home page appears as shown in Figure 2-1.

Figure 2-1 Oracle HTML DB Home Page

Description of the illustration htmldb.gif

The Oracle HTML DB development environment consists of three components:

Application Builder. Use Application Builder to assemble an HTML interface (or application) on top of a database objects such as tables and procedures.
SQL Workshop. Use SQL Workshop to view and manage database objects from a Web browser.
Data Workshop. Use Data Workshop to import data into and export from the hosted database.

To access any of these components, click the large icons in the center of the page, or click the navigation bar icons in upper right corner. Use Administration to access the Administration Services page.

See Also:

About Using the Tasks List

Many Oracle HTML DB pages feature a Tasks list on the right side of the page. Select a list item to quickly link to common procedures.

Other Sources of Information

Most 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. Oracle HTML DB also includes two other forms of online help:

Procedural online help. You can access an HTML-based online help system by clicking the Help navigation bar icon.
Field level help. Most lists of values, select lists, check boxes, and fields in Oracle HTML DB include item help. When item help is available, the item label appears highlighted when you pass your cursor over it. Clicking the item label displays a a description in a separate window.

Creating an Application Using the Create Application Wizard

A quick way to make data in the Oracle database accessible to an end user is to run the Create Application Wizard. This wizard creates a basic application which contains up to five pages and includes:

a home page with a menu
a searchable report
an edit page
an insert page
a charting page

The Create Application Wizard assumes you have a single table or several unrelated tables for which you want to create a report or update and insert data. Once the application is generated, you can modify it using Application Builder.

To create an application using the Create Application Wizard:

Log in to Oracle HTML DB as described in "Logging in to Oracle HTML DB".
Click the Build navigation bar icon in the upper right corner of the window. (See Figure 2-2.)

Figure 2-2 Build Navigation Bar Icon

Description of the illustration htmldb_bldico.gif

Application Builder appears.
Click Create Application. (See Figure 2-3.)

Figure 2-3 Create Application

Description of the illustration create.gif

Create Application Wizard appears.
Under Select Creation Method, click Based on Existing Tables and click Next.

Selecting this option creates a complete application based on existing tables you specify. Selecting the default options results in an application that includes a menu, breadcrumb menus, report page, form page, and a chart page.
Select the tables or views on which your application will be based and click Next.

Each application is based on a table or view owned by a specific database schema.
Specify an Application Name.
If appropriate, select the following options and click Next:
- Include Breadcrumb Navigation Aids
- Hide Primary Key in Report Page

Confirm your selections and click Finish.

A Confirmation page appears, displaying two icons:

Run Application
Edit Application

See Also:

"Running Your Application" for more information on running your application from the Quick Application Confirmation page
"Running a Page" for information on running an application from Application Builder
"Editing Application Attributes" for more information on application attributes

Running Your Application

You can run your application by clicking the Run Application icon on the Quick Application Confirmation page.

To run your application from the Quick Application Confirmation page:

Click Run Application.

The Login page appears.
Log in to your application by typing your workspace username and password and clicking Login.

Your application appears. Note the Developer toolbar at the bottom on the page (See Figure 2-4).

Figure 2-4 Application Builder Developer Toolbar

Description of the illustration d_toolbar.gif

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.
Explore your application.
To exit your application and return to Application Builder, click Edit Page on the Developer toolbar.

As shown in Figure 2-5, the Page Definition appears.

Figure 2-5 Page Definition

Description of the illustration pg_def.gif

A page is the basic building block of an application. You use the Page Definition to view, create, and edit the components that define a page.
To return to Application Builder home page, select the Application tab.

See Also: