5 Building an Application

About Creating an Application Using a Wizard

When you click Create on the Application Builder home page, you must choose one of the following options:

• Create Application. Creates an application. The application can be based on SQL queries or database tables. You can define blank pages or pages that contain reports, forms, tabular forms, or a report with a linked form. See "About the Create Application Wizard".

• Create Application from Spreadsheet. Creates an application based on spreadsheet data. You can upload or paste spreadsheet data to create a table and then add a user interface. In the resulting application, users can create queries, add, insert, or update records, or analyze the data. See "About the Create Application from Spreadsheet Wizard".

• Demonstration Application. Installs or uninstalls demonstration applications. Use demonstration applications to learn how to build applications. See "About Demonstration Applications".

About the Create Application Wizard

The Create Application wizard enables you to create a fully functional application based on any number of tables. You can use the Create Application Wizard to create blank pages, or pages based on SQL queries or database tables. You can create SQL queries by manually typing SQL, or by using the graphical user interface of Query Builder.

Applications based on tables can consist of a simple report, a form and report, or a tabular form. When creating pages on tables, you have the option to generate analysis pages. Analysis pages extend a simple report or a report on a form to include multiple drill-down reports and charts.

At the workspace level, you have the option of setting defaults that are used for applications built in that workspace. Setting these defaults enables you to exit the wizard without paging through each step. When you exit the wizard, the application you create uses the values you specified as defaults.

Topics in this section include:

• 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

You can create an application based on spreadsheet data by selecting Create from Spreadsheet in the Create Application Wizard.

To create an application from spreadsheet data:

1. On the Workspace home page, click the Application Builder icon.

2. Click the Create button.

3. Select Create from Spreadsheet.

4. For Load Method, specify how spreadsheet data will be uploaded. Select one of the following and click Next:

   1. Upload file, comma separated (*.csv) or tab delimited. Specify the following and click Next:

      • Text File - Click Browse to locate the file to be uploaded.

      • Separator - Specify the column separator character. Use \t for tab separators.

      • Optionally Enclosed By - Enter a delimiter character. You can use this character to deliminate the starting and ending boundary of a data value. If you specify a delimiter character, the wizard ignores white space occurring before the starting and ending boundary of a data value. You can also use this option to enclose a data value with the specified delimiter character.

      • File Character Set - Choose the character set in which the text file is encoded.

   2. Copy and paste (up to 30KB). Copy and paste the spreadsheet data you wish to import and click Next.

5. For Table Properties, review how your table will display and click Next. Specify the table name and column names, or modify the data types. To specify whether or not to include a column, make a selection from the Upload list.

6. For User Interface Defaults:

   1. Review the displayed Singular Name and enter a Plural Name.

   2. (Optional) Under Column User Interface Defaults, review the displayed column labels.

   3. Click Next.

7. For Summary By Column, select the columns for which data will be summarized in reports and charts and click Next.

8. For Application Options, specify the following:

   1. Application Name - Enter an alphanumeric name for this application.

   2. Create Mode:

      • Read and Write includes insert and update pages.

      • Read Only does not include insert and update pages.

   3. Select a chart type.

   4. Click Next.

9. For User Interface Theme, 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. See "Managing Themes".

10. Confirm your selections and click Create.

About Demonstration Applications

Oracle Application Express installs with a number of demonstration applications. Use these applications to learn more about the different types of functionality you can include in your applications.

Copying an Application

To copy an application:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

   The Application home page appears.

3. Click Copy this Application on the Tasks list. See "About the Tasks List".

4. On Copy Application:

   1. Enter a new application ID.

   2. Enter a new application name.

   3. Specify whether or not to copy deployment attributes.

   4. Click Next.

5. Click Copy Application.

Deleting an Application

You can delete an application from within Application Builder, or while editing application attributes. If you delete an application you also delete all defined components (reports, charts, or forms), page controls (buttons, items, list of values), and shared components (breadcrumbs, lists, and tabs, but not user interface defaults).

Topics in this section include:

• Deleting an Application from Application Builder

• Deleting an Application from the Edit Definition Page

About Creating Pages

You add a new page or add a component to an existing page by running the Create Page Wizard. You can access this wizard by:

• Clicking Create Page on the Application home page. See "Creating a Page from the Application Home Page".

• Clicking Create on the Page Definition. See "Creating a Page from the Page Definition".

• Click the Create link on the Developer toolbar and then select New Page. "Creating a Page from the Developer Toolbar".

Creating a Page from the Application Home Page

To create a new page from the Application home page:

1. On the Workspace home page, click Application Builder.

2. Select an application.

   The Application home page appears.

3. Click the Create Page button.

4. Select the type of page you want to create as described in the following table.

   Page Type	Description
   Blank Page	Creates a blank page.
   Multiple Blank Pages	Creates multiple blank pages.
   Report	Formatted result of a SQL query. Available options: Wizard Report - Creates a report without requiring any SQL knowledge. Select the appropriate schema, table, columns, and result set display. SQL Report - Creates a report based on a custom SQL SELECT statement or a PL/SQL function returning a SQL SELECT statement that you provide. See Also: "Creating Reports"
   Chart	Enables you to create three types of graphical charts: HTML, Scalable Vector Graphics (SVG), and Flash. See Also: "Creating Charts"
   Form	Creates a form interface with which users can update a single row or multiple rows within a table. See Also: "Creating Forms"
   Wizard	Create a wizard.
   Calendar	Generates a calendar with monthly, weekly, and daily views. See Also: "Creating Calendars"
   Tree	Creates a a tree to graphically communicate hierarchical or multiple level data. See Also: "Creating Trees"
   Login Page	Creates a login page. See Also: "Building a Login Page"
   Access Control	Creates a page containing a access control list, enabling developers to control access to an application, individual pages, or page components. See Also: "Controlling Access to Applications, Pages, and Page Components"

   
   

5. Follow the on-screen instructions.

About the Run Application and Run Page Icons

The Run Application icon resembles a large traffic light and displays on the Application home page. Clicking the Run Application icon runs an entire application.

The Run Page icon resembles a small, light green traffic light and displays in the upper right corner of many pages within Application Builder. Clicking the Run Page icon runs the current page.

Running an Application from the Application Builder Home Page

To run an entire application from the Application Builder home page:

1. On the Workspace home page, click the Application Builder icon.

2. From the View list, select Details and click Go.

3. Locate the application in the Applications list.

4. Click the Run icon in the far right column.

Running an Application from the Application Home Page

To run an entire application from the Application home page:

1. On the Workspace home page, click the Application Builder icon.

   The Application Builder home page appears.

2. Select on application.

3. Click the Run Application icon at the top of the page.

Running a Page on the Application Home Page

You can control how the Application home page displays by making a selection from the View list on the navigation bar at the top of the page. Selecting Details displays each page as a line in a report. Each line includes the page number, the page name, when the page was last updated, who last updated the page, a lock icon, and a Run icon.

To run a page from the Pages list:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. From the View list, select Details and click Go.

4. From the Pages list, locate the page you want to run and click the Run icon in the far right column.

Running a Page from the Page Definition

To run a specific page from the Page Definition:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. Select a page.

   The Page Definition appears.

4. Click the Run Page icon in the upper right corner of the page.

Viewing the Page Groups

The section describes different ways to view page groups.

Creating a Page Group

To create a page group:

1. On the Workspace home page, click the Application Builder icon

2. Select an application.

3. On the Tasks List on the right side of the page, click Page Groups.

4. On the Page Groups page, click Create.

5. Enter a name, a description (optional), and click Create.

Assigning a Page to a Page Group

To assign pages to a group:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. On the Tasks List on the right side of the page, click Page Groups.

4. On the Tasks list, click Report Unassigned Pages.

   The Unassigned Pages report appears. Clicking a page number takes you to the Page Attributes page. Clicking the page Name links to the Page Definition.

5. From the Page Group list, select a group to which you want to assign pages and click Go.

6. Select the pages to be assigned and click Assigned Checked.

Removing a Page from a Page Group

You remove a page from a page group on the Page Definition.

To remove a page to a page group:

1. Navigate to the appropriate Page Definition. See "Accessing a Page Definition" or "Viewing the Pages by Page Group Report". In both page group reports, you can link to the Page Definition by clicking the page Name.

   The Page Definition appears.

2. Under Name, locate the Group list and select - No Group Assigned -.

3. Click Apply Changes.

Removing a Page Group

To remove a page group:

1. Reassign all pages to another page group. See "Reassigning a Page to a Another Page Group".

2. On the Tasks List on the right side of the page, click Edit Group Definition.

3. Click Delete.

   A confirmation page appears.

4. Confirm your request.

Viewing the Pages by Page Group Report

To view pages by page group:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. On the Tasks List on the right side of the page, click Page Groups.

4. On the Tasks list, click Report Page Groups.

   The Pages by Page Group report appears. Clicking the page number takes you to the Page Attributes page. Clicking the page Name links to the Page Definition.

5. To view a page group, make a selection from the Group list and click Go.

Determining If a Page Is Locked

A lock icon indicates whether a page is currently locked. If a page is unlocked, the icon appears as an open padlock. If the page is locked, the icon appears as a locked padlock. A lock icon appears on the Application home page and on the Page Definition.

To view the lock icon on the Application home page, select Details from the View list. A list of pages appears. The lock icon appears under the Lock column.

