Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEUTL\qry_blr_sel_obj.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>Adding an Object to the Design Pane</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T18:10:1Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Adding an Object to the Design Pane" /> <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_design.htm" title="Selecting Objects" type="text/html" /> <link rel="up" href="qry_blr_sel_obj.htm" title="Adding an Object to the Des..." type="text/html" /> <link rel="prev" href="qry_blr_col_type.htm" title="Previous" type="text/html" /> <link rel="next" href="qry_blr_obj.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_design.htm" title="Selecting Objects">Selecting Objects</a> > Adding an Object to the Des...</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_col_type.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="qry_blr_obj.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABIAJAI" name="BABIAJAI"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="AEUTL292" id="AEUTL292"></a>Adding an Object to the Design Pane</h1> <p>You add an object to the Design pane by selecting it from the Object Selection pane.</p> <p>To add an object to the Design pane:</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>Select an object from the Object Selection pane.</p> <p>The selected object appears in the Design Pane. Note that a graphical representation of the datatype displays to the right of the column name.</p> <img src="img/qry_bldr_add.gif" alt="Description of qry_bldr_add.gif follows" title="Description of qry_bldr_add.gif follows" longdesc="img_text/qry_bldr_add.htm" /><br /> <a id="sthref371" name="sthref371" href="img_text/qry_bldr_add.htm">Description of the illustration qry_bldr_add.gif</a><br /> <br /></li> <li> <p>Select the columns to be included in your query by clicking the check box to the left of the column name.</p> <p>When you select a column you are indicating it is included in the query. As you select a column, it appears on the Conditions tab. Note that the Show check box on the Conditions tab controls whether a column is included in query results. Be default, this check box is selected.</p> <p>To select the first twenty columns, click the <span class="bold">Table Actions</span> icon in the upper left corner of the object. The Actions window appears. Select <span class="bold">Check All</span>.</p> </li> <li> <p>To execute the query and view results, click <span class="bold">Run</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> You can also execute a query by pressing <span class="bold">CTRL + ENTER</span>.</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <p>The Results pane displays the query results.</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="qry_blr_cond.htm#BABCGHHE">"Specifying Query Conditions"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <a id="BABJDEBG" name="BABJDEBG"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="AEUTL293" id="AEUTL293"></a>Resizing the Design and Results <a id="sthref372" name="sthref372"></a>Panes</h2> <p>As you select objects, you can resize Design and Results panes by selecting the gray horizontal rule in the center of the page. Moving the rule up, shrinks the Design pane. Moving the rule down expands the Design pane.</p> </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="qry_blr_col_type.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="qry_blr_obj.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