Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\bldapp_wiz_using.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> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>About the Create Application Wizard</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T16:11:27Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="About the Create Application Wizard" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11947-01" /> <link rel="copyright" href="dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface.htm" title="Home" type="text/html" /> <link rel="up" href="bldapp.htm" title="Building an Application" type="text/html" /> <link rel="up" href="bldapp_wiz.htm" title="Creating an Application" type="text/html" /> <link rel="up" href="bldapp_wiz_using.htm" title="About the Create Applicatio..." type="text/html" /> <link rel="prev" href="bldapp_wiz_about.htm" title="Previous" type="text/html" /> <link rel="next" href="bldapp_wiz_spreadsheet.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="bldapp.htm" title="Building an Application">Building an Application</a> > <a href="bldapp_wiz.htm" title="Creating an Application">Creating an Application</a> > About the Create Applicatio...</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="bldapp_wiz_about.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_wiz_spreadsheet.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABGCJCH" name="BABGCJCH"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB25223" id="HTMDB25223"></a>About the Create Application Wizard</h1> <p>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.</p> <p>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.</p> <p>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.</p> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> "Building Queries with Query Builder"in <a href="AEUTL/qry_bldr.htm"><span class="italic">Oracle Application Express SQL Workshop and Utilities Guide</span></a> and "Leveraging Application Builder Defaults" in <a href="AEADM/wkspc_def.htm"><span class="italic">Oracle Application Express Administration Guide</span></a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Tutorials:</p> "Building Your Application" in <span class="italic"><a href="TDPAX/build_app.htm">Oracle Database 2 Day + Oracle Application Express Developer’s Guide</a></span> and <a href="http://www.oracle.com/pls/db112/lookup?id=HTMAD"><span class="italic">Oracle Application Express Advanced Tutorials</span></a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <a id="sthref770" name="sthref770"></a> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="#CEGEIHJF">Creating an Application Based on Tables or Queries</a></p> </li> <li> <p><a href="#CEGJEFAJ">About Application Models and User Interface Defaults</a></p> </li> <li> <p><a href="#CEGCEJJF">Leveraging Application Models and User Interface Defaults</a></p> </li> </ul> <a id="CEGEIHJF" name="CEGEIHJF"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25224" id="HTMDB25224"></a>Creating an Application Based on Tables or Queries<a id="sthref771" name="sthref771"></a><a id="sthref772" name="sthref772"></a></h2> <p>You can create an application based on a table, query, or drill-down query by selecting <span class="bold">Create Application</span> in the Create Application Wizard.</p> <p>To create an application based on a table, query, or drill-down query:</p> <ol> <li> <p>On the Workspace home page, click the <span class="bold">Application Builder</span> icon.</p> </li> <li> <p>Click the <span class="bold">Create</span> button.</p> </li> <li> <p>For Method, select <span class="bold">Create Application</span> and click <span class="bold">Next</span>.</p> </li> <li> <p>For Name, enter the following and click <span class="bold">Next</span>:</p> <ol> <li> <p>Name - Enter a name to identify the application.</p> </li> <li> <p>Application - Enter a unique integer value to identify the application.</p> </li> <li> <p>Create Application - Select a creation method:</p> <ul> <li> <p>Select <span class="bold">From scratch</span> to manually add all pages</p> </li> <li> <p>Select <span class="bold">Based on existing application design model</span> to copy page definitions from a previous application model.</p> <p>Note that you will still have to define all other application attributes, or you can choose to copy some attributes by choosing to copy shared components from another application (See step 7 and <a href="#CEGJEFAJ">"About Application Models and User Interface Defaults"</a>).</p> </li> </ul> </li> <li> <p><span class="bold">Schema</span> - Your application will obtain its privileges by parsing all SQL as a specific database schema. Identify the database schema owner.</p> </li> </ol> <p>Next, add pages to your application.</p> </li> <li> <p>For Pages:</p> <ol> <li> <p>Select the type of page you want to add. Options include:</p> <ul> <li> <p><span class="bold">Blank</span> creates a page with no built-in functionality.</p> </li> <li> <p><span class="bold">Report</span> creates a page that contains the formatted result of a SQL query. You can choose to build a report based on a table you select, or based on a custom SQL SELECT statement or a PL/SQL function returning a SQL SELECT statement that you provide.</p> </li> <li> <p><span class="bold">Form</span> creates a form to update a single row in a database table.</p> </li> <li> <p><span class="bold">Tabular Form</span> creates a form to perform update, insert, and delete operations on multiple rows in a database table.</p> </li> <li> <p><span class="bold">Master Detail</span> 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.</p> </li> <li> <p><span class="bold">Report and Form</span> builds a two page report and form combination. On the first page, users select a row to update. On the second page, users can add a record or update or delete an existing record.</p> </li> </ul> <p><span class="bold">Action</span> displays the currently selected page type. For each selection, the wizard prompts you for a different types of information, such as selecting a table name or report implementation.</p> <p>Report pages include the <span class="bold">Include Analysis Pages</span> check box. Select this option and follow the wizard prompts to extend a simple report or a report on a form to include multiple drill-down reports and charts.</p> </li> <li> <p>Click <span class="bold">Add Page</span>.</p> <p>The page (or pages) appear at the top of the page. To delete a page, click <span class="bold">Delete</span> icon.</p> </li> <li> <p>Repeat the previous steps until all pages have been added.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">Tip:</p> To exit this wizard early and utilize Application Builder Defaults, click the <span class="bold">Create</span> button. To configure Application Builder Defaults, see "Leveraging Application Builder Defaults" in <a href="AEADM/wkspc_def.htm"><span class="italic">Oracle Application Express Administration Guide</span></a>.</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </li> </ol> </li> <li> <p>For Tabs, determine whether to include tabs in your application and click <span class="bold">Next</span>.</p> </li> <li> <p>For Shared Components, determine whether to import shared components from another application. Shared components are common elements that can display or be applied on any page within an application.</p> <p>To include shared components, select the following:</p> <ol> <li> <p>Copy Shared Components from Another Application - Select <span class="bold">Yes</span>.</p> </li> <li> <p>Copy from Application - Select the application from which you want to import shared components.</p> </li> <li> <p>Select Components to Import - Select the components to import.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> <p>Next, select a default authentication scheme. Authentication is the process of establishing users' identities before they can access an application. See <a href="sec_authentication.htm#BABHIEIA">"Establishing User Identity Through Authentication"</a>.</p> </li> <li> <p>For Authentication Scheme, select one of the following:</p> <ul> <li> <p><span class="bold">Application Express</span> - Uses the user account credentials created and maintained with the Application Express Service Administration application. These are the accounts you use to log in to the Application Express development environment. You can also create accounts in this user account repository for end users of your applications.</p> </li> <li> <p><span class="bold">No Authentication</span> - Also known as database authentication, this option enables users to access your application using the account credentials stored in the <code>modplsql</code> DAD definition. In most cases this results in users not having to login when accessing your application. This is the quickest way to create a "public" application.</p> </li> <li> <p><span class="bold">Database Account</span> - Requires users logging into your application to enter a database schema name (or user name) and a password in order to authenticate. This account information is managed entirely within the Oracle database.</p> </li> </ul> </li> <li> <p>Next, select the following globalization preferences:</p> <ol> <li> <p>Language - Select the primary language for this application.</p> <p>This attribute identifies the language in which an application is developed. This language is the base language from which all translations are made.</p> </li> <li> <p>User Language Preference Derived From - Specifies how the engine determines the application language. The application primary language can be static (that is, derived from the Web browser language) or determined from a user preference or item. The database language setting determines date display and sorting characteristics.</p> <p>You can alter the Language and User Language Preference Derived From attributes later on the Edit Globalization attributes page. See <a href="bldr_attr_global.htm#CHDIIHHC">"Configuring Globalization Attributes"</a>.</p> </li> <li> <p>Date Format - Specifies the date format to be used in the application.</p> <p>This date format is used to alter the <code>NLS_DATE_FORMAT</code> database session setting before showing or submitting any page within the application. This value can be a literal string containing a valid Oracle date format mask or an item reference via substitution syntax. If no value is specified, the default date format is derived from the database session at runtime. If supplied, this is also used as the date format for any items resulting from columns of type <code>DATE</code>.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> </li> <li> <p>For User Interface, select a theme and click <span class="bold">Next</span>.</p> <p>Themes are collections of templates that can be used to define the layout and style of an entire application. See <a href="ui_themes.htm#BABJEDBB">"Managing Themes"</a>.</p> </li> <li> <p>Confirm your selections and click <span class="bold">Create</span>.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="CEGJEFAJ" name="CEGJEFAJ"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25225" id="HTMDB25225"></a>About Application Models and User Interface Defaults<a id="sthref773" name="sthref773"></a><a id="sthref774" name="sthref774"></a></h2> <p>The Create Application Wizard is designed with the assumption that the developer may run it multiple times. To facilitate this iterative approach to application development, every time you run the wizard it saves the page definitions to an application model.</p> <p>Consider the following example. You create an application by running the Create Application Wizard. After viewing the application, you realize it is not quite what you wanted. Instead of altering it, you can run the wizard again and select an application model. By selecting an existing application model when you rerun the wizard, you can quickly improve your application with minimal time and effort.</p> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> "Managing Application Models" in <a href="AEADM/aadm_mg_models.htm"><span class="italic">Oracle Application Express Administration Guide</span></a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <p>Another way to increase your productivity when creating an application is to specify user interface defaults. User interface defaults are metadata that enable you to assign default user interface properties to a table, column, or view within a specified schema.</p> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="ui_default.htm#CHDCIFCC">"Managing User Interface Defaults"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="CEGCEJJF" name="CEGCEJJF"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25226" id="HTMDB25226"></a>Leveraging Application Models and User Interface Defaults<a id="sthref775" name="sthref775"></a><a id="sthref776" name="sthref776"></a></h2> <p>You can increase your productivity when creating applications by leveraging application models and user interface defaults. Consider the following scenario:</p> <ol> <li> <p>Create an application based on tables or views by running the Create Application Wizard.</p> </li> <li> <p>Run the generated application. Note any functional deficiencies.</p> </li> <li> <p>Evaluate whether to create or edit user interface defaults.</p> <p>For example, you can use user interface defaults to control how form field or report labels display. You can also utilize user interface defaults to display specific columns or have columns display in an alternate order.</p> </li> <li> <p>Navigate to the Application home page and create an application by clicking <span class="bold">Create</span>.</p> </li> <li> <p>Select <span class="bold">Create Application</span>.</p> </li> <li> <p>When prompted to enter application details, specify the following:</p> <ol> <li> <p>Name - Enter a name to identify the application.</p> </li> <li> <p>Application - Enter a unique integer value to identify the application, or accept the default.</p> </li> <li> <p>Create Application - Select <span class="bold">Based on existing application design model</span>.</p> </li> </ol> </li> <li> <p>Select an application model.</p> <p>Note the pages you previously created already appear.</p> </li> <li> <p>Add pages, edit pages, or remove pages.</p> </li> <li> <p>Complete the wizard.</p> </li> <li> <p>Repeat steps 2 through 9 until the application meets your functional requirements.</p> </li> </ol> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="bldapp_wiz_about.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_wiz_spreadsheet.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de