The lock icon also appears on the Action Bar on the Page Definition. See "About the Action Bar".

Locking a Page

You can lock pages from the Page Locks page, the Pages list, and from a Page Definition.

Unlocking Pages

Only the developer who locked a page can unlock it. However, a developer with administrative privileges can unlock pages locked by other developers.

Accessing Alternative Locked Pages Views

You can access a number of different views of Locked Pages on the Locked Pages page.

To access different views of locked pages:

1. On the Workspace home page, click the Application Builder icon.

2. Select the application.

3. On the Tasks List on the right side of the page, click Page Locks.

4. On the Tasks list, click one of the following:

   • Show Locked Pages displays only locked pages within the current application.

   • Show All Pages displays all pages within the current application.

   • Show Unlocked Pages displays only unlocked pages within the current application.

   • Administer Locks enables an administrator to unlock any pages locked by a developer.

Deleting a Page from the Page Definition

To delete a page from the Page Definition:

1. Navigate to the appropriate Page Definition. See "Accessing a Page Definition".

2. Verify the page name.

3. Click the Delete button at the top of the page.

4. Follow the on-screen instructions.

Deleting a Page While Editing Page Attributes

To delete a page while editing page attributes:

1. Navigate to the Page Definition. See "Accessing a Page Definition".

2. Under Page Rendering, locate the Page section.

3. Click the Edit page attributes icon to link to Page Attributes page. This icon resembles a small page with a pencil on top of it.

   
   Description of the illustration pg_def_edit_pg_att.gif
   
   

   The Edit Page appears.

4. Verify the page number and page name.

5. Click Delete.

6. Follow the on-screen instructions.

Creating an Application Comment

To create an application comment:

1. Navigate to the Workspace home page.

2. Click the Application Builder icon.

3. Select an application.

4. On the Application home page, click Shared Components.

   The Shared Components page appears.

5. Under Application, click Application Comments.

   The Application Comments page appears.

6. Enter comments in the Comments field and click Apply Changes.

Viewing the Application Comments Report

To view reports specific to an application:

1. Navigate to the Workspace home page.

2. Click the Application Builder icon.

3. Select an application.

   The Application home page appears.

4. On the Tasks list, click Application Reports.

5. Click Application and then Application Comments.

Adding Developer Comments to an Application or Page

The Developer Comment icon displays on any page in Application Builder that is related to a specific application or application page. You can add developer comments to an application, a page, or a group of pages.

To add a developer comment:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. Click the Developer Comment icon.

   The Create Comment page displays in a separate window.

4. In Relevant Page(s), specify the pages to which the comment applies. To enter a comment that:

   • Applies to a specific page, enter the page number.

   • Applies to multiple pages, enter a comma-delimited list of pages. For example:

     1, 2, 3 
     

   • Does not apply to a page or group of pages, leave this field blank.

5. In Comment, enter up to 4000 characters of text.

6. Click Create or Create Another.

Viewing and Editing Developer Comments

To edit a developer comment:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. Click the Developer Comment icon.

   The Create Comment page displays in a separate window.

4. Click View Comments.

   The View Comments page appears. See "About the Navigation Bar on the View Comments Page".

5. To edit a comment, click the Edit icon.

   The Edit Comment page appears.

   1. In Relevant Page(s), specify the pages to which the comment applies. To enter a comment that:

      • Applies to a specific page, enter the page number.

      • Applies to multiple pages, enter a comma-delimited list of pages. For example:

        1, 2, 3 
        

      • Does not apply to a page or group of pages, leave this field blank.

   2. In Comment, enter up to 4000 characters of text.

6. Click Apply Changes.

Deleting Developer Comments

You can delete developer comments on the Edit Comment page or on the Manage Comments page.

Topics in this section include:

• Deleting a Specific Developer Comment

• Deleting Multiple Developer Comments

About the Developer Comments Report

You can also view, edit, and manage developer comments from the Developer Comments report.

Topics in this section include:

• Accessing the Developer Comments Report

• Editing Comments from the Developer Comments Report

• Deleting a Comment from the Developer Comments Report

• Deleting Multiple Comments from the Developer Comments Report

• Downloading the Developer Comments Report

Creating a Report Using a Wizard

Application Builder includes a number of built-in wizards for generating reports.

To create a report using a wizard:

1. On the Workspace home page, click the Application Builder icon.

2. Select the application.

3. Click Create Page.

4. Select Report.

5. Select a report type:

   • Wizard Report - Creates a report without requiring any SQL knowledge. Select the appropriate schema, table, columns, and result set display.

   • SQL Report - Creates a report based on a custom SQL SELECT statement or a PL/SQL function returning a SQL SELECT statement that you provide.

   • Report on collection containing Web service result - Creates a report based on a Web service result.

6. Follow the on-screen instructions. To learn more about a specific field, click the item label.

   When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See "About Field-Level Help".

Editing Report Attributes

You can use the Report Attributes page to precisely control report layout, pagination, column sorting, error messages, export links, and column breaks.

Topics in this section include:

• Accessing the Report Attributes Page

• About Navigation Alternatives

Accessing the Report Attributes Page

You can access the Report Attributes page by clicking the Report link next to the report region you want to edit on the Page Definition. You can also navigate to the Report Attributes page by clicking the region name and then selecting the Report Attributes tab.

Description of the illustration rprt_edit.gif

To access the Report Attributes page:

1. On the Workspace home page, click the Application Builder icon.

2. Select the application.

3. Select a page.

   The Page Definition appears.

4. Under Regions, click Report next to the name of the report region you want to edit.

   The Report Attributes page appears and is divided into the following sections:

   • Column Attributes control the report layout. See "Altering Report Layout Using Column Attributes".

   • Layout and Pagination attributes control report pagination. See "Controlling Report Pagination".

   • Sorting attributes enable you to define images and image attributes for images that display in report headings to sort values. See "Enabling Column Sorting".

   • Messages contain attributes that enable you to define messages that display if no data is found or more data is found than can be displayed.

   • Report Export attributes enable you to add download link to a report or export a report as either an XML file or CSV file. See "Adding a Download Link to a Report" and "Exporting a Report as an XML Fileor a CSV File".

   • Break Formatting attributes enable you to control if a specific column repeats and how column breaks appear when printed. See "Controlling Column Breaks".

5. To learn more about a specific attribute, click the item label.

   When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See "About Field-Level Help".

6. Click Apply Changes.

See Also:

"Creating a Column Link" and "Defining an Updatable Column", and "Defining a Column as a List of Values", and "Controlling When Columns Display"

About Navigation Alternatives

The Report Attribute page is divided into these sections: Column Attributes, Layout and Pagination, Sorting, Messages, Report Export, Break Formatting, and External Processing.

You can access these sections by scrolling down the page, or by clicking a navigation button at the top of the page.

Description of the illustration rpt_att_nav.gif

When you select a button at the top of the page, the selected section appears and all other sections are temporarily hidden. To view all sections of the page, click Show All.

Altering Report Layout Using Column Attributes

You can use the Column Attributes section of the Report Attributes page to precisely control the report layout. For example, you can use these attributes to alter column heading text, change column positioning, hide a column, create a sum of a column, or select a sort sequence.

To access the Column Attributes:

1. On the Workspace home page, click the Application Builder icon.

2. Select the application.

3. Select a page.

   The Page Definition appears.

4. Under Regions, click Report next to the name of the report region you want to edit.

   The Report Attributes page appears with the Column Attributes section at the top of the page.

   
   Description of the illustration rpt_att.gif
   
   

   Use the Column Attributes section to control report column appearance and functionality.

   Heading Type identifies how the heading is generated for the report. The Link column indicates if a column link is currently defined. The Edit column indicates whether or not a column is currently updatable.

   Table 5-2 describes common report column edits.

   Table 5-2 Common Report Column Edits

   Description	Developer Action
   Alter column display sequence.	Click the up and down arrows to change the column display sequence.
   Alter heading alignment.	Under Column Alignment, select a new column alignment.
   Change column heading text.	Under Heading, enter different heading text.
   Control which columns display.	Click Show to indicate a column should display.
   Enable a unique sort sequence.	Click Sort and select a sequence number from Sort Sequence. Any number of columns can be sort enabled. However, at least one column must have a Sort Sequence defined.
   Enable the sum of a column.	Click Sum to enable the sum of a column.

   
   

   You can further refine the attributes of a specific column on the Column Attributes page.

5. To access the Column Attributes page, click the Edit icon next to the appropriate column Alias.

   To learn more about a specific attribute, click the item label.

   When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See "About Field-Level Help".

Controlling Report Pagination

You control report pagination by:

• Including a pagination substitution string in the report template

• Making selections from the Layout and Pagination section on the Report Attributes page

You control how pagination displays by making selections from the Layout and Pagination attributes on the Report Attributes page.

Topics in this section include:

• Accessing and Understanding Layout and Pagination Attributes

• Including Pagination After the Rows in a Report

• Including Pagination Before the Rows in a Report

Enabling Column Sorting

You enable column sorting on the Report Attributes page.

To enable column sorting:

1. Navigate to the Report Attributes page. See "Editing Report Attributes".

2. Under Column Attributes, select the Sort check box next to the columns to be sorted.

