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

Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdddg\tdddg_selecting005.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="Displaying Selected Columns Under New Headings" />
<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_selecting004.htm" title="Previous" type="text/html" />
<link rel="next" href="tdddg_selecting006.htm" title="Next" type="text/html" />
<title>Displaying Selected Columns Under New Headings</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_selecting004.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_selecting006.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="BCGCJHDC" name="BCGCJHDC"></a><a id="TDDDG22100" name="TDDDG22100"></a></p>
<div class="sect1">
<h1>Displaying Selected Columns Under New Headings</h1>
<a name="BEGIN" id="BEGIN"></a>
<p><a id="sthref102" name="sthref102"></a><a id="sthref103" name="sthref103"></a><a id="sthref104" name="sthref104"></a>When query results are displayed, the default column heading is the column name. To display a column under a new heading, specify the new heading (<span class="bold">alias</span>) immediately after the name of the column. The alias renames the column for the duration of the query, but does not change its name in the database.</p>
<p>The query in the following example selects the same columns as the query in <a href="tdddg_selecting004.htm#BCGBCFDE">Tutorial: Selecting Specific Columns of a Table</a>, but it also specifies aliases for them. Because the aliases are not enclosed in double quotation marks, they are displayed in uppercase letters.</p>
<div class="example"><a id="CEGGBDEC" name="CEGGBDEC"></a><a id="TDDDG130" name="TDDDG130"></a>
<p class="titleinexample">Displaying Selected Columns Under New Headings</p>
<pre xml:space="preserve" class="oac_no_warn">
SELECT FIRST_NAME <span class="bold">First</span>, LAST_NAME <span class="bold">last</span>, DEPARTMENT_ID <span class="bold">DepT</span>
FROM EMPLOYEES;
</pre>
<p>Result is similar to:</p>
<pre xml:space="preserve" class="oac_no_warn">
FIRST                LAST                            DEPT
-------------------- ------------------------- ----------
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                LAST                            DEPT
-------------------- ------------------------- ----------
Lex                  De Haan                           90
...
Kevin                Feeney                            50
 
107 rows selected.
</pre></div>

<p>If you enclose column aliases in double quotation marks, case is preserved, and the aliases can include spaces, as in the following example.</p>
<div class="example"><a id="CEGCEDHD" name="CEGCEDHD"></a><a id="TDDDG131" name="TDDDG131"></a>
<p class="titleinexample">Preserving Case and Including Spaces in Column Aliases</p>
<pre xml:space="preserve" class="oac_no_warn">
SELECT FIRST_NAME <span class="bold">"Given Name"</span>, LAST_NAME <span class="bold">"Family Name"</span>
FROM EMPLOYEES;
</pre>
<p>Result is similar to:</p>
<pre xml:space="preserve" class="oac_no_warn">
Given Name           Family Name
-------------------- -------------------------
Donald               OConnell
Douglas              Grant
Jennifer             Whalen
Michael              Hartstein
Pat                  Fay
Susan                Mavris
Hermann              Baer
Shelley              Higgins
William              Gietz
Steven               King
Neena                Kochhar
 
Given Name           Family Name
-------------------- -------------------------
Lex                  De Haan
...
Kevin                Feeney
 
107 rows selected.
</pre></div>

<div class="helpinfonotealso">
<h2>Related Topics</h2>
<p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=SQLRF01702','newWindow').focus()"><span class="italic">Oracle Database SQL Language Reference</span></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_selecting004.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_selecting006.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