Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEMIG\apm_recquery.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>Reviewing Retrieved Queries</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T18:4:45Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Reviewing Retrieved Queries" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12509-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="appmgr.htm" title="Migrating a Microsoft Acces..." type="text/html" /> <link rel="up" href="apm_howrevobj.htm" title="Step 5: Review Your Retriev..." type="text/html" /> <link rel="up" href="apm_recquery.htm" title="Reviewing Retrieved Queries" type="text/html" /> <link rel="prev" href="apm_rectables.htm" title="Previous" type="text/html" /> <link rel="next" href="apm_recforms.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="appmgr.htm" title="Migrating a Microsoft Acces...">Migrating a Microsoft Acces...</a> > <a href="apm_howrevobj.htm" title="Step 5: Review Your Retriev...">Step 5: Review Your Retriev...</a> > Reviewing Retrieved Queries</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="apm_rectables.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apm_recforms.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CBBJEGDG" name="CBBJEGDG"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="AEMIG114" id="AEMIG114"></a>Reviewing <a id="sthref61" name="sthref61"></a>Retrieved Queries</h1> <p>Next, review the queries retrieved from the Microsoft Access export. Application Migration identifies invalid queries as well as those without user interface defaults, which you can set before migration.</p> <p>After you update the views, select the ones you want to include in the migration. If you do not include a query, any forms or reports based on the query are excluded from the migration.</p> <p>To review retrieved queries:</p> <ol> <li> <p>From the project page, click <span class="bold">Queries</span>.</p> <p>The Queries page appears, showing the status of the objects ready for migration.</p> <p>For each Microsoft Access query, the Queries page shows:</p> <ul> <li> <p>Oracle View - The corresponding Oracle view, which defaults to the Microsoft Access query name in all capital letters.</p> <p>If the Microsoft Access object was not successfully migrated to Oracle, then this field will not have a corresponding Oracle view name. Instead, it will contain a link to a page where you can create a corresponding Oracle view.</p> </li> <li> <p>Status - Query status as either Valid or Invalid.</p> <p>Only valid queries can be included in the migration.</p> </li> <li> <p>UI Defaults - Indicates if user interface defaults are set for the query.</p> <p>User interface defaults are used by Oracle Application Express to populate initial values for region and item properties. Using user interface defaults provides consistency across multiple applications or across multiple pages in an application.</p> </li> </ul> </li> <li> <p>To run a bulk process that attempts to compile all invalid queries, click <span class="bold">Attempt to compile invalid queries</span>.</p> <p>Using this option can validate some queries that show a status of invalid when initially migrated.</p> </li> <li> <p>To create a view:</p> <ol> <li> <p>On the Queries page, click the link in the Oracle View column for the view you want to create.</p> <p>The Object Browser opens.</p> </li> <li> <p>Click the <span class="bold">Create</span> button.</p> </li> <li> <p>From the list of object types, select <span class="bold">View</span>.</p> </li> <li> <p>Follow the on-screen instructions.</p> </li> </ol> </li> <li> <p>To edit a query:</p> <ol> <li> <p>On the Queries page, click the Oracle view you want to edit.</p> </li> <li> <p>Click <span class="bold">Compile</span> to find the invalid part of the query.</p> <p>The Microsoft Access Query syntax appears in the edit window. It may require some modification to make it valid Oracle syntax.</p> </li> <li> <p>Click <span class="bold">Access Query</span> to review the initial query and compare it to the converted query.</p> </li> <li> <p>Click <span class="bold">Edit</span>.</p> </li> <li> <p>Update the query and recompile it.</p> </li> <li> <p>When it is validated, click the <span class="bold">Queries</span> breadcrumb.</p> </li> <li> <p>To include this validated query, select it in the left column on the Queries page and click <span class="bold">Apply Changes</span>.</p> </li> </ol> </li> <li> <p>To set user interface defaults:</p> <ol> <li> <p>On the Queries page, click the Oracle view.</p> </li> <li> <p>In the Tasks list on the right, click <span class="bold">UI Defaults</span>.</p> </li> <li> <p>On the UI Defaults page, click <span class="bold">Create Defaults</span>.</p> <p>The Table Defaults page appears, listing column information as it will appear in forms and reports. Note that you are now working in Application Builder, the component within Oracle Application Express where you build and modify applications.</p> </li> <li> <p>To edit the information, click the <span class="bold">Grid Edit</span> button.</p> <p>You can update the column label, change the sequence the columns will appear by default, and so on.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span> to save your updates.</p> </li> <li> <p>To return to the Application Migration, click the <span class="bold">Home</span> breadcrumb. Then, select the <span class="bold">Application Migrations</span> link on the right, select your migration project, and click <span class="bold">Queries</span>.</p> </li> </ol> </li> <li> <p>To include queries in the migration, select them in the left column.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span> to save your selections.</p> </li> </ol> <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="apm_recforms.htm#CBBHFIBF">"Reviewing Retrieved Forms"</a>, <a href="apm_howrevobj.htm#BGBHBHFA">"Step 5: Review Your Retrieved Objects"</a>, and <a href="apm_howmigproj.htm#BGBIDFDB">"How to Migrate a Microsoft Access Application"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </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="apm_rectables.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apm_recforms.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