3. From Sort Sequence, select a sequence number.

   Sort Sequence is optional. However, if there are one or more sort enabled columns, then at least one column needs a defined Sort Sequence.

4. Scroll down to Sorting.

5. Specify ascending and descending image attributes or click set defaults.

Adding a Download Link to a Report

You can create a link within a report that enables users to export the report as a comma-delimited file (.csv) file. To add a CSV link to a report you need to enable the CSV output option. When using the CSV output option, the report template is not important. You can include a CSV link with any report template that has the CSV export substitution string defined.

Exporting a Report as an XML File or a CSV File

You can export a report as an XML file by selecting a report template.

To export a report as a file:

1. Navigate to the appropriate Report Attributes page. See "Editing Report Attributes".

2. Scroll down to Layout and Pagination.

3. From the Report Template list, select export: XML or export: CSV.

   Selecting export: XML prevents the Application Express engine from rendering the page and dumps the content to an XML file.

4. Click Apply Changes.

Creating a Column Link

Use the Column Link attributes to create a link from a report to another page in your application or to a URL.

To create a column link to another page:

1. Navigate to the appropriate Report Attributes page. See "Editing Report Attributes".

2. Under Column Attributes, locate the column to contain the link.

3. Click the Edit icon next to the column name.

   The Column Attributes page appears.

4. Scroll down to Column Link.

5. To create a column link to another page:

   1. From Target, select Page in this Application.

   2. (Optional) In Link Attributes, specify additional column link attributes that will be included in the <a href= > tag (for example, a link target, classes, or styles).

   3. In Link Text, enter the text to be displayed as a link, specify an image tag, or pick from the list of default images.

   4. In Page, specify the target page number. To reset the pagination for this page, select Reset Pagination.

   5. In Request, specify the request to be used.

   6. In Clear Cache, specify the pages (that is, the page numbers) on which to clear cache. You can specify multiple pages by listing the page numbers in a comma-delimited list.

   7. Use the Name and Value fields to specify session state for a specific item.

6. Click Apply Changes.

To create a column link to a URL:

1. Navigate to the appropriate Report Attributes page. See "Editing Report Attributes".

2. Access the Column Attributes page by clicking the Edit icon next to the appropriate column.

   The Column Attributes page appears.

3. Scroll down to Column Link.

4. Under Column Link, specify the following:

   1. From Target Type, select URL.

   2. In Link Text, enter the text to be displayed as a link and select a substitution string.

   3. (Optional) In Link Attributes, specify additional column link attributes that will be included in the <a href= > tag (for example, a link target, classes, or styles).

   4. In URL, enter the appropriate address.

5. Click Apply Changes.

Defining an Updatable Column

You can make a column updatable by editing Tabular Form Element attributes on the Column Attributes page. Note that the Application Express engine can only perform updates if:

• A multirow update is defined

• A PL/SQL process is implemented to process updated data

• When using the built-in tabular form elements and display types, then the report has to be defined using the type SQL Query (updatable report)

To define updatable column attributes:

1. Navigate to the appropriate Report Attributes page. See "Editing Report Attributes".

2. Access the Column Attributes page by clicking the Edit icon next to the appropriate column.

   The Column Attributes page appears.

3. Scroll down to Tabular Form Element.

4. Under Tabular Form Element, specify the following:

   1. Display As - Select a type of updatable column.

      Use this option to make a column updatable. Updates can only be performed if a multirow update is defined, or a PL/SQL process is implemented to process updated data.

   2. Date Picker Format Mask - Make a selection if you selected the Display As type of Date Picker.

   3. Element Width - Specify the width of the form item.

   4. Number of Rows - Specify the height of a form item (applicable to text areas).

   5. Element Attributes - Define a style or standard form element attribute.

   6. Element Option Attributes - Specify form element attributes for items in a radio group or check box.

   7. Primary Key Source Type - Identify the default type.

   8. Primary Key Source - Identify the default source.

      If the current column is part of the primary key defined in an MRU process, only the primary key source type and source appear.

      Otherwise, Default and Default Type appear. Use Default and Default Type to establish a relationship between two master records in a master detail form, or to set the default values for new rows.

   9. Reference Table Owner - Identify the owner of the referenced table. Use this attribute to build User Interface Defaults for reports.

   10. Reference Table Name - Identify the table or view that contains the current report column.

   11. Reference Column Name - Identify the column name that this report column references.

5. Click Apply Changes.

Defining a Column as a List of Values

Report columns can be rendered as lists of values. For example, a column can be rendered using a select list or a popup list of values. Or, a column can be rendered as read-only text based on a list of values.

This last approach is an effective strategy when creating display lookup values and is particularly useful in regular, nonupdatable reports. This approach enables you to display the value of a column without having to write a SQL JOIN statement.

To render a report column as a list of values:

1. Navigate to the appropriate Report Attributes page. See "Editing Report Attributes".

2. Access the Column Attributes page by clicking the Edit icon next to the appropriate column.

   The Column Attributes page appears.

3. Scroll down to List of Values.

4. From Named LOV, make a selection from the List of Values repository. See "Creating Lists of Values".

5. To include a null value in a list of values:

   1. In Display Null, select Yes.

   2. In Null Text, specify the value that displays.

   A column can also have a value that does not display in its list of values.

6. To define a value that does not display in the list of values:

   1. From Display Extra Value, select Yes.

      The extra value is used if the actual column value is not part of the LOV. In that situation, the actual value is shown. If you do not display extra values, you may end up with the wrong value and unintentionally update your data incorrectly.

   2. In Null Value, specify the value that displays.

   3. If you have not selected a Named LOV, enter the query used to display a select list in the LOV Query field.

7. If you have not selected a Named LOV, enter the query used to display a select list in LOV Query.

8. Click Apply Changes.

Controlling When Columns Display

You can use the Authorization and Condition attributes to control when a column displays.

Authorization enables you to control access to resources (such as a report column) based on predefined user privileges. For example, you could create an authorization scheme in which only managers can view a specific report column. Before you can select an authorization scheme, you must first create it.

A condition is a small unit of logic that enables you to control the display of a column based on a predefined condition type. The condition evaluates to true or false based on the values you enter in the Expressions fields.

To specify Authorization and Condition attributes:

1. Navigate to the appropriate Report Attributes page. See "Editing Report Attributes".

2. Access the Column Attributes page by clicking the Edit icon next to the appropriate column.

   The Column Attributes page appears.

3. Under Authorization, make a selection from the Authorization Scheme list.

4. Under Conditions, make a selection from the Condition Type list, and depending upon your selection, enter an expression or value in the appropriate Expression fields.

   If the authorization is successful and the condition type display evaluates to true, the column displays.

Controlling Column Breaks

You can control if a specific column repeats and how column breaks appear when printed using Break Formatting attributes. For example, suppose your report displays employee information by department number. If multiple employees are members of the same department, you can increase the readability by specifying the department number only appears once.

To create this type of column break:

1. Navigate to the appropriate Report Attributes page. See "Editing Report Attributes".

2. Scroll down to Break Formatting.

3. Make a selection from the Breaks list.

Printing Report Regions

You can configure a report region to print by exporting it to a PDF, RTF (rich text format), or XLS format. By taking advantage of region report printing, your application users can view and print reports that have a predefined orientation, page size, column headings, and page header and footer.

Topics in this section include:

• About Printing Reports to PDF

• About Report Printing Configuration Options

• About Report Printing Methods

• About Report Queries

• About Report Layouts

• Overview of Printing Report Regions

• Configuring Report Region Print Attributes

Creating a Form Using a Wizard

The easiest way to create a form is to use a wizard. For example, the Form on Table or View Wizard creates one item for each column in a table. It also includes the necessary buttons and processes required to insert, update, and delete rows from the table using a primary key. Each region has a defined name and display position; all other attributes are items, buttons, processes, and branches.

To create a form using a wizard:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. Click Create Page.

4. Select Form and click Next.

5. Under Forms, select a type of form page as described in Table 5-4.

   Table 5-4 Forms Page Types

   Form Page Type	Description
   Form on a Procedure	Builds a form based on stored procedure arguments. Use this approach when you have implemented logic or data manipulation language (DML) in a stored procedure or package.
   Form on a Table or View	Creates a form that enables users to update a single row in a database table.
   Form on a Table with Report	Creates two pages. One page displays a report. Each row provides a link to the second page to enable users to update each record. Note: This wizard does not support tables having more than 127 columns. Selecting more than 127 columns generates an error.
   Master Detail Form	Creates a form that displays a master row and multiple detail rows within a single HTML form. With this form, users can query, insert, update, and delete values from two tables or views. See Also: "Creating a Master Detail Form"
   Tabular Form	Creates a form in which users can update multiple rows in a database. See Also: "Creating a Tabular Form"
   Form on Web Service	Creates a page with items based on a Web service definition. This wizard creates a user input form, a process to call the Web service, and a submit button. See Also: "Creating a Form on a Web Service"
   Form and Report on Web Service	Creates a page with items based on a Web service definition. This wizard creates a user input form, a process to call the Web service, a submit button, and displays the results returned in a report. See Also: "Creating an Input Form and Report on a Web Service"
   Summary Page	Creates a read-only version of a form. Typically used to provide a confirmation page at the end of a wizard.
   Form on a SQL Query	Creates a form based on the columns returned by a SQL query such as an EQUIJOIN.

   
   

