Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\tutorial\frm_layout.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <!-- Run date = February 23, 2005 16:58:37 --> <meta name="Generator" content=" Oracle DARB XHTML converter - Version 4.1.3 Build 116" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title> How to Control Form Layout </title> <link rel="stylesheet" type="text/css" href="blafdoc.css" title="default" /> <link rel="stylesheet" type="text/css" href="darbbook.css" title="default" /> <link rel="prev" href="rprt_drill.htm" title="Previous" /> <link rel="next" href="check_box.htm" title="Next" /> <link rel="up" href="toc.htm" title="Up" /> <link rel="contents" href="toc.htm" title="Contents" /> <link rel="copyright" href="./support/html/cpyr.htm" title="Copyright" /> <link rel="index" href="index.htm" title="Index" /> </head> <body> <div class="header"> <a id="top" name="top"></a> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"> <b>Oracle® HTML DB Guide to Building Applications </b> <br /> <b>Release 2.0 </b> </td> <td valign="bottom" align="right"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="225"> <tr><td> </td> <td align="center" valign="top"><a href="toc.htm"><img src="./support/gifs/toc.gif" alt="Go To Table Of Contents" border="0" /><br /><span class="icon">Contents</span></a></td> </table> </td> </tr> </table> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100"> <tr> <td align="center"> <a href="rprt_drill.htm"> <img src="./support/gifs/leftnav.gif" alt="Previous" border="0" /><br /><span class="icon">Previous</span></a> </td> <td align="center"> <a href="check_box.htm"> <img src="./support/gifs/rightnav.gif" alt="Next" border="0" /><br /><span class="icon">Next</span></a> </td> <td> </td> </tr> </table> </div><!-- class="header" --> <div class="IND"> <!-- End Header --><a id="CIHCFIBA" name="CIHCFIBA"></a><a id="sthref62" name="sthref62"></a> <h1><a name="HTMAD004"></a>How to Control Form Layout </h1> <p>Data and form elements in an Oracle HTML DB application are placed on a page using containers called regions. There are several attributes that control the placement and positioning of regions on pages. In turn, placement and style of form elements inside of regions is controlled by item attributes. </p> <p>This tutorial describes the steps to create a data input form and how to change its layout by changing region and item attributes. </p> <p class="subhead2">Topics:</p> <ul> <li type="disc"> <p><a href="#BABHBGGJ">About Sample Application</a> </p> </li> <li type="disc"> <p><a href="#CIHJIJBI">Creating a Table and Data Input Form</a> </p> </li> <li type="disc"> <p><a href="#CIHIABHI">Changing the Appearance of a Page by Altering Region Attributes</a> </p> </li> <li type="disc"> <p><a href="#CIHCGHBH">Understanding How Item Attributes Effect Page Layout</a> </p> </li> <li type="disc"> <p><a href="#CIHEAJFJ">Adding a Region Header and Footer</a> </p> </li> <li type="disc"> <p><a href="#CIHJDJAB">Making a Region Conditional</a> </p> </li> <li type="disc"> <p><a href="#CIHDJCGI">Adding Another Region for HTML Text</a> </p> </li> <li type="disc"> <p><a href="#CIHBHHGE">Changing Item Types</a> </p> </li> <li type="disc"> <p><a href="#CIHGIJCB">About Label Templates</a> </p> </li> <li type="disc"> <p><a href="#CIHDEGBI">Changing Buttons</a> </p> </li> </ul><a id="BABHBGGJ" name="BABHBGGJ"></a> <div class="sect1"> <!-- infolevel=all infotype=General --><a id="sthref63" name="sthref63"></a> <h2>About Sample Application </h2> <p>Oracle HTML DB installs with a number of demonstration applications. To complete this exercise you must install the demonstration application, <span class="italic">Sample Application</span>. </p> <p>To see if <span class="italic">Sample Application</span> is installed: </p> <ol type="1" start="1"> <li> <p>Log in to Oracle HTML DB. </p> </li> <li> <p>From the Workspace Administration list, select <span class="bold">Review Demonstration Applications</span>. </p> </li> <li> <p>Locate Sample Application and check the Status column: </p> <ol type="a"> <li> <p>If the Status column displays <span class="bold">Installed</span>, return to the Workspace home page. </p> </li> <li> <p>If the Status column displays <span class="bold">Not Installed</span>, select <span class="bold">Install</span> in the Action column. </p> </li> <li> <p>Follow the on-screen instructions. </p> </li> </ol> </li> </ol> </div><!-- class="sect1" --> <a id="CIHJIJBI" name="CIHJIJBI"></a> <div class="sect1"> <!-- infolevel=all infotype=General --><a id="sthref64" name="sthref64"></a> <h2>Creating a Table and Data Input Form </h2> <p>The first step in creating a data input form is to create the underlying data objects in SQL Workshop. In this exercise, you create a table named <code>HT_EMP</code> and then use a wizard to create a new page. </p> <p class="subhead2">Topics:</p> <ul> <li type="disc"> <p><a href="#CIHDIEDJ">Create the HT_EMP Table</a> </p> </li> <li type="disc"> <p><a href="#CIHDGGGA">Create a New Page Containing a Input Form</a> </p> </li> <li type="disc"> <p><a href="#CIHDCIDJ">Run the Page</a> </p> </li> </ul><a id="CIHDIEDJ" name="CIHDIEDJ"></a> <div class="sect2"> <!-- infolevel=all infotype=General --><a id="sthref65" name="sthref65"></a> <h3>Create the HT_EMP Table </h3> <p>To create the <code>HT_EMP</code> table and the appropriate associated objects: </p> <ol type="1" start="1"> <li> <p>Click <span class="bold">SQL Workshop</span> on the Workspace home page. </p> </li> <li> <p>Under SQL Scripts, click <span class="bold">Scripts</span>. </p> </li> <li> <p>When the Script Repository appears, click <span class="bold">Create</span>. </p> </li> <li> <p>In the Create Script Wizard: </p> <ol type="a"> <li> <p>For Script Name, enter <code>HT_EMP</code> and click <span class="bold">Next</span>. </p> </li> <li> <p>In Script, enter the following DDL: </p> <pre xml:space="preserve" class="oac_no_warn">CREATE TABLE ht_emp ( emp_id NUMBER primary key, emp_first_name VARCHAR2(30) not null, emp_middle_initial VARCHAR2(1), emp_last_name VARCHAR2(45) not null, emp_part_or_full_time VARCHAR2(1) not null check (emp_part_or_full_time in ('P','F')), emp_salary NUMBER, emp_dept VARCHAR2(20) check (emp_dept in ('SALES','ACCOUNTING', 'MANUFACTURING','HR')), emp_hiredate DATE, emp_manager NUMBER references ht_emp, emp_special_info VARCHAR2(2000), emp_telecommute VARCHAR2(1) check (emp_telecommute in ('Y')), rec_create_date DATE not null, rec_update_date date) / INSERT INTO ht_emp (emp_id, emp_first_name, emp_middle_initial, emp_last_name, emp_part_or_full_time, emp_salary, emp_dept, emp_hiredate, emp_manager, emp_special_info, emp_telecommute, rec_create_date) VALUES (1,'Scott','R','Tiger','F', 100000,'SALES',sysdate,null,'cell phone number is xxx.xxx.xxxx home phone is yyy.yyy.yyyy','Y', SYSDATE) / CREATE SEQUENCE ht_emp_seq start with 2 / CREATE OR REPLACE TRIGGER bi_ht_emp BEFORE INSERT ON ht_emp FOR EACH ROW BEGIN SELECT ht_emp_seq.nextval INTO :new.emp_id FROM DUAL; :new.rec_create_date := SYSDATE; END; / CREATE OR REPLACE TRIGGER bu_ht_emp BEFORE UPDATE ON ht_emp FOR EACH ROW BEGIN :new.rec_update_date := SYSDATE; END; / </pre> </li> <li> <p>Click <span class="bold">Create Script</span>. </p> <p>The script appears in the Script Repository. </p> </li> </ol> </li> <li> <p>Run the HT_EMP script: </p> <ol type="a"> <li> <p>In the Script Repository, click <span class="bold">Run</span> in the Actions column adjacent to the <code>HT_EMP</code> script. </p> </li> <li> <p>From Parse As, select the schema owner that was initially provisioned with your workspace. </p> </li> <li> <p>Click <span class="bold">Run Script</span>. </p> <p>Red text indicates errors while executing the file. </p> </li> </ol> </li> </ol> </div><!-- class="sect2" --> <a id="CIHDGGGA" name="CIHDGGGA"></a> <div class="sect2"> <!-- infolevel=all infotype=General --><a id="sthref66" name="sthref66"></a> <h3>Create a New Page Containing a Input Form </h3> <p>Next, create a new form using the Form on a Table or View Wizard. </p> <p>To create a data input form: </p> <ol type="1" start="1"> <li> <p>Navigate to the Workspace home page. </p> </li> <li> <p>From the Available Applications list, select <span class="bold">Sample Application</span>. </p> </li> <li> <p>Click <span class="bold">Create Page</span>. </p> </li> <li> <p>On Create New Page, select <span class="bold">Page with Component</span> and click <span class="bold">Next</span>. </p> </li> <li> <p>On Select Component Type, select <span class="bold">Form</span> and click <span class="bold">Next</span>. </p> </li> <li> <p>On Create Page, select <span class="bold">Form on a Table or View</span> and click <span class="bold">Next</span>. </p> </li> <li> <p>For Table/View Owner, select the schema owner used to create the HT_EMP table and click <span class="bold">Next</span>. </p> </li> <li> <p>For Table/View Name, select the <span class="bold">HT_EMP</span> table and click <span class="bold">Next</span>. </p> </li> <li> <p>On Identify Page and Region Attributes: </p> <ol type="a"> <li> <p>For Page, enter <code>900</code>. </p> </li> <li> <p>For the Page Name, enter <code>HT_EMP</code>. </p> </li> <li> <p>For the Region Name, enter <code>How to Layout a Form</code>. </p> </li> <li> <p>Click <span class="bold">Next</span>. </p> </li> </ol> </li> <li> <p>On Identify Tab, accept the default <span class="bold">Do not use tabs</span> and click <span class="bold">Next</span>. </p> </li> <li> <p>On Identify Primary Key, accept the default and click <span class="bold">Next</span>. </p> <p>Note that the wizard reads the primary key from the database definition. </p> </li> <li> <p>On Primary Key Default, accept the default <span class="bold">Existing Trigger </span>and click <span class="bold">Next</span>. </p> </li> <li> <p>On Identify Columns to Include, select all columns and click <span class="bold">Next</span>. </p> </li> <li> <p>On Identify Process Options, accept the defaults and click <span class="bold">Next</span>. </p> </li> <li> <p>On Identify Branching, set all branching to the page 900 (the page you are creating) and click <span class="bold">Next</span>. </p> <p>Since this page is just for demonstration, you will not be utilizing branching. </p> </li> <li> <p>Click <span class="bold">Finish</span>. </p> </li> <li> <p>View the Page Definition by clicking <span class="bold">Edit Page.</span> </p> <p>The Page Definition for page 900 appears. </p> </li> <li> <p>Delete the following validation: </p> <ul> <li type="disc"> <p>Under Page Processing Validations, select <span class="bold">P900_REC_CREATE_DATE not null</span>. </p> </li> <li type="disc"> <p>Click <span class="bold">Delete</span>. </p> </li> </ul> </li> </ol> </div><!-- class="sect2" --> <a id="CIHDCIDJ" name="CIHDCIDJ"></a> <div class="sect2"> <!-- infolevel=all infotype=General --><a id="sthref67" name="sthref67"></a> <h3>Run the Page </h3> <p>Once you create the <code>HT_EMP</code> table and page 900, the next step is to run the page. </p> <p>To run the page from the Page Definition: </p> <ol type="1" start="1"> <li> <p>Click the <span class="bold">Run Page</span> icon in the upper right corner. </p> </li> <li> <p>If prompted to enter a username and password: </p> <ol type="a"> <li> <p>For User Name, enter either <code>demo</code> or <code>admin</code>. </p> </li> <li> <p>For Password, enter the name of the current workspace using all lowercase letters. </p> </li> <li> <p>Click <span class="bold">Login</span>. </p> </li> <li> <p>Navigate to page 900: </p> <ul> <li type="circle"> <p>Select <span class="bold">Edit Page</span> from the Developer Toolbar. </p> </li> <li type="circle"> <p>In Page, enter <span class="bold">900</span> and click <span class="bold">Go</span>. </p> </li> </ul> </li> <li> <p>On the Page Definition for page 900, click the <span class="bold">Run Page</span> icon in the upper right corner. </p> </li> </ol> </li> </ol> <p>As shown in <a href="#CHDEAIED">Figure 4-1</a>, note that the <code>HT Emp</code> form contains basic employee details and includes select lists, text areas, and display only items. </p> <div class="figure"> <a id="CHDEAIED" name="CHDEAIED"></a><a id="sthref68" name="sthref68"></a> <p class="titleinfigure">Figure 4-1 HT_EMP Form</p> <img src="./img/frm_htemp.gif" alt="Description of frm_htemp.gif follows" title="Description of frm_htemp.gif follows"/> <br /><a id="sthref69" name="sthref69" href="./img_text/frm_htemp.htm">Description of the illustration frm_htemp.gif</a> <br /><br /> </div><!-- class="figure" --> <p>By default, the Primary Key column does not display since it is assumed that the primary key is system generated. In reality, the primary key is included in the page, but appears as a hidden item. </p> <p>Notice that the page defaults with one item for each row and labels display to the left of the items. The item labels default to the column names with initial capitalization and with the underscores (_) replaced with spaces. You can override this default behavior by configuring user interface defaults for the table. </p> <p>Also notice that items based on date columns default to include a date picker. Lastly, notice that the Emp Special Info item was created as a text area because of the size of the base column. This item type is a better choice for large text items since it allows for wrapping of input text. </p> </div><!-- class="sect2" --> </div><!-- class="sect1" --> <a id="CIHIABHI" name="CIHIABHI"></a> <div class="sect1"> <!-- infolevel=all infotype=General --><a id="sthref70" name="sthref70"></a> <h2>Changing the Appearance of a Page by Altering Region Attributes </h2> <p>You can alter the appearance of a page by changing the region attributes. </p> <p>To change the region title and other region level attributes: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. Click <span class="bold">Edit Page 900</span> on the Developer Toolbar. </p> </li> <li> <p>Under Regions, select <span class="bold">How to Layout a Form</span>. </p> <p>The Region Definition appears. </p> </li> <li> <p>Change the Title to <code>Employee Info</code>. </p> </li> <li> <p>From Display Point, temporarily move the region by selecting <span class="bold">Page Template Region Position 3</span>. </p> <p>This moves the region to the right side of the page. The region display points are determined by the page level template. If you do not select a page level template, Oracle HTML DB uses the default page level template defined in the current theme. You can view specific positions by selecting the flashlight icon to the right of the Display Point list. </p> <p>Next, temporarily change the region template. </p> </li> <li> <p>From Template select <span class="bold">Borderless Region</span>. </p> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> <li> <p>From the Page Definition, click the <span class="bold">Run</span> <span class="bold">Page</span> icon. (See <a href="#CHDIHEIA">Figure 4-2</a>.) </p> <div class="figure"> <a id="CHDIHEIA" name="CHDIHEIA"></a><a id="sthref71" name="sthref71"></a> <p class="titleinfigure">Figure 4-2 HT_EMP Form with New Template</p> <img src="./img/frm_reg_att.gif" alt="Description of frm_reg_att.gif follows" title="Description of frm_reg_att.gif follows"/> <br /><a id="sthref72" name="sthref72" href="./img_text/frm_reg_att.htm">Description of the illustration frm_reg_att.gif</a> <br /><br /> </div><!-- class="figure" --> </li> </ol> <p>To return the region template and display point to the original selections: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. Click <span class="bold">Edit Page 900</span> on the Developer Toolbar. </p> </li> <li> <p>Under Regions, select <span class="bold">Employee Info</span>. </p> </li> <li> <p>From the Template list, select <span class="bold">Form Region</span>. </p> </li> <li> <p>From the Display Point List, select <span class="bold">Page Template Body (3. Items above region content)</span>. </p> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> </ol> </div><!-- class="sect1" --> <a id="CIHCGHBH" name="CIHCGHBH"></a> <div class="sect1"> <!-- infolevel=all infotype=General --><a id="sthref73" name="sthref73"></a> <h2>Understanding How Item Attributes Effect Page Layout </h2> <p>Item attributes control the display of items on a page. Item attributes determine where a label displays, how large an item will be as well as whether the item displays next to or below a previous item. You can change multiple item labels at once on the Page Items summary page. </p> <p class="subhead2">Topics:</p> <ul> <li type="disc"> <p><a href="#CIHIAFDG">Edit Item Attributes</a> </p> </li> <li type="disc"> <p><a href="#CIHICIFA">Fix Item Alignment</a> </p> </li> <li type="disc"> <p><a href="#CIHJGGFD">Change Label Placement</a> </p> </li> <li type="disc"> <p><a href="#CIHDFGDI">Change Items to Display-only</a> </p> </li> </ul><a id="CIHIAFDG" name="CIHIAFDG"></a> <div class="sect2"> <!-- infolevel=all infotype=General --><a id="sthref74" name="sthref74"></a> <h3>Edit Item Attributes </h3> <p>To edit item attributes: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>On the Page Definition, select the title <span class="bold">Items</span>. </p> <p>The Page Items summary page appears. </p> <p>You change how a page appears by editing the item attributes. Common item attribute changes include: </p> <ul> <li type="disc"> <p>Changing item labels by editing the Prompt field. </p> </li> <li type="disc"> <p>Placing more than one item in certain rows to group like items together. For example, you could group all items that make up an employee's name. </p> </li> <li type="disc"> <p>Changing the item width. Many items display better when they have a width that is less than the maximum. To change the item width, enter a new value in the Width field. </p> </li> <li type="disc"> <p>Reordering the items. The initial order of items is based on the order of the columns in the table on which the region is based. You can reorder items by changing the sequence. You can reorder items by entering a new value in the Sequence field. </p> </li> </ul> </li> <li> <p>To see the how item attributes affect page layout, make the following changes: </p> <ol type="a"> <li> <p>Change the values in the Prompt, New Line, and Width fields to match those in <a href="#CIHDFDIJ">Table 4-1</a>: </p> <div class="tblFormal"> <a id="sthref75" name="sthref75"></a><a id="CIHDFDIJ" name="CIHDFDIJ"></a> <p class="titleintable">Table 4-1 New Prompt, New Line, and Width Field Values</p> <table class="Formal" title="New Prompt, New Line, and Width Field Values" summary="This tables describes new Prompt, New Line, and Width field values. Changing these attributes affects page layout." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t2">Prompt Field </th> <th align="left" valign="bottom" id="r1c2-t2">New Line </th> <th align="left" valign="bottom" id="r1c3-t2">Width </th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t2" headers="r1c1-t2">Emp ID </td> <td align="left" headers="r2c1-t2 r1c2-t2">Yes </td> <td align="left" headers="r2c1-t2 r1c3-t2">30 </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t2" headers="r1c1-t2">First Name </td> <td align="left" headers="r3c1-t2 r1c2-t2">Yes </td> <td align="left" headers="r3c1-t2 r1c3-t2">15 </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t2" headers="r1c1-t2">Middle Initial </td> <td align="left" headers="r4c1-t2 r1c2-t2">No </td> <td align="left" headers="r4c1-t2 r1c3-t2">2 </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t2" headers="r1c1-t2">Last Name </td> <td align="left" headers="r5c1-t2 r1c2-t2">No </td> <td align="left" headers="r5c1-t2 r1c3-t2">15 </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t2" headers="r1c1-t2">Part or Full Time </td> <td align="left" headers="r6c1-t2 r1c2-t2">Yes </td> <td align="left" headers="r6c1-t2 r1c3-t2">2 </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t2" headers="r1c1-t2">Salary </td> <td align="left" headers="r7c1-t2 r1c2-t2">Yes </td> <td align="left" headers="r7c1-t2 r1c3-t2">10 </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t2" headers="r1c1-t2">Department </td> <td align="left" headers="r8c1-t2 r1c2-t2">Yes </td> <td align="left" headers="r8c1-t2 r1c3-t2">15 </td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t2" headers="r1c1-t2">Hire Date </td> <td align="left" headers="r9c1-t2 r1c2-t2">Yes </td> <td align="left" headers="r9c1-t2 r1c3-t2">10 </td> </tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t2" headers="r1c1-t2">Manager </td> <td align="left" headers="r10c1-t2 r1c2-t2">No </td> <td align="left" headers="r10c1-t2 r1c3-t2">15 </td> </tr> <tr align="left" valign="top"> <td align="left" id="r11c1-t2" headers="r1c1-t2">Special Information </td> <td align="left" headers="r11c1-t2 r1c2-t2">Yes </td> <td align="left" headers="r11c1-t2 r1c3-t2">60 </td> </tr> <tr align="left" valign="top"> <td align="left" id="r12c1-t2" headers="r1c1-t2">Telecommute </td> <td align="left" headers="r12c1-t2 r1c2-t2">Yes </td> <td align="left" headers="r12c1-t2 r1c3-t2">2 </td> </tr> <tr align="left" valign="top"> <td align="left" id="r13c1-t2" headers="r1c1-t2">Record Create Date </td> <td align="left" headers="r13c1-t2 r1c2-t2">Yes </td> <td align="left" headers="r13c1-t2 r1c3-t2">10 </td> </tr> <tr align="left" valign="top"> <td align="left" id="r14c1-t2" headers="r1c1-t2">Record Update Date </td> <td align="left" headers="r14c1-t2 r1c2-t2">Yes </td> <td align="left" headers="r14c1-t2 r1c3-t2">10 </td> </tr> </tbody> </table><br /> </div><!-- class="tblFormal" --> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> <li> <p>Click the <span class="bold">Run Page</span> icon. (See <a href="#CHDBFDEJ">Figure 4-3</a>.) </p> <div class="figure"> <a id="CHDBFDEJ" name="CHDBFDEJ"></a><a id="sthref76" name="sthref76"></a> <p class="titleinfigure">Figure 4-3 HT_EMP After Editing the Prompt, New Line, Width Attributes</p> <img src="./img/frm_chg_item.gif" alt="Description of frm_chg_item.gif follows" title="Description of frm_chg_item.gif follows"/> <br /><a id="sthref77" name="sthref77" href="./img_text/frm_chg_item.htm">Description of the illustration frm_chg_item.gif</a> <br /><br /> </div><!-- class="figure" --> </li> </ol> <p>Note that some items are pushed too far to the right. This display is caused by the width of the Special Information item. Oracle HTML DB lays out regions as tables and of a width of each column is determined by the largest display width of the items in that column. </p> </li> </ol> </div><!-- class="sect2" --> <a id="CIHICIFA" name="CIHICIFA"></a> <div class="sect2"> <!-- infolevel=all infotype=General --><a id="sthref78" name="sthref78"></a> <h3>Fix Item Alignment </h3> <p>There are several approaches to fixing item alignment: </p> <ul> <li type="disc"> <p>For the items Middle Initial, Last Name and Manager items, set New Field to equal No. </p> <p>This places the items directly after the items they follow, but in the same column. This approach is best used for positioning embedded buttons next to items. Note that this setting can make text items appear squashed. </p> </li> <li type="disc"> <p>Change the Column Span field of the Special Information item. </p> <p>For example, setting the Column Span for the Special Information item to 5 would enable multiple items to display above and below it. This change causes five items to display above Special Information (First Name, Middle Initial, and Last Name). </p> <p>Be aware, however, that using Column Span to fix the display of the name does not result in a consistent layout. The Manager item would still be in the same column as Middle Initial. Because the Manager item is larger than Middle Initial, Last Name would still be pushed too far to the right. To fix this, you could change the Column Span of the Manager item to 3 so it displays above Special Information. </p> </li> <li type="disc"> <p>Reset the column width in the middle of the region by adding an item of type <span class="bold">Stop and Start HTML Table.</span> This forces the close of an HTML table using the <code></table></code> tag and starts a new HTML table. Inserting a Stop and Start HTML Table item just after the Last Name item, results in an even layout. Note that a Stop and Start HTML Table item only displays its label. You can prevent the label from displaying at all by setting it to null. To do this, you simply remove the defaulted label. </p> </li> </ul> <p>To add a Stop and Start HTML Table item and reset the column width: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>Under Items, click the <span class="bold">Create</span> icon. </p> </li> <li> <p>From the Tasks list, select <span class="bold">Create "stop and start" HTML table control</span>. </p> <p>The Create Page Item wizard appears. </p> </li> <li> <p>On Identify Item Name and Display Position: </p> <ol type="a"> <li> <p>In Sequence, enter <code>4.5</code>. </p> </li> <li> <p>From Region, select <span class="bold">Employee Info</span>. </p> </li> <li> <p>Click <span class="bold">Next</span>. </p> </li> </ol> </li> <li> <p>On Identify Item Attributes: </p> <ol type="a"> <li> <p>For Label, remove <code>X</code>. </p> </li> <li> <p> Accept all other defaults and click <span class="bold">Next</span>. </p> </li> </ol> </li> <li> <p>Click <span class="bold">Create Item</span>. </p> <p>The Page Definition appears. </p> </li> <li> <p>Click the title <span class="bold">Items</span>. </p> </li> <li> <p>For Special Information, change the Column Span to <span class="bold">3</span> and click <span class="bold">Apply Changes</span>. </p> </li> <li> <p>Click the <span class="bold">Run Page</span> icon. </p> </li> </ol> </div><!-- class="sect2" --> <a id="CIHJGGFD" name="CIHJGGFD"></a> <div class="sect2"> <!-- infolevel=all infotype=General --><a id="sthref79" name="sthref79"></a> <h3>Change Label Placement </h3> <p>Item labels can display above, below, or to the left of an item. Labels can display left, right, or center justified. For labels set to left, you can further specify the vertical alignment options of top, bottom or center. Change the position of the Special Information label to above the item. </p> <p>To change the placement of the Special Information label: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>Under Items, select the name of item <span class="bold">P900_EMP_SPECIAL_INFO</span>. </p> </li> <li> <p>Scroll down to Label. </p> </li> <li> <p>From the Horizontal/Vertical Alignment list, select <span class="bold">Above</span>. </p> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> </ol> </div><!-- class="sect2" --> <a id="CIHDFGDI" name="CIHDFGDI"></a> <div class="sect2"> <!-- infolevel=all infotype=General --><a id="sthref80" name="sthref80"></a> <h3>Change Items to Display-only </h3> <p>There are two columns in the <code>HT_EMP</code> table for auditing, Record Create Date and Record Update Date. Because the values of these columns are set with triggers, these columns should not be updatable by users. This exercise describes how to make items display-only and then how to add them to their own region. </p> <p>To make an item P900_REC_CREATE_DATE display-only: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>Under Items, select the item <span class="bold">P900_REC_CREATE_DATE</span>. </p> </li> <li> <p>Under Display As, select <span class="bold">Text Field (Disabled, saves state)</span>. </p> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> </ol> <p>To make an item P900_REC_UPDATE_DATE display-only: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>Under Items, select the item <span class="bold">P900_REC_UPDATE_DATE</span>. </p> </li> <li> <p>Under Display As, select <span class="bold">Text Field (Disabled, saves state)</span>. </p> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> </ol> <p>Next, create a new region and then move the audit items into that region. </p> <p>To create a new region: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>Under Regions, click the <span class="bold">Create</span> icon. </p> </li> <li> <p>On Identify Region Type, select <span class="bold">HTML</span> and click <span class="bold">Next</span>. </p> </li> <li> <p>On Region Type, select <span class="bold">HTML</span> and click <span class="bold">Next</span>. </p> </li> <li> <p>For the Title, enter <code>Audit Information</code> and click <span class="bold">Next</span>. </p> </li> <li> <p>Click <span class="bold">Create Region</span>. </p> </li> </ol> <p>To move the items to the new region: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>Select the heading <span class="bold">Items</span>. </p> <p>A summary page appears. </p> </li> <li> <p>For <code>P900_REC_CREATE_DATE</code> and <code>P900_REC_UPDATE_DATE</code>: </p> <ol type="a"> <li> <p>Under Prompt, add a colon to the end of the label name. </p> </li> <li> <p>Under Region, select <span class="bold">Audit Information</span>. </p> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> </ol> </li> </ol> <p><a href="#CHDICJAA">Figure 4-4</a> demonstrates how these items would display in a running page. </p> <div class="figure"> <a id="CHDICJAA" name="CHDICJAA"></a><a id="sthref81" name="sthref81"></a> <p class="titleinfigure">Figure 4-4 Audit Information Region</p> <img src="./img/frm_audit.gif" alt="Description of frm_audit.gif follows" title="Description of frm_audit.gif follows"/> <br /><a id="sthref82" name="sthref82" href="./img_text/frm_audit.htm">Description of the illustration frm_audit.gif</a> <br /><br /> </div><!-- class="figure" --> <p>The Hide/Show Region template enables the user to click a plus (+) sign to expand the contents of the region or click a minus (-) sign to hide the contents. By changing the region template to Hide/Show Region, users can decide whether they wish to see the Audit Information region. </p> <p>To change the region template to Hide/Show Region: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>Under Regions, select <span class="bold">Audit Information</span>. </p> </li> <li> <p>Under User Interface Attributes, select <span class="bold">Hide and Show Region</span> from the Template list. </p> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> </ol> </div><!-- class="sect2" --> </div><!-- class="sect1" --> <a id="CIHEAJFJ" name="CIHEAJFJ"></a> <div class="sect1"> <!-- infolevel=all infotype=General --><a id="sthref83" name="sthref83"></a> <h2>Adding a Region Header and Footer </h2> <p>Regions can have headers and footers. Headers and footers typically contain text or HTML that displays at either the top or bottom of the region. </p> <p>To add a region footer: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>Under Regions, select <span class="bold">Audit Information</span>. </p> </li> <li> <p>Scroll down to Header and Footer Text. </p> </li> <li> <p>Enter the following in Region Footer: </p> <pre xml:space="preserve" class="oac_no_warn"><i>The Record Create Date is the date that the record was initially entered in to the system. <br>The Record Update Date is the date that the record the record was last updated.</i> </pre> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> <li> <p>Run the page. </p> </li> <li> <p>Expand the Audit Information region. </p> <div class="figure"> <a id="sthref84" name="sthref84"></a> <p class="titleinfigure">Figure 4-5 Audit Information Region with Footer</p> <img src="./img/frm_reg_foot.gif" alt="Description of frm_reg_foot.gif follows" title="Description of frm_reg_foot.gif follows"/> <br /><a id="sthref85" name="sthref85" href="./img_text/frm_reg_foot.htm">Description of the illustration frm_reg_foot.gif</a> <br /><br /> </div><!-- class="figure" --> </li> </ol> <p>As shown in, the text of the footer is wrapped with the italic HTML tag and there is an imbedded a break. Without the manual break, the text would take up the entire width of the region (as defined by region template). </p> </div><!-- class="sect1" --> <a id="CIHJDJAB" name="CIHJDJAB"></a> <div class="sect1"> <!-- infolevel=all infotype=General --><a id="sthref86" name="sthref86"></a> <h2>Making a Region Conditional </h2> <p>To accomplish this, you create a display condition for the Audit Information region so that it only displays if the Employee ID is not null. Since the Employee ID is set by a trigger, it only exists for records retrieved from the database. You can control the display of the Audit Information region by using a built-in condition that checks for the presence of a value for the item containing the Employee ID (that is, P900_EMP_ID) </p> <p>To display the Audit Information region conditionally: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>Under Regions, select <span class="bold">Audit Information</span>. </p> </li> <li> <p>When the Region Definition appears, scroll down to Conditional Display. </p> </li> <li> <p>Under Conditional Display: </p> <ol type="a"> <li> <p>From the Conditional Display list, select <span class="bold">Value of Item in Expression 1 is NOT NULL</span>. </p> </li> <li> <p>In Expression 1, enter: </p> <pre xml:space="preserve" class="oac_no_warn">P900_EMP_ID </pre> </li> </ol> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> </ol> </div><!-- class="sect1" --> <a id="CIHDJCGI" name="CIHDJCGI"></a> <div class="sect1"> <!-- infolevel=all infotype=General --><a id="sthref87" name="sthref87"></a> <h2>Adding Another Region for HTML Text </h2> <p>You have the option of displaying regions in columns as well as in rows. This exercise explains how to create another region to display hint text to the user. </p> <p>To create a region to display hint text: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>Under Regions, click the <span class="bold">Create</span> icon. </p> </li> <li> <p>On Identify Region Type, select <span class="bold">HTML</span> and click <span class="bold">Next</span>. </p> </li> <li> <p>On Region Type, select <span class="bold">HTML</span> and click <span class="bold">Next</span>. </p> </li> <li> <p>On Identify Region Attributes: </p> <ol type="a"> <li> <p>In Title, enter <code>Hint</code>. </p> </li> <li> <p>From Region Template, select <span class="bold">Sidebar Region</span>. </p> </li> <li> <p>From Column, select <span class="bold">2</span>. </p> </li> <li> <p>Click <span class="bold">Next</span>. </p> </li> </ol> </li> <li> <p>In Enter HTML Text Region Source, enter the following: </p> <pre xml:space="preserve" class="oac_no_warn">Use this page to enter and<br> maintain employee information. </pre> </li> <li> <p>Click <span class="bold">Create Region</span>. </p> </li> <li> <p>Run the page. (See <a href="#CHDJBHEE">Figure 4-6</a>.) </p> <div class="figure"> <a id="CHDJBHEE" name="CHDJBHEE"></a><a id="sthref88" name="sthref88"></a> <p class="titleinfigure">Figure 4-6 Page 900 with Hint Region</p> <img src="./img/frm_hint.gif" alt="Description of frm_hint.gif follows" title="Description of frm_hint.gif follows"/> <br /><a id="sthref89" name="sthref89" href="./img_text/frm_hint.htm">Description of the illustration frm_hint.gif</a> <br /><br /> </div><!-- class="figure" --> </li> </ol> </div><!-- class="sect1" --> <a id="CIHBHHGE" name="CIHBHHGE"></a> <div class="sect1"> <!-- infolevel=all infotype=General --><a id="sthref90" name="sthref90"></a> <h2>Changing Item Types </h2> <p>This exercise describes how to change item types to make data entry easier for the user. To change an item type, navigate to the Item attributes page and select another Display As option. </p> <p class="subhead2">Topics:</p> <ul> <li type="disc"> <p><a href="#CIHEHEHB">Change an Item to a Radio Group</a> </p> </li> <li type="disc"> <p><a href="#CIHFACDA">Change an Item to a Select List</a> </p> </li> <li type="disc"> <p><a href="#CIHEIDHF">Change an Item to a Check Box</a> </p> </li> </ul><a id="CIHEHEHB" name="CIHEHEHB"></a> <div class="sect2"> <!-- infolevel=all infotype=General --><a id="sthref91" name="sthref91"></a> <h3>Change an Item to a Radio Group </h3> <p>Because the Part or Full-time item only has two valid choices, this item is a good candidate for either a check box or a radio group. </p> <p>To change the Part or Full-time item to a radio group: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition. </p> </li> <li> <p>Under Items, select <span class="bold">P900_EMP_PART_OR_FULL_TIME</span>. </p> </li> <li> <p>From Display As, select <span class="bold">Radiogroup</span>. </p> </li> <li> <p>For Label, remove the label text. (It will be redundant.) </p> </li> <li> <p>Under List of Values, create a static list of values: </p> <ul> <li type="disc"> <p>From Named LOV, select <span class="bold">Select Named LOV</span> </p> </li> <li type="disc"> <p>In List of values definition, enter: </p> <pre xml:space="preserve" class="oac_no_warn">STATIC:Full-time;F,Part-time;P </pre> </li> </ul> <p>This definition will display as two radio buttons with the labels <span class="bold">Full-time</span> and <span class="bold">Part-time</span>, but the value that being inserted into the database will be either F or P. </p> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> <li> <p> Run the page. (See <a href="#CIHHIGED">Figure 4-7</a>.) </p> </li> </ol> <div class="figure"> <a id="CIHHIGED" name="CIHHIGED"></a><a id="sthref92" name="sthref92"></a> <p class="titleinfigure">Figure 4-7 Part or Full-time item Changed to a Radio Group</p> <img src="./img/frm_radio.gif" alt="Description of frm_radio.gif follows" title="Description of frm_radio.gif follows"/> <br /><a id="sthref93" name="sthref93" href="./img_text/frm_radio.htm">Description of the illustration frm_radio.gif</a> <br /><br /> </div><!-- class="figure" --> <p>Notice that Full-time and Part-time displays as radio group that is stacked in one column. You can have these button display side by side. </p> <p>To display the Full-time and Part-time radio buttons display side by side: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>Under Items, select <span class="bold">P900_EMP_PART_OR_FULL_TIME</span>. </p> </li> <li> <p>Scroll down to Lists of Values. </p> </li> <li> <p>Set Columns to <span class="bold">2</span>. </p> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> </ol> <p>By changing this setting to match the number of valid values (that is, Full-time and Part-time), the values display side by side. </p> </div><!-- class="sect2" --> <a id="CIHFACDA" name="CIHFACDA"></a> <div class="sect2"> <!-- infolevel=all infotype=General --><a id="sthref94" name="sthref94"></a> <h3>Change an Item to a Select List </h3> <p>In the DDL you used to create the <code>HT_EMP</code> table, Department is validated by a check constraint. You can implement Department as a radio group, a select list, or a Popup LOV. </p> <p>To change Department to a select list: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>Under Items, select <span class="bold">P900_EMP_DEPT</span>. </p> </li> <li> <p>From Display As, select <span class="bold">Select List</span>. </p> <p>The other Select List choices are for either redirecting the user to another page or URL based on the selection, or submitting the current page which is used when other information needs to be retrieved based upon the selection in the Select List. </p> </li> <li> <p>Under Lists of Values, create a static list of values: </p> <ol type="a"> <li> <p>From Named LOV, select <span class="bold">Select Named LOV</span> </p> </li> <li> <p>In List of values definition, enter: </p> <pre xml:space="preserve" class="oac_no_warn">STATIC:SALES,ACCOUNTING,MANUFACTURING,HR </pre> </li> <li> <p>From Display Null, select <span class="bold">Yes</span>. </p> </li> <li> <p>In Null display value, enter: </p> <pre xml:space="preserve" class="oac_no_warn">- No Assignment - </pre> <p>The last two selections take into account that the <code>EMP_DEPT</code> column can contain nulls. As a best practice, whenever you implement a select list and have a column that can be null, you should set Display Null to Yes. Failure to do so, results in the item defaulting to the first item in the select list. </p> </li> </ol> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> <li> <p>Run the page. (See <a href="#CHDFDDDC">Figure 4-8</a>.) </p> </li> </ol> <div class="figure"> <a id="CHDFDDDC" name="CHDFDDDC"></a><a id="sthref95" name="sthref95"></a> <p class="titleinfigure">Figure 4-8 Department Changed to a Select List</p> <img src="./img/frm_sel_list.gif" alt="Description of frm_sel_list.gif follows" title="Description of frm_sel_list.gif follows"/> <br /><a id="sthref96" name="sthref96" href="./img_text/frm_sel_list.htm">Description of the illustration frm_sel_list.gif</a> <br /><br /> </div><!-- class="figure" --> </div><!-- class="sect2" --> <a id="CIHEIDHF" name="CIHEIDHF"></a> <div class="sect2"> <!-- infolevel=all infotype=General --><a id="sthref97" name="sthref97"></a> <h3>Change an Item to a Check Box </h3> <p>The item Telecommute is ideal for a check box. When you change the Display Type, you can also move it up on the page and place is next to the Full-time and Part-time radio group. </p> <p>To change Telcommute to a check box: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>Under Items, select <span class="bold">P900_EMP_TELECOMMUTE</span>. </p> </li> <li> <p>From Display As, select <span class="bold">Checkbox</span>. </p> </li> <li> <p>Under Displayed: </p> <ol type="a"> <li> <p>In Sequence, enter <code>5.5</code>. </p> </li> <li> <p>From Begin on New Line, select <span class="bold">No</span> </p> </li> </ol> </li> <li> <p>Scroll down to List of Values. </p> </li> <li> <p>To have the label precede the check box: </p> <ol type="a"> <li> <p>From Named LOV, select <span class="bold">Select Named LOV</span> </p> </li> <li> <p>In List of values definition, enter: </p> <pre xml:space="preserve" class="oac_no_warn">STATIC:;Y </pre> <p>This displays the check box after the label, but will not display a value associated with the check box. If the check box is checked, the value passed to the database will be Y. </p> </li> </ol> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> <li> <p>Run the page. </p> </li> </ol> </div><!-- class="sect2" --> </div><!-- class="sect1" --> <a id="CIHGIJCB" name="CIHGIJCB"></a> <div class="sect1"> <!-- infolevel=all infotype=General --><a id="sthref98" name="sthref98"></a> <h2>About Label Templates </h2> <p>You can control the look of an item label by using a label template. <span class="italic">Sample Application</span> includes two label templates: </p> <ul> <li type="disc"> <p>Required Label </p> </li> <li type="disc"> <p>Not Required Label </p> </li> </ul> <p>The Required Label template prepends a red asterisk (*) to the label. You may also create your own label templates to control the look of labels using different fonts, borders, backgrounds, and images. </p> <p>To change to a different label template: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>Under Items, select an item name. </p> </li> <li> <p>Scroll down to Label and make a selection from the Template list. </p> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> <li> <p>Run the page. </p> </li> </ol> </div><!-- class="sect1" --> <a id="CIHDEGBI" name="CIHDEGBI"></a> <div class="sect1"> <!-- infolevel=all infotype=General --><a id="sthref99" name="sthref99"></a> <h2>Changing Buttons </h2> <p>The wizard that created the form in this tutorial also created buttons. These buttons display conditionally based upon whether the page is being used to create a new record (that is <code>P900_EMP_ID</code> equals null), or the page is being used to update an existing record. These buttons were created as HTML buttons and positioned at the top of the region. </p> <p>You can also position buttons at the bottom of the region, to the left or right of the page title, above the region, below the region, or in any button position defined in the region template. </p> <p>To change a button position: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition for page 900. </p> </li> <li> <p>Click the heading <span class="bold">Buttons</span>. </p> </li> <li> <p>Make a new selection from the Position column. </p> </li> <li> <p>Click <span class="bold">Apply Changes</span>. </p> </li> <li> <p>Run the page. </p> </li> </ol> <p>Buttons can also have templates associated with them to refine how they look. </p> </div><!-- class="sect1" --> <a id="CIHFABJA" name="CIHFABJA"></a> <div class="sect1"> <!-- infolevel=all infotype=General --><a id="sthref100" name="sthref100"></a> <h2>Running the Page for Update </h2> <p>You can run the page and provide it with an Employee ID to retrieve. Typically, this would be done with a link from a report page but for this example, run the page and add <code>::::P900_EMP_ID:1</code> to the end of the URL. For example: </p> <pre xml:space="preserve" class="oac_no_warn">http://marvel.oracle.com/pls/otn/f?p=9659:900:1284393467360777225::::P900_EMP_ID:1 </pre> <p>This will pass the value <code>1</code> to the item <code>P9000_EMP_ID</code>. If you run the page note that the Delete and Apply Changes buttons now display. The Create button appeared previously because the page was expecting a new record to be created. Also note a Record Create Date now appears. </p> </div><!-- class="sect1" --> <a id="CIHIGJHD" name="CIHIGJHD"></a> <div class="sect1"> <!-- infolevel=all infotype=General --><a id="sthref101" name="sthref101"></a> <h2>Making Data Bold </h2> <p>One way to make the information in a region easier to read, is to make the labels (or the data) more pronounced. You can accomplish this by changing the color, specifying another font, or using bold. To make a label bold, you could bold the data manually, or create a new label template. In the latter approach, you would create a new label template that would wrap the HTML tag for bold around the label and then associate that template with the items in the Audit Information region. </p> <p>To make data bold manually: </p> <ol type="1" start="1"> <li> <p>Navigate to the Page Definition. </p> </li> <li> <p>Under Items, select an item name. </p> </li> <li> <p>Scroll down to Element. </p> </li> <li> <p>In HTML Form Element Attributes, type: </p> <pre xml:space="preserve" class="oac_no_warn">class="fielddatabold" </pre> <p>This example references a class in the Cascading Style Sheet associated with this application. </p> </li> </ol> </div><!-- class="sect1" --> </div> <!-- Start Footer --> <div class="footer"> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td valign="bottom" width="33%"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100"> <tr><td> </td> <td align="center"> <a href="rprt_drill.htm"> <img src="./support/gifs/leftnav.gif" alt="Previous" border="0" /><br /><span class="icon">Previous</span></a> </td> <td align="center"> <a href="check_box.htm"> <img src="./support/gifs/rightnav.gif" alt="Next" border="0" /><br /><span class="icon">Next</span></a> </td> </tr> </table> </td> <td class="copyrightlogo"> <a href="./support/html/cpyr.htm"> <span class="copyrightlogo"> Copyright © 2005, Oracle. All rights reserved. </span> </a> </td> <td valign="bottom" align="right" width="33%"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="225"> <tr><td> </td> <td align="center" valign="top"><a href="toc.htm"><img src="./support/gifs/toc.gif" alt="Go To Table Of Contents" border="0" /><br /><span class="icon">Contents</span></a></td> </table> </td> </tr> </table> </div><!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de