Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdddg\tdddg_selecting004.htm

Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdddg\tdddg_selecting004.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: Selecting Specific Columns of a Table" />
<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_selecting003.htm" title="Previous" type="text/html" />
<link rel="next" href="tdddg_selecting005.htm" title="Next" type="text/html" />
<title>Tutorial: Selecting Specific Columns of a Table</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_selecting003.htm"><img width="24" height="24" src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br />
<span class="icon">Previous</span></a>&nbsp;</td>
<td align="center"><a href="tdddg_selecting005.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="BCGBCFDE" name="BCGBCFDE"></a><a id="TDDDG99962" name="TDDDG99962"></a></p>
<div class="sect1">
<h1>Tutorial: Selecting Specific Columns of a Table</h1>
<a name="BEGIN" id="BEGIN"></a>
<p><a id="sthref100" name="sthref100"></a><a id="sthref101" name="sthref101"></a>This tutorial shows how to select only the columns <code>FIRST_NAME</code>, <code>LAST_NAME</code>, and <code>DEPARTMENT_ID</code> of the <code>EMPLOYEES</code> table.</p>
<a id="TDDDG129" name="TDDDG129"></a>
<p class="subhead2">To select only FIRST_NAME, LAST_NAME, and DEPARTMENT_ID:</p>
<ol>
<li>
<p>Click the icon <span class="bold">SQL&nbsp;Worksheet</span>.</p>
<p>The SQL&nbsp;Worksheet pane appears.</p>
</li>
<li>
<p>In the field under "Enter SQL Statement:", enter this query:</p>
<pre xml:space="preserve" class="oac_no_warn">
SELECT FIRST_NAME, LAST_NAME, DEPARTMENT_ID
FROM EMPLOYEES;
</pre></li>
<li>
<p>Click the icon <span class="bold">Execute Statement</span>.</p>
<p>The query runs.</p>
</li>
<li>
<p>Click the tab <span class="bold">Results</span>.</p>
<p>The Results pane appears, showing the results of the query, which are similar to:</p>
<pre xml:space="preserve" class="oac_no_warn">
FIRST_NAME           LAST_NAME                 DEPARTMENT_ID
-------------------- ------------------------- -------------
Donald               OConnell                             50
Douglas              Grant                                50
Jennifer             Whalen                               10
Michael              Hartstein                            20
Pat                  Fay                                  20
Susan                Mavris                               40
Hermann              Baer                                 70
Shelley              Higgins                             110
William              Gietz                               110
Steven               King                                 90
Neena                Kochhar                              90
 
FIRST_NAME           LAST_NAME                 DEPARTMENT_ID
-------------------- ------------------------- -------------
Lex                  De Haan                              90
...
Kevin                Feeney                               50
 
107 rows selected.
</pre></li>
</ol>
<div class="helpinfonotealso">
<h2>Related Topics</h2>
<p><a href="tdddg_selecting002.htm#BCGHHIJG">Running Queries in SQL&nbsp;Developer</a></p>
<p><a href="tdddg_selecting003.htm#BCGFJIGI">Tutorial: Selecting All Columns of a Table</a></p>
<p><a href="tdddg_selecting.htm#CHDHHAFA">Selecting Table Data</a></p>
</div>
</div>


<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&nbsp;&copy;&nbsp;1996, 2009,&nbsp;Oracle&nbsp;and/or&nbsp;its&nbsp;affiliates.&nbsp;All&nbsp;rights&nbsp;reserved.</span><br />
<a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td>
<td align="center"><a href="tdddg_selecting003.htm"><img width="24" height="24" src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br />
<span class="icon">Previous</span></a>&nbsp;</td>
<td align="center"><a href="tdddg_selecting005.htm"><img width="24" height="24" src="./dcommon/gifs/rightnav.gif" alt="Next" /><br />
<span class="icon">Next</span></a></td>
</tr>
</table>
</div>

</body>
</html>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de