6. Follow the on-screen instructions. To learn more about a specific field, click the item label.

   When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See "About Field-Level Help".

Creating a Tabular Form

A tabular form enables users to update multiple rows in a table. The Tabular Form Wizard creates a form to perform update, insert, and delete operations on multiple rows in a database table.

To create a tabular form:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. Click Create Page.

4. Select Form and click Next.

5. Select Tabular Form and click Next.

   The Tabular Form Wizard appears.

6. For Table/View Owner:

   1. Specify the table or view owner on which you want to base your tabular form.

   2. Select the operations to be performed on the table (for example, Update, Insert and Delete).

   3. Click Next.

7. For Table/View Name, select a table and click Next.

8. For Displayed Columns:

   1. Select the columns (updatable and nonupdatable) to include in the form.

      Note that you can modify the column order or your SQL query after you create the page.

   2. Click Next.

9. For Primary Key, select the Primary Key column and a secondary Primary Key column (if applicable) and click Next.

10. For Primary Key Source, select a source type for the primary key column and click Next. Valid options include:

    • Existing trigger - Select this option if a trigger is already defined for the table. You can also select this option if you plan on specifying the primary key column source later after completing the form.

    • Custom PL/SQL function - Select this option if you wish to provide a PL/SQL function to generate returning key value.

    • Existing sequence - Select this option if you wish to pick the sequence from a list of sequences available in the selected schema.

11. On Updatable Columns, select which columns should be updatable and click Next.

12. On Page and Region Attributes:

    1. Specify page and region information.

    2. Select a region template.

    3. Select a report template.

    4. Click Next.

13. On Tab, specify a tab implementation for this page and click Next.

14. On Button Labels, enter the display text to appear for each button and click Next.

15. On Branching, specify the pages to branch to after the user clicks the Submit and Cancel buttons and click Next.

16. Click Finish.

Creating a Master Detail Form

A master detail form reflects a one-to-many relationship between two tables in a database. Typically, a master detail form displays a master row and multiple detail rows within a single HTML form. With this form, users can insert, update, and delete values from two tables or views.

To create a master detail form:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. Click Create Page.

4. Select Form and click Next.

5. Select Master Detail Form and click Next.

   The Master Detail Wizard appears.

6. On Master Table:

   1. Select a table or view owner.

   2. Select a table or view name.

      The columns in that object appear under Available Columns.

   3. Select the columns to display in the form and then click the arrow keys to move them to Displayed Columns.

   4. Click Next.

7. On Detail Table:

   1. Specify whether to show only related tables by selecting Yes or No.

   2. Select the table or view owner.

   3. Select a table or view name.

      The columns in that object appear under Available Columns.

   4. Select the columns to display in the form and then click the arrow keys to move them to Displayed Columns.

   5. Click Next.

8. On Primary Key Source, select the primary key column for the master table, and then select the primary key column for the detail table. Options include:

   • Existing trigger - Select this option if a trigger is already defined to populate the primary key.

   • Custom PL/SQL function - Select this option if you wish to provide a PL/SQL function to populate the primary key.

   • Existing sequence - Select this option if there is already an existing sequence you want the wizard to create the necessary trigger.

9. On Master Options, specify whether or not to include master row navigation and click Next.

   If you include master row navigation, define navigation order columns. If a navigation order column is not defined, the master update form navigates by the primary key column.

10. On Choose Layout, specify the layout of the master detail pages and click Next.

    You can include the master detail as a tabular form on the same page, or add the master detail on a separate page.

11. On Page Attributes, review and edit the master page and detail page information and then click Next.

12. On Tab, specify whether or not to include a tab set and click Next.

13. Click Create.

Creating a Form Manually

You can also create a form manually by performing the following steps:

• Create an HTML region (to serve as a container for your page items)

• Create items to display in the region

• Create processes and branches

To create a form manually by creating and HTML region:

1. Navigate to the appropriate Page Definition. See "Accessing a Page Definition".

2. Create an HTML region:

   1. Under Regions, click the Create icon.

   2. Select the region type HTML.

   3. Follow the on-screen instructions.

3. Start adding items to the page:

   • Under Items, click the Create icon.

   • Follow the on-screen instructions.

BEGIN
  INSERT INTO T ( first_name, last_name )
     VALUES  (:P1_FIRST_NAME, :P1_LAST_NAME);
END; 

BEGIN
    UPDATE T
       SET first_name = :P1_FIRST_NAME,
           last_name = :P1_LAST_NAME
    WHERE ID = :P1_ID;
END; 

BEGIN
    DELETE FROM T
    WHERE ID = :P1_ID;
END;

FOR C1 in (SELECT ename, sal
FROM emp WHERE ID=:P2_ID)
LOOP     
     :P2_ENAME := C1.ename;
     :P2_SAL := C1.sal;
END LOOP;

Validating User Input in Forms

You can use validations to check data a user enters before processing. Once you create a validation and the associated error message, you can associate it with a specific item. You can choose to have validation error messages display inline (that is, on the page where the validation is performed) or on a separate error page.

Creating an inline error message involves these steps:

• Create a new validation and specify error message text.

• Associate the validation with a specific item.

About Creating Calendars

Application Builder supports two calendar types:

• Easy Calendar creates a calendar based on schema, table, and columns you specify. The wizard prompts you to select a date column and display column.

• SQL Calendar creates a calendar based on a SQL query you provide. The SQL SELECT statement you provide must include at least two columns: a date column and display column.

Creating a New Calendar

How you create a calendar depends on if you are adding a calendar to an existing page or adding a calendar on a new page. When creating calendars remember:

• You can only create one calendar for each page. The calendar includes daily, weekly, and monthly views.

• The date column determines which days on the calendar will contain entries.

• The display column defines a specific row that will display a calendar date.

Topics in this section include:

• Adding a Calendar to an Existing Page

• Adding a Calendar to a New Page

Editing a Calendar Title

The title that appears at the top of calendar corresponds to the region title.

To alter the region title:

1. Navigate to the Page Definition. See "Accessing a Page Definition".

2. Under Regions, select the region name.

   The Region Definition appears.

3. Under Identification, enter a new title.

4. Click Apply Changes.

Editing Calendar Attributes

Once you create a calendar, you can alter the display by editing attributes on the Calendar Attributes page.

Note that if you want to disable a view of a calendar, you need to delete the Monthly, Weekly, or Daily buttons on the calendar page.

Topics in this section include:

• Accessing the Calendar Attributes Page

• About the Calendar Attributes Page

Upgrading a Calendar Created in a Previous Releases

By default, calendars you create in Oracle Application Express 3.0 include daily, weekly, and monthly views. If you want to update calendars created in a previous release to include these views, you can either:

• Create a new calendar:

  1. Create a new calendar page and integrate the SQL query from your previous calendar.

  2. Replace the previous calendar page with the new one in your application.

• Upgrade the theme:

  1. Change the identification number of the existing theme. See "Changing a Theme Identification Number".

  2. Recreate the theme. See "Creating a New Theme".

  3. Apply the new theme to your application. See "Switching the Active Theme".

Converting an Easy Calendar to a SQL Calendar

Creating an Easy Calendar is the simplest way to create a calendar. However, if you find the resulting calendar does not meet your needs, you can quickly convert it to a SQL Calendar.

To convert an Easy Calendar to a SQL Calendar:

1. Navigate to the Page Definition. See "Accessing a Page Definition".

2. Under Regions, click Calendar next to the region name.

   The Calendar Attributes page appears.

3. On the Tasks list, click Convert to SQL Based calendar.

   Converting an Easy Calendar to a SQL Calendar adds a Region Source section to the Region Definition. The Region Source contains the original SQL query that creates the calendar. By accessing the Region Source, you can edit the query to meet your needs.

About Supported Chart Types

Oracle Application Express supports three types of graphical charts: HTML, Scalable Vector Graphics (SVG), and Flash.

http://www.anychart.com

About Creating SQL Queries for Charts

You define a chart in Application Builder using a wizard. For most chart wizards, you select a chart type and provide a SQL query using the following syntax:

SELECT link, label, value
FROM   ...

Where:

• link is a URL.

• label is the text that displays in the bar.

• value is the numeric column that defines the bar size.

For example:

SELECT null, last_name, salary
FROM   employees
WHERE  DEPARTMENT_ID = :P101_DEPARTMENT_ID

Dial Chart Syntax

To create a dial chart, select a dial chart type and provide a SQL query using the following syntax:

SELECT value , maximum_value [ ,low_value [ ,high_value] ]
FROM   ...

Where:

• value is the starting point on the dial.

• maximum_value is the possible highest point on the dial.

• low_value and high_value are the historical low and high values.

For example:

SELECT dbms_random.value(500, 1200), 1300, dbms_random.value(100, 200)
FROM DUAL

Multiple Series Syntax (Flash only)

For column charts and line Flash charts, you can define multiple series in one SQL query. The series names for these chart types are derived from the corresponding column aliases in the query. To define a multiple series Flash chart, use the following syntax:

SELECT link, label, series_1_value [, series_2_value [, ...]]
FROM   ...

Range Chart Syntax (Flash only)

Range charts require two values for each bar. To create a range chart, create a Flash chart and provide a SQL query using the following syntax:

SELECT link, label, low_value, high_value 
FROM   ...

