Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdddg\tdddg_exploring002.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"> <script src="./callback.js" type="text/javascript"></script> <noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript> </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" /> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-04-21T9:46:23Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Tutorial: Viewing EMPLOYEES Table Properties and Data" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10766-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="prev" href="tdddg_exploring001.htm" title="Previous" type="text/html" /> <link rel="next" href="tdddg_selecting.htm" title="Next" type="text/html" /> <title>Tutorial: Viewing EMPLOYEES Table Properties and Data</title> </head> <body> <div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div> <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="tdddg_exploring001.htm"><img width="24" height="24" src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdddg_selecting.htm"><img width="24" height="24" src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABGFBBA" name="BABGFBBA"></a><a id="TDDDG21100" name="TDDDG21100"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>Tutorial: Viewing EMPLOYEES Table Properties and Data</h1> <a name="BEGIN" id="BEGIN"></a> <p><a id="sthref89" name="sthref89"></a><a id="sthref90" name="sthref90"></a>This tutorial shows how to use SQL Developer to view the properties and data of the <code>EMPLOYEES</code> table in the <code>HR</code> schema, if you are browsing the <code>HR</code> schema.</p> <p>If you are not browsing the <code>HR</code> schema, follow the instructions in <a href="tdddg_exploring001.htm#BABHJIAB">"Tutorial: Viewing HR Schema Objects"</a> and then return to this topic.</p> <a id="TDDDG126" name="TDDDG126"></a> <p class="subhead2">To view the properties and data of the EMPLOYEES table:</p> <ol> <li> <p>In the Connections pane, expand <span class="bold">Tables</span>.</p> <p>Under Tables, a list of the tables in the <code>HR</code> schema appears.</p> </li> <li> <p>Select the table <span class="bold">EMPLOYEES</span>.</p> <p>In the right frame of the Oracle SQL Developer window, in the Columns pane, a list of all columns of this table appears. To the right of each column are its properties—name, data type, and so on. (To see all column properties, move the horizontal scroll bar to the right.)</p> </li> <li><a id="BABIBGCG" name="BABIBGCG"></a> <p><a id="sthref91" name="sthref91"></a><a id="sthref92" name="sthref92"></a>In the right frame, click the tab <span class="bold">Data</span>.</p> <p>The Data pane appears, showing a numbered list of all records in this table. (To see more records, move the vertical scroll bar down. To see more columns of the records, move the horizontal scroll bar to the right.)</p> </li> <li> <p><a id="sthref93" name="sthref93"></a>In the right frame, click the tab <span class="bold">Constraints</span>.</p> <p>The Constraints pane appears, showing a list of all constraints on this table. To the right of each constraint are its properties—name, type, search condition, and so on. (To see all constraint properties, move the horizontal scroll bar to the right.)</p> </li> <li> <p>Explore the other properties by clicking on the appropriate tabs.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=RPTUG10200','newWindow').focus()"><span class="italic">Oracle Database SQL Developer User's Guide</span></a></p> <p><a href="tdddg_intro022.htm#BABGGFHJ">About Sample Schema HR</a></p> <p><a href="tdddg_selecting.htm#CHDHHAFA">Selecting Table Data</a></p> <p><a href="tdddg_exploring.htm#BCGDHICD">Exploring Oracle Database with SQL Developer</a></p> </div> </div> <!-- class="sect1" --> <!-- 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 © 1996, 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="tdddg_exploring001.htm"><img width="24" height="24" src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdddg_selecting.htm"><img width="24" height="24" 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