Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEUTL\qry_blr_join_manual.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>Joining Objects Manually</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T18:10:2Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Joining Objects Manually" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12511-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" title="Home" type="text/html" /> <link rel="up" href="qry_bldr.htm" title="Building Queries with Query..." type="text/html" /> <link rel="up" href="qry_blr_join.htm" title="Creating Relationships Betw..." type="text/html" /> <link rel="up" href="qry_blr_join_manual.htm" title="Joining Objects Manually" type="text/html" /> <link rel="prev" href="qry_blr_join_about.htm" title="Previous" type="text/html" /> <link rel="next" href="qry_blr_join_auto.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="Home">Home</a> > <a href="qry_bldr.htm" title="Building Queries with Query...">Building Queries with Query...</a> > <a href="qry_blr_join.htm" title="Creating Relationships Betw...">Creating Relationships Betw...</a> > Joining Objects Manually</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="qry_blr_join_about.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="qry_blr_join_auto.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABJHDED" name="BABJHDED"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="AEUTL298" id="AEUTL298"></a>Joining Objects <a id="sthref381" name="sthref381"></a>Manually</h1> <p>You can create a join manually by selecting the Join column in the Design pane.</p> <p>To join two objects manually:</p> <ol> <li> <p>On the Workspace home page, click <span class="bold">SQL Workshop</span> and then <span class="bold">Query Builder</span>.</p> <p>Query Builder appears.</p> </li> <li> <p>From the Object Selection pane, select the objects you want to join.</p> <p>The objects display in the Design pane.</p> </li> <li> <p>Identify the columns you want to join.</p> <p>You create a join by selecting the Join column adjacent to the column name. The Join column displays to the right of the datatype, beneath the Remove icon. When your cursor is in the appropriate position, the following help tip displays:</p> <pre xml:space="preserve" class="oac_no_warn"> Click here to select column for join </pre></li> <li> <p>Select the appropriate Join column for the first object.</p> <p>When selected, the Join column displays as a dark gray. To deselect a Join column, simply select is again or press <span class="bold">ESC</span>.</p> </li> <li> <p>Select the appropriate Join column for the second object.</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> You can also join two objects by dragging and dropping. Select a column in the first table and then drag and drop it onto a column in another table.</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <img src="img/qry_bldr_join.gif" alt="Description of qry_bldr_join.gif follows" title="Description of qry_bldr_join.gif follows" longdesc="img_text/qry_bldr_join.htm" /><br /> <a id="sthref382" name="sthref382" href="img_text/qry_bldr_join.htm">Description of the illustration qry_bldr_join.gif</a><br /> <br /> <p>When joined, a green line connects the two columns.</p> </li> <li> <p>Select the columns to be included in your query. You can view the SQL statement resulting from the join by positioning the cursor over the green line.</p> </li> <li> <p>Click <span class="bold">Run</span> to execute the query.</p> <p>The Results pane displays the query results.</p> </li> </ol> </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="qry_blr_join_about.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="qry_blr_join_auto.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