Scatter Chart Syntax (Flash only)

Scatter charts require an x value and y value for each point. To create a range chart, create a Flash chart and provide a SQL query using the following syntax:

SELECT link, label, x_value, y_value 
FROM   ...

Candlestick Chart Syntax (Flash only)

Candlestick charts require open, low, high, and close values for each candlestick. To create a candlestick chart, create a Flash chart and provide a SQL query using the following syntax:

SELECT link, label, open, low, high, close
FROM   ...

Creating an HTML Chart

How you create a chart depends upon whether you are adding the chart to an existing page, or adding a chart on a new page. This chart type creates a bar chart showing one data series with each data point represented by a bar.

Topics in this section include:

• Adding an HTML Chart to an Existing Page

• Adding an HTML Chart to a New Page

Creating a SVG Chart

Oracle Application Express supports a number of different SVG charts. To see a complete listing, see "About SVG Chart Types".

How you create a chart depends upon whether you are adding the chart to an existing page, or adding a chart on a new page. This chart type creates a bar chart showing one data series with each data point represented by a bar.

Topics in this section include:

• Adding a SVG Chart to an Existing Page

• Adding a SVG Chart to a New Page

• About SVG Chart Types

• Understanding SVG Chart Cascading Style Sheet Classes

• Referencing a Custom SVG Chart Cascading Style Sheet

• Specifying Custom CSS Styles Inline for SVG Charts

