blob: 12f7d76111e211b30e8e4336fac642e785ab564c [file] [log] [blame]
<!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>Ordering</title>
<meta name="copyright" content="Copyright (c) 2000, 2009 oracle . All rights reserved. This program and the accompanying materials are made available under the terms of the Eclipse Public License 2.0 which accompanies this distribution, and is available at http://www.eclipse.org/legal/epl-2.0/. Contributors: Oracle - initial API and implementation" />
<meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 1.0.11" />
<meta name="date" content="2013-04-05T12:21:41Z" />
<meta name="robots" content="noarchive" />
<meta name="doctitle" content="Ordering" />
<meta name="relnum" content="Release 3.3" />
<meta name="partnum" content="Release 3.3" />
<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" />
</head>
<body>
<p><a id="CACBIJFD" name="CACBIJFD"></a></p>
<div class="sect3"><!-- infolevel="all" infotype="General" -->
<h1>Ordering</h1>
<p><a id="sthref582" name="sthref582"></a><a id="sthref583" name="sthref583"></a><a id="sthref584" name="sthref584"></a>Specify the default order for objects returned from a query. These options correspond to the <code>@OrderBy</code> annotation.</p>
<div class="inftblhruleinformalwide">
<table class="HRuleInformalWide" title="JPA Details view, Advanced page" summary="JPA Details view, Advanced page" dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0">
<col width="16%" />
<col width="*" />
<col width="17%" />
<col width="25%" />
<thead>
<tr align="left" valign="top">
<th align="left" valign="bottom" id="r1c1-t44">Property</th>
<th align="left" valign="bottom" id="r1c2-t44">Description</th>
<th align="left" valign="bottom" id="r1c3-t44">Default</th>
<th align="left" valign="bottom" id="r1c4-t44">Available for Entity&nbsp;Type</th>
</tr>
</thead>
<tbody>
<tr align="left" valign="top">
<td align="left" id="r2c1-t44" headers="r1c1-t44">
<p><span class="bold">Name</span></p>
</td>
<td align="left" headers="r2c1-t44 r1c2-t44"><br /></td>
<td align="left" headers="r2c1-t44 r1c3-t44"><br /></td>
<td align="left" headers="r2c1-t44 r1c4-t44">
<p><a href="tasks012.htm#CIHHJEBJ">Element collection mapping</a>, <a href="tasks016.htm#BABEIEGD">Many-to-many mapping</a>, and <a href="tasks018.htm#BABHGEBD">One-to-many mapping</a></p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r3c1-t44" headers="r1c1-t44">
<p><span class="bold">Primary key</span></p>
</td>
<td align="left" headers="r3c1-t44 r1c2-t44"><br /></td>
<td align="left" headers="r3c1-t44 r1c3-t44"><br /></td>
<td align="left" headers="r3c1-t44 r1c4-t44"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r4c1-t44" headers="r1c1-t44">
<p><span class="bold">Custom</span></p>
</td>
<td align="left" headers="r4c1-t44 r1c2-t44"><br /></td>
<td align="left" headers="r4c1-t44 r1c3-t44"><br /></td>
<td align="left" headers="r4c1-t44 r1c4-t44"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r5c1-t44" headers="r1c1-t44">
<p><span class="bold">Order column</span></p>
</td>
<td align="left" headers="r5c1-t44 r1c2-t44"><br /></td>
<td align="left" headers="r5c1-t44 r1c3-t44"><br /></td>
<td align="left" headers="r5c1-t44 r1c4-t44"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r6c1-t44" headers="r1c1-t44">
<p>Insertable</p>
</td>
<td align="left" headers="r6c1-t44 r1c2-t44">
<p>Specify if the column is included in SQL <code>INSERT</code> statements</p>
</td>
<td align="left" headers="r6c1-t44 r1c3-t44">
<p>True</p>
</td>
<td align="left" headers="r6c1-t44 r1c4-t44"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r7c1-t44" headers="r1c1-t44">
<p>Updatable</p>
</td>
<td align="left" headers="r7c1-t44 r1c2-t44">
<p>Specify if the column is included in SQL <code>UPDATE</code> statements</p>
</td>
<td align="left" headers="r7c1-t44 r1c3-t44">
<p>True</p>
</td>
<td align="left" headers="r7c1-t44 r1c4-t44"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r8c1-t44" headers="r1c1-t44">
<p>Nullable</p>
</td>
<td align="left" headers="r8c1-t44 r1c2-t44">
<p>Specify if the database column is nullable</p>
</td>
<td align="left" headers="r8c1-t44 r1c3-t44">
<p>True</p>
</td>
<td align="left" headers="r8c1-t44 r1c4-t44"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r9c1-t44" headers="r1c1-t44">
<p>Column definition</p>
</td>
<td align="left" headers="r9c1-t44 r1c2-t44">
<p>The SQL fragment that used to generate the DDL for the column</p>
</td>
<td align="left" headers="r9c1-t44 r1c3-t44">
<p>Generated SQL to create a column of the inferred type</p>
</td>
<td align="left" headers="r9c1-t44 r1c4-t44"><br /></td>
</tr>
</tbody>
</table>
<br /></div>
<!-- class="inftblhruleinformalwide" --></div>
<!-- class="sect3" -->
<!-- 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&nbsp;&copy;&nbsp;2011, 2013,&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>
</tr>
</table>
</div>
<!-- class="footer" -->
</body>
</html>