text{font-family:Verdana, Geneva, Arial, Helvetica, sans-serif;fill:#000000;}
tspan{font-family:Verdana, Geneva, Arial, Helvetica, sans-serif;fill:#000000;}
text.title{font-weight:bold;font-size:14;fill:#000000;}
text.moredatafound{font-size:12;}
rect.legend{fill:#EEEEEE;stroke:#000000;stroke-width:1;}
text.legend{font-size:10;}
#background{fill:#FFFFFF;stroke:none;}
rect.chartholderbackground{fill:#ffffff;stroke:#000000;stroke-width:1;}
#timestamp{text-anchor:start;font-size:9;}
text.tic{stroke:none;fill:#000000;font-size:12}
line.tic{stroke:#000000;stroke-width:1px;fill:none;}
#dial{stroke:#336699;stroke-width:2px;fill:#336699;fill-opacity:.5;}
#dial.alert{fill:#FF0000;fill-opacity:.5;}
#dialbackground{stroke:#000000;stroke-width:none;fill:none;filter:url(#MyFilter);}
#dialcenter{stroke:none;fill:#111111;filter:url(#MyFilter);}
#dialbackground-border{stroke:#DDDDDD;stroke-width:2px;fill:none;filter:url
(#MyFilter);}#low{stroke-width:3;stroke:#336699;}
#high{stroke-width:3;stroke:#FF0000;}
#XAxisTitle{letter-spacing:2;kerning:auto;font-size:14;fill:#000000;text-anchor:middle;}
#YAxisTitle{letter-spacing:2;kerning:auto;font-size:14;fill:#000000;text-anchor:middle;writing-mode:tb;}
.XAxisValue{font-size:8;fill:#000000;}
.YAxisValue{font-size:8;fill:#000000;text-anchor:end;}
.nodatafound{stroke:#000000;stroke-width:1;font-size:12;}
.AxisLine{stroke:#000000;stroke-width:2;fill:#FFFFFF;}
.GridLine{stroke:#000000;stroke-width:0.3;stroke-dasharray:2,4;fill:none;}
g.dataholder rect{stroke:#000000;stroke-width:0.5;}
.legenditem rect{stroke:#000000;stroke-width:0.5;}

rect.legend{fill:#CCCC99;stroke:none;} 

#background{fill:#FFFFFF;stroke:#FFFFFF;stroke-width:2;}

rect.chartholderbackground(display:none;)

"#timestamp{display:none;}" 

Creating a Flash Chart

How you create a flash chart depends upon whether you are adding the chart to an existing page, or adding a chart on a new page.

Topics in this section include:

• Adding a Flash Chart to an Existing Page

• Adding a Flash Chart to a New Page

• Migrating a SVG Chart to Flash

• Migrating all SVG Charts in a Application to Flash

Editing Chart Attributes

Once you have created a chart, you can alter its display by editing chart attributes on the Chart Attributes page.

To access the Chart Attributes page:

1. Navigate to the Page Definition. See "Accessing a Page Definition".

2. Under Regions, click the chart type (Chart, SVG Chart, or Flash Chart).

   The Chart Attributes page appears.

3. Edit the appropriate attributes.

4. To learn more about a specific item on a page, click the item label.

   When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See "About Field-Level Help".

5. Click Apply Changes.

Using Custom XML with Flash Charts

There are additional chart settings that cannot be controlled using the standard attributes on the Chart attributes page. To further control the look and feel of a chart, you can use custom XML.

To use custom XML:

1. Navigate to the Chart Attributes page:

   1. Navigate to the Page Definition. See "Accessing a Page Definition".

   2. Under Regions, click the chart type, Flash Chart.

      The Chart Attributes page appears.

2. Scroll down to Chart XML.

3. From Use Custom XML, select Yes.

   Note that when you select to use custom XML, regions with attributes that no longer apply are hidden. To display these regions again, select No for Use Custom XML.

4. Edit the XML.

5. Click Apply Changes.

http://www.anychart.com

Enabling Asynchronous Updates

You can create SVG and Flash charts that monitor information by enabling the Asynchronous Update attribute on the Chart attributes page. Enabling this attribute updates the chart to reflect changes in the underlying data within a specified time interval.

To enable asynchronous updates:

1. Create an SVG or Flash chart. See "Creating a SVG Chart" or "Creating a Flash Chart".

2. Navigate to the Page Definition. See "Accessing a Page Definition".

3. Under Regions, click Chart next to the region name.

   The Chart Attributes page appears.

4. Scroll down to Refresh.

5. From Asynchronous Update, select Yes.

6. In Update Interval (Seconds), enter the interval in seconds between chart updates. For optimal performance, select an interval that is greater than 2 seconds.

When Asynchronous Update is enabled for an SVG chart, a timestamp displays on the chart indicating the last update.

To disable the Asynchronous Update timestamp:

1. Navigate to the Chart Attributes page.

2. Locate the CSS section.

3. From Use Custom CSS, select Yes.

4. In Custom CSS, Inline edit #timestamp as follows:

   #timestamp{display:none;}
   

Displaying SVG Charts in Other Languages

To display an SVG chart in another language, you edit the text and tspan classes to reflect the correct language.

To display an SVG chart in another language:

1. Navigate to the Chart Attributes page. See "Editing Chart Attributes".

2. Scroll down to CSS.

3. From Use Custom CSS, select Yes.

4. In Custom CSS, Inline, edit the text and tspan classes to reflect the correct language. The following example demonstrates how to change a chart to Korean:

   text{font-family:Batang;fill:#000000;}
   tspan{font-family:Batang;fill:#000000;}
   

About the Buttons Section of the Page Definition

You create and edit buttons on the Page Definition. The Buttons section appears in the Page Rendering area. See "Accessing a Page Definition".

You can temporarily hide all other subsections by clicking the Buttons icon. To restore the view, click Show All. The Show All icon resembles an inverted triangle.

The following icons display next to the section title:

• Edit All. The Edit All icon resembles a small grid with a pencil on top of it. Use this icon to edit all buttons at once.

• Copy. The Copy icon resembles two small overlapping pages. Use this icon to make a copy of an existing button.

• Create. The Create icon resembles a plus (+) sign overlapping a small page. Click this icon to create a new button.

Buttons are organized by region. To edit a button, click the button name.

Creating a Button Using a Wizard

You create a button by running the Create Button Wizard from the Page Definition. Each button resides in a region. A region is an area on a page that serves as a container for content.

To create a new button:

1. Navigate to the appropriate Page Definition. See "Accessing a Page Definition".

2. If necessary, create an HTML region. See "Understanding Regions".

3. Under Buttons, click the Create icon.

   The Create Button Wizard appears.

4. Select a region to contain the button and click Next.

5. Select a position for the button and click Next:

   • Create a button displayed among this region's items - Select this option to display the button within or between page items (for example, to add a button directly to the right of a form field).

   • Create a button in a region position - Select this option to place the button in a region position. A region position is a position defined by a region template.

6. If you select Create a button in a region position:

   1. Specify the Button Name and Label.

   2. Select a Button Type: HTML Button (Default), Image, or Template Driven

      Select Button is Reset to create an Undo button. When enabled, this type of button resets the page values to the state they were in when the page was initially rendered.

   3. Select an Action:

      • Submit page and redirect to URL submits the current page to the Application Express engine whenever a user clicks the button.

      • Redirect to URL without submitting page avoids submitting the page. Choose this action when submitting the page for processing is not necessary (for example, a Cancel button). This action avoids processing in the database and therefore reduces the load.

   4. Click Next.

7. If you select Create a button displayed among this region's items:

   1. Specify the Button Name and Sequence.

   2. Specify if the button displays at the beginning of a new line or new field.

   3. Specify a Label.

   4. Enter the value of Request.

   5. Select the Button Style.

   6. Click Next.

8. Follow the on-screen instructions. To learn more about a specific field, click the item label.

   When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See "About Field-Level Help".

Creating Multiple Buttons

You can create multiple buttons within the same region at once using the Create Multiple Buttons Wizard.

To create multiple buttons at once:

1. Navigate to the appropriate Page Definition. See "Accessing a Page Definition".

2. If necessary, create an HTML region. See "Understanding Regions".

3. Under Buttons, click the Create icon.

   The Create Button Wizard appears.

4. Select Create Multiple Buttons at the bottom of the page.

   The Create Multiple Button Wizard appears.

5. From Place Buttons in Region, select the region to contain the buttons.

6. From Template, select a template.

7. In HTML Attributes, specify HTML attributes for these buttons. This text will be added to the HTML element definition. For example, you could set the class of a text button as follows:

   class="myclass"
   

8. To quickly populate the remaining fields, make a selection from the Quick Button list on the right side of the page.

9. Click Create Buttons.

Editing Buttons

When you want to edit a button, you start from the Buttons section on the Page Definition. You can edit the attributes of a button, edit multiple buttons at once, or change a button position within a region.

Topics in this section include:

• Editing Button Attributes

• Using the Edit All Icon to Edit Multiple Buttons

• Using the Reorder Buttons Icon

Using the Edit All Icon to Edit Multiple Buttons

You can edit multiple buttons at once by clicking the Edit All icon on the Page Definition. The Edit All icon resembles a small grid with a pencil on top of it.

Description of the illustration edit_all_button.gif

Clicking the Edit all icon displays the Buttons page, which contains a table listing the buttons in the region. This enables you to edit multiple buttons at once.

From the Buttons page, you can delete multiple buttons or view a history of recent changes.

To edit multiple buttons:

1. Navigate to the appropriate Page Definition. See "Accessing a Page Definition".

2. Under Buttons, click the Edit All icon.

   The Buttons page appears.

3. Edit the attributes on the Buttons page, or click the Edit icon to edit the attributes for a single button.

4. Click Apply Changes.

Delete Multiple Buttons

To delete multiple buttons at once:

1. Navigate to the appropriate Page Definition. See "Accessing a Page Definition".

2. Under Buttons, click the Edit All icon.

3. Click Delete Multiple Buttons.

   The Delete Multiple Buttons page appears.

4. Select the buttons to delete and click Remove Buttons.

History

Use the History page to view a summary of recent edits to buttons.

Using the Reorder Buttons Icon

You can quickly edit a button label or change a button position within a region by clicking the Reorder Region Buttons icon on the Page Definition. The Reorder Region Buttons icon resembles a light green downward arrow and upward arrow and displays next to the region name.

Description of the illustration reorder_buttons.gif

To edit buttons using the Reorder Region Buttons icon:

1. Navigate to the appropriate Page Definition. See "Accessing a Page Definition".

2. Under Buttons, click the Reorder Region Buttons icon.

   The Reorder Buttons page appears. Use this page to edit the button label, select a new region position, or change the button order.

3. To edit the button label, enter a new name in the Label field.

4. To change the region position, make a selection from the Position list.

5. To change the order in which buttons display, click the up and down arrows in the far right column.

   Note that you can also control the order in which buttons display by editing the Sequence attribute. See "Editing Button Attributes".

6. Click Apply Changes.

Note:

To change the region where a button resides, you must edit the button attributes. See "Editing Button Attributes".

Understanding the Relationship Between Button Names and REQUEST

The name you give a button determines the value of the built-in attribute REQUEST. You can reference the value of REQUEST from within PL/SQL using the bind variable :REQUEST. By using this bind variable, you can conditionally process, validate, or branch based on which button the user clicks. You can also create processes that execute when the user clicks a button. And you can use a more complex condition as demonstrated in the following examples:

If :REQUEST in ('EDIT','DELETE') then ...
If :REQUEST != 'DELETE' then ...

These examples assume the existence of buttons named EDIT and DELETE. You can also use this syntax in PL/SQL Expression conditions. Be aware, however, that the button name capitalization (case) is preserved. In other words, if you name a button LOGIN, then a request looking for the name Login will fail. For example:

<input type="BUTTON" value="Finish" onClick="javascript:doSubmit('Finish');">

Note that in this example Finish is the name of the REQUEST and this example is case-sensitive.

About Branching with Buttons

Each page can include any number of branches. A branch links to another page in your application or to a URL. The Application Express engine considers branching at different times during page processing. You can choose to branch before processing, before computation, before validation, and after processing. Like any other control in Application Builder, branching can be conditional. For example, you can branch when a user clicks a button. When you create a branch, you associate it with a specific button. The branch will only be considered if a user clicks the button.

Displaying Buttons Conditionally

You can choose to have a button display conditionally by editing attributes on the Edit Pages Button page.

To have a button display conditionally:

1. Create the button. See "Creating a Button Using a Wizard".

2. Navigate to the appropriate Page Definition. See "Accessing a Page Definition".

3. Under Buttons, select the button name.

   The attributes page for the button appears.

4. Scroll down to Conditional Button Display.

5. Make a selection from the Condition Type list.

6. Enter an expression in the fields provided.

7. Click Apply Changes.

Differences Between Page Items and Application Items

There are two types of items: page items and application items. Page items are placed on a page and have associated user interface properties, such as Display As, Label and Label Template. Examples of page-level items include a check box, date picker, display as text, file browse field, popup list of values, select list, or a text area. Application items are not associated with a page and therefore have no user interface properties. You can use an application item as a global variable.

About the Items Section of the Page Definition

You create and edit page-level items on the Page Definition. The Items section appears in the Page Rendering area.

You can temporarily hide all other subsections by clicking the Items icon. To restore the view, click Show All. The Show All icon resembles an inverted triangle.

The following icons display next to the section title:

• Edit All. The Edit All icon resembles a small grid with a pencil on top of it. Use this icon to edit all items at once. See "Using the Edit All Icon to Edit Multiple Items".

• Copy. The Copy icon resembles two small overlapping pages. Use this icon to make a copy of an existing item.

• Create. The Create icon resembles a plus (+) sign overlapping a small page. Click this icon to create a new item.

Items are organized by region. To edit an item, click the item name.

About the Drag and Drop Icon

You can quickly change the appearance of a page by clicking the Drag and drop icon to access the Drag and Drop Layout page. The Drag and drop icon resembles a green rectangle and displays to the right of the Reorder Region Items icon.

Description of the illustration drag_drap_ico.gif

You can use the Drag and Drop Layout page to interactively reorder items within a given region, change select item attributes, create new items, or delete existing items. See "Using the Drag and Drop Layout Page".

About the Reorder Items Icon

You can quickly edit the label and position of items in a region by clicking the Reorder Region Items icon on the Page Definition. This icon resembles a light green down or up arrow.

Description of the illustration reorder_items.gif

See Also:

"Using the Reorder Region Items Icon"

Creating Page-Level Items

Topics in this section include:

• Creating a Page-Level Item on the Page Definition

• About Item Naming Conventions

• About Item Types

• Creating Multiple Items Using Tabular Form

• Creating Multiple Items Using Drag and Drop

• Creating a Static List of Values

SELECT NULL display_text, 'YES' return_value FROM DUAL;

SELECT 'Click to select' display_text, 'YES' return_value FROM DUAL;

SELECT ename name, empno id 
   FROM emp

SELECT ename||' '||job display_value, empno FROM emp

SELECT ename, empno FROM emp

SELECT ename display_text, empno return_value FROM emp

STATIC:Cow,Dog,Cat,Lion

STATIC2:10,15,20,25,50,100,200,500,1000,10000

STATIC:Yes;Y,No;N

Editing Page-Level Items

You can edit page-level items by editing page item attributes or using the Edit All or Reorder Items icons.

Topics in this section include:

• Editing Page Item Attributes

• Using the Edit All Icon to Edit Multiple Items

• Using the Reorder Region Items Icon

Page Items

Item attributes control how items display on a page. You can use the Page Items page to edit the sequence, field label, template, region, and overall position for all items on a page.

A Navigation bar displays at the top of the page. Use the Page field to navigate to another page. To limit the display to just items in a specific region, make a selection from Show Regions list.

The Page Items page displays items in an editable report. Table 5-8 describes each editable attribute.

Edit the appropriate attributes and click Apply Changes.

Item Help

Use the Item Help page to edit item help for all items on a page. You can avoid repeating the same Help text in multiple locations by subscribing to another item.

To edit item Help:

1. Navigate to the appropriate Page Definition. See "Accessing a Page Definition".

2. Under Items, click the Edit All icon.

3. Click Item Help.

   The Item Help page appears.

   Use the Navigation bar at the top of the page to narrow or broaden the display. Available options include:

   • Page - Select or enter a new number and click Go.

   • Search - Enter a case insensitive query and click Go.

   • Show - Select whether to display All, Subscribed, or Unsubscribed Help text.

   • All Pages - Select to run the search query on all pages in the application.

   • Current Page - Select to restrict the search query to the current page.

     You can also use the arrows in the Navigation bar to scroll through the application pages.

4. To subscribe to an existing Help item, make a selection from Subscribed To.

5. To edit help for a specific item, click the item name.

   On the Edit Help page:

   1. Reference Master Item Help From - (Optional) Select a existing item Help topic to subscribe to.

   2. Help Text - Enter or edit the Help text for this item.

   3. Click Apply Changes.

6. Click Apply Changes.

Reassign Region Items

Use the Reassign Region Items page to assign items to a new region.

To Reassign Region Items page:

1. Navigate to the appropriate Page Definition. See "Accessing a Page Definition".

2. Under Items, click the Edit All icon.

3. Click Reassign Region Items.

   The Reassign Region Items page appears.

   Use the Navigation bar at the top of the page to narrow or broaden the display. Available options include:

   • Page - Select or enter a new number and click Go.

   • Show Regions - Select a region to display and click Go.

4. To reassign an item to another region:

   1. Select the items to reassign.

   2. From Assign to Region, select a new region.

   3. Click Reassign Region Items.

Delete Multiple Items

Use the Delete Multiple Items page to delete multiple items at once.

To delete multiple items:

1. Navigate to the appropriate Page Definition. See "Accessing a Page Definition".

2. Under Items, click the Edit All icon.

3. Click Delete Multiple Items.

   The Delete Multiple Items page appears.

   Use the Navigation bar at the top of the page to narrow or broaden the display. Available options include:

   • Page - Select or enter a new number and click Go.

   • Show Regions - Select a region to display and click Go.

   • Forward (>) and Next (<) buttons - Display the previous and next page.

4. To reassign an item to another region:

   1. Select the items to reassign.

   2. From Assign to Region, select a new region.

   3. Click Reassign Region Items.

History

Use the History page to view a summary of recent edits to page-level items.

Accessing the Drag and Drop Layout Page

You access the Drag and Drop Layout page by either:

• Clicking the Drag and drop icon on the Page Definition. See "About the Drag and Drop Icon".

• Clicking the Reorder Regions Items icon and selecting the Drag and Drop Layout tab. See "Using the Reorder Buttons Icon".

About the Drag and Drop Layout Page

The Drag and Drop Layout page is divided into two sections: Item palette and Layout region.

The Item palette displays on the left side of the page. You add new items by clicking an item type on the palette and dragging it to the correct position in the Layout region. Note that when you position the cursor over an item type, a tooltip appears.

Use the right side of the page (or Layout region) to position items. To move an item vertically, click the Add Row button to insert an empty row. Then drag and drop the item into the empty row.

Creating a New Item

To create a new item on the Drag and Drop Layout page:

1. Navigate to the Drag and Drop Layout page. See "Accessing the Drag and Drop Layout Page".

2. Click an item type in the Item palette on the left side of the page and drag it to the appropriate location in the Layout region.

   Note that when you position the cursor over an item type, a tooltip appears.

3. You can reposition the item:

   • To move an item horizontally, select the item and drag it to the appropriate position on the page.

   • To insert an existing or new item between two existing rows, click the Add Row button and drag it between the existing rows. This creates an empty row where you can then move the item.

4. Edit the item attributes at the of the page.

   1. Display Name - Enter an item name. Use this name to retrieve the value of the item. Item names longer than 30 characters cannot be referenced using bind variable syntax.

   2. Label - Enter the label for this item. You may include HTML, JavaScript, and shortcuts. You can also use the substitution string #CURRENT_ITEM_NAME# to obtain the name of the item associated with this label.

   3. Display Type - Select a display type (if applicable). Note that the select list is restricted to options corresponding to the type of item you are creating. See "About Item Types".

5. Click Next.

6. Optionally, edit the each item's Name and Label.

7. Click Apply Changes.

Editing Existing Items

To edit an existing item on the Drag and Drop Layout page:

1. Navigate to the Drag and Drop Layout page. See "Accessing the Drag and Drop Layout Page".

2. To reposition the item:

   • To move an item horizontally, select the item and drag it to the appropriate position on the page.

   • To insert an existing or new item between two existing rows, click the Add Row button and drag it between the existing rows. This creates an empty row where you can then move the item.

3. If required, select an item and edit its attributes at the of the page.

   1. Display Name - Enter an item name. Use this name retrieve the value of the item. Item names longer than 30 characters cannot be referenced using bind variable syntax.

   2. Label - Enter the label for this item. You may include HTML, JavaScript, and shortcuts. You can also use the substitution string #CURRENT_ITEM_NAME# to obtain the name of the item associated with this label.

   3. Display Type - Select a display type (if applicable). Note that the select list is restricted to options corresponding to the type of item you are creating. See "About Item Types". See "About Item Types".

4. Click Next.

5. Optionally, edit the each item's Name and Label.

6. Click Apply Changes.

Deleting Items

To delete an item, click it and drag it to the Recycle box at the bottom of the page. If you delete an existing item, it appears in the Recycle box and can be retrieved until you click Apply Changes on the next page. Note that if you drop a new item you have just created in the Recycle box, it instantly disappears and cannot be retrieved.

Using APEX_UTIL.STRING_TO_TABLE to Convert Selected Values

Suppose you had a report on the EMP and DEPT tables that is limited by the departments selected from a Department multiple select list. First, you create the multiple select item, P1_DEPTNO, using the following query:

SELECT dname, deptno
FROM dept

Second, you return only those employees within the selected departments as follows:

SELECT ename, job, sal, comm, dname
FROM emp e, dept d
WHERE d.deptno = e.deptno
AND instr(':'||:P1_DEPTNO||':',':'||e.deptno||':') > 0

Next, assume you want to programmatically step through the values selected in the multiple select item, P1_DEPTNO. To accomplish this, you would convert the colon-delimited string into a PL/SQL array using the APEX_UTIL.STRING_TO_TABLE function. The following example demonstrates how to insert the selected departments into an audit table containing the date of the query.

DECLARE
    l_selected APEX_APPLICATION_GLOBAL.VC_ARR2;
BEGIN
  --
  -- Convert the colon separated string of values into
  -- a PL/SQL array 

  l_selected := APEX_UTIL.STRING_TO_TABLE(:P1_DEPTNO);

  --
  -- Loop over array to insert department numbers and sysdate
  --

  FOR i IN 1..l_selected.count 
  LOOP
    INSERT INTO report_audit_table (report_date, selected_department)
        VALUES (sysdate, l_selected(i));
  END LOOP;
END;

Defining PICK_DATE_FORMAT_MASK as an Application Substitution String

One approach to populating PICK_DATE_FORMAT_MASK is to create an application substitution string. You define application-level substitution strings on the Edit Definition page. Remember that an application-level substitution string is a static value and cannot be altered at run time.

To define a new application substitution string named PICK_DATE_FORMAT_MASK:

1. On the Workspace home page, click the Application Builder icon.

   Application Builder appears.

2. Select an application.

3. Click Shared Components.

   The Shared Components page appears.

4. Under Application, click Application Definition.

5. Scroll down to Substitutions.

6. Create a new static substitution string named PICK_DATE_FORMAT_MASK:

   1. In Substitution String, enter the name PICK_DATE_FORMAT_MASK.

   2. In Substitution Value, enter a value for your date format (for example, Month DD, YYYY).

Defining an Application-Level Item Named PICK_DATE_FORMAT_MASK

Another approach to populating PICK_DATE_FORMAT_MASK is to create an application-level item named PICK_DATE_FORMAT_MASK. This approach enables you to control any items rendered as Date Picker (use application format mask) by simply setting the value of this item. Plus, you can set the value of PICK_DATE_FORMAT_MASK using a computation from anywhere within your application.

If you want to provide the user with a list of date formats as preferences, you will need to create an application-level item named PICK_DATE_FORMAT_MASK and then use a computation to set the value of this item based upon the user's selection.

Creating an Application-level Item

To create a new application-level item:

1. Navigate to the Workspace home page.

2. Click the Application Builder icon.

3. Select an application.

4. When Application Builder appears, click Shared Components.

5. Under Logic, select Application Items.

   The Application Items page appears.

6. To create a new application item, click Create.

7. Follow the on-screen instructions.

Accessing Application Item History

You can view a history of changes to application items by clicking History at the top of the Application Items page.

Editing Application-level Item Attributes

Once you create an application-level item, you can edit it on the Create/Edit Application Item page.

To edit application-level item attributes:

1. Navigate to the Workspace home page.

2. Click the Application Builder icon.

3. Select an application.

4. When Application Builder appears, click Shared Components.

5. Under Logic, select Application Items.

   The Application Items page appears.

6. Select an application item.

   The Create/Edit Application Item page appears.

7. To learn more about a specific item on a page, click the item label.

   When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See "About Field-Level Help".

8. Click Apply Changes.

Creating a Named LOV at the Application Level

You define named (or shared) LOVs at the application level by running the Create LOV Wizard and adding them to the List of Values repository. All LOVs can be defined as static or dynamic. Static lists are based on predefined pairs of display values and return values. Dynamic lists are based on a SQL query you write that selects values from a table.

To create a named LOV:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

   The Application home page appears.

3. Click the Shared Components icon.

4. Under User Interface, select Lists of Values.

   The Lists of Values page appears.

5. To create a new LOV, click Create.

6. Follow the on-screen instructions.

   New named LOVs are added to the List of Values repository. Note to add the LOV to a page you must edit the appropriate item or column and select the named LOV.

About the List of Values Page

Once you create an LOV, it appears on the List of Values page.

Description of the illustration lov_page.gif

Use the Navigation bar at the top of the page to search for a LOV by name or change the page display. For example, you can change the default display by making a selection from View list. Available options include:

• Icons (the default) displays each LOV as a large icon. To edit an LOV, click the appropriate icon.

• Details displays each LOV as a line in a report. To edit an LOV, click the name.

About Static LOVs

Static LOVs are based on a static list of display values and return values you specify when you run the Create LOV Wizard. To create a static LOV, run the Create LOV Wizard and select the LOV type Static. Oracle Application Express stores the display values, return values, and sort sequence you specify in the List of Values repository. Once you add a static LOV to the repository, you can create an item and display it as a check box, radio group, select list, or popup list based on this definition.

Editing an Existing LOV

To edit an existing LOV, select the LOV on the Lists of Values page.

To edit an LOV:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. Click Shared Components.

4. Under User Interface, select Lists of Values.

5. Select an LOV.

   The Edit List of Values page appears.

6. To learn more about a specific item on a page, click the item label.

   When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See "About Field-Level Help".

7. Click Apply Changes.

Referencing Session State Within an LOV

You can reference session state by using bind variables. Keep in mind that referencing session state makes an LOV a bit less reusable, but is still a recommended development practice. In the following example, this LOV only works if the item called my_deptno contains a valid department number.

SELECT ename, empno FROM emp WHERE deptno = :P1_DEPTNO

Referencing a Null Value in an Item Based on an LOV

LOVs have a null display value option and a null return value option. The null display value is the value the end user sees in the list indicating the no selection from the proper (non-null) values of the list will be made. When a user selects a null display value, the LOV's null return value is sent to the application when the page is submitted. If the developer has left the null return value unspecified (or empty), the actual value transmitted is not an empty string or an Oracle null, but the literal %null%. The application must be prepared to deal with this literal and treat is as the null selection.

Be aware of this behavior when writing code to evaluate submitted values. For example, suppose a page evaluates the submitted item P1_X and you need to use the PL/SQL expression replace(:P1_X,'%'||'null%',null) to prepare the item for permanent storage in session state or for passing to DML or other APIs.

To avoid problems, be aware of the appropriate way to code %null% in expressions that occur in page computations, processes, and validations. You must break up the string so that the application does not replace %null% with a null value in the page metadata when it is saved. Consider the following example:

'%'||'null%'

Accessing LOV Reports

Application Builder includes a number of reports designed to help you better manage LOVs.

To access LOV reports:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. When Application Builder appears, click Shared Components.

4. Under User Interface, select Lists of Values.

5. Select one of the following tabs at the top of the page:

   • Search

   • Subscription

   • Utilization

   • History

6. Follow the on-screen instructions.

About Shortcut Types

When you create a new shortcut, you must specify the type of shortcut you want to create. Oracle Application Express supports the following shortcut types:

• PL/SQL Function Body

• HTML Text

• HTML Text with Escaped Special Characters

• Image

• Text with JavaScript Escaped Single Quotes

• Message

• Message with JavaScript Escaped Special Quotes

Defining Shortcuts

Before you can incorporate a shortcut in your application, you must define it and add it to the Shortcuts repository. You reference new shortcuts using the following syntax:

"MY_SHORTCUT"

Note that the shortcut name must be capitalized and enclosed in quotation marks.

To define a new shortcut:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. When Application Builder appears, click Shared Components.

4. Under User Interface, select Shortcuts.

5. Click Create.

6. Select one of the following creation methods:

   • From Scratch

   • As a Copy of an Existing Shortcut

7. Follow the on-screen instructions.

New shortcuts are added to the Shortcut repository and are available for use within the following locations:

• The Region Source attribute of regions defined as HTML Text (with shortcuts). See "Understanding Regions".

• Region Header and Footer Text attribute. See "Specifying a Region Header and Footer".

• Item Label attributes and Default Value attribute. See "Items".

• Region Templates attributes. See "Editing Templates".

Editing Existing Shortcuts

Once you create a shortcut, you can alter it by editing attributes on the Edit Shortcut page.

To edit an existing shortcut:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. Click Shared Components.

4. Under User Interface, select Shortcuts.

5. Select a shortcut.

   The Edit Shortcut page appears.

6. To learn more about a specific item on a page, click the item label.

   When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See "About Field-Level Help".

7. Click Apply Changes.

Accessing Shortcut Reports

Application Builder includes a number of reports designed to help you better manage shortcuts.

To access shortcut reports:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. When Application Builder appears, click Shared Components.

4. Under User Interface, select Shortcuts.

5. Click one of the following tabs:

   • Subscription

   • History

   Note:

   The Subscription and History tabs only appear after you create a shortcut.

About the Find Icon

The Find icon resembles a flashlight and often displays to the right of the Run Page and Edit Page icons as shown in the following illustration. The Find icon displays on many pages in Application Builder, including the Application Home page, the Page Definition, application attribute pages, and numerous pages for creating and managing shared components.

About the Item Finder

In Application Builder, an item can be a text field, text area, password, select list, check box, and so on. You can use the Item Finder to search for items within the current application or within the schema associated with the workspace.

To search for an item using the Item Finder:

1. Click the Find icon.

   The Item Finder appears.

   A search bar displays at the top of the page and contains the following controls:

   • Search. Search for an item name. Enter case insensitive keywords in the Search field and click Go. To view all items, leave the Search field blank and click Go.

   • Page. Search for pages that contain items. Enter a page number in the Page field or select a page number from the list and click Go. To view all pages containing items, leave the Page field blank and click Go.

   • Display. Determine how many rows display in the resulting report. To change the number of rows that display, make a selection from the Display list and click Go.

   A Item Finder report appears, displaying the item name, label, item type, and associated page number.

   
   Description of the illustration item_finder.gif
   
   

2. To restrict the report to display just items on a specific page, click the appropriate page number in the far right column.

   Note the page number you select appears in the Page field at the top of the page. To expand the view to all pages, delete the page number in the Page field and click Go.

3. To edit a specific item, navigate to the appropriate item. See "Editing Page Item Attributes" and "Using the Edit All Icon to Edit Multiple Items".

Using the Page Finder

A page (or Page Definition) is the basic building block of an application. You can use the Page Finder to search for pages within the current application or within the schema associated with the workspace.

To search for a page:

1. Click the Find icon.

2. Select the Pages tab.

   The Page Finder appears.

   A search bar displays at the top of the page and contains the following controls:

   • Search. Search for a page name. Enter case insensitive keywords in the Search field and click Go. To view all pages, leave the Search field blank and click Go.

   • Display. Determine how many rows display in the resulting report. To change the number of rows that display, make a selection from the Display list and click Go.

   The Page Finder report appears, displaying the page number, page name, page alias, title, tab set, and counts of the number of items and regions on the page.

   
   Description of the illustration pages_finder.gif
   
   

3. To link to the Items page, click the page number.

Using the Query Finder

You can use the Query Finder to locate a query within your application or within the schema associated with the workspace.

To search for a query using the Query Finder:

1. Click the Find icon.

2. Select the Queries tab.

   The Query Finder appears.

   A search bar displays at the top of the page and contains the following controls:

   • Search. Search for query statements. Enter case insensitive keywords in the Search field and click Go. To view all queries, leave the Search field blank and click Go.

   • Display. Determine how many rows display in the resulting report. To change the number of rows that display, make a selection from the Display list and click Go.

   The Query Finder report appears, displaying the page number, page name, the region containing the query, and the query source.

   
   Description of the illustration query_finder.gif
   
   

3. To link to the Items page, click the page number.

Using the Table Finder

You can use the Table Finder to view tables within the schema associated with the workspace.

To view tables associated within the current schema:

1. Click the Find icon.

2. Select the Tables tab.

   The Table Finder appears.

   A search bar displaying the selected schema displays at the top of the page and contains the following controls:

   • Search. Search for a table name. Enter case insensitive keywords in the Search field and click Go. To view all tables, leave the Search field blank and click Go.

   • Display. Determine how many rows display in the resulting report. To change the number of rows that display, make a selection from the Display list and click Go.

   • Views. Select the Views checkbox and click Go to include views in the resulting report.

   The Table Finder report appears displaying the table name, the number of rows, and the object type.

3. Select a table name.

   A table definition appears on the right side of the page.

   
   Description of the illustration table_finder.gif
   
   

   This report displays the column names, data type, length, precision, and scale as well as the SQL necessary to re-create the table appears at the bottom of the page.

Using the PL/SQL Finder

You can use the PL/SQL Finder to locate and view details about stored procedures, functions, and packages associated with each object within the schema associated with the workspace.

To search for PL/SQL code in the current schema:

1. Click the Find icon.

2. Select the PL/SQL tab.

   The PL/SQL Finder appears.

   A search bar displays at the top of the page contains the following controls:

   • Search. Search for procedure, function, or package names. Enter case insensitive keywords in the Search field and click Go. To view all, leave the Search field blank and click Go.

   • Display. Determine how many rows display in the resulting report. To change the number of rows that display, make a selection from the Display list and click Go.

   • Procedures, Functions, or Packages. Select at least one check box and click Go to include procedures, functions, and packages in the report. You must select at least one check box to return results.

   The PL/SQL Finder report appears.

3. To view additional details, select the procedure, function, or package name.

   
   Description of the illustration plsql_finder.gif
   
   

   The procedure, package, or function name appears as well as additional information including the owner, source name, source type, return type, argument names, data types, and IN/OUT parameters.