You are viewing a plain text version of this content. The canonical link for it is here.
Posted to general@db.apache.org by rh...@apache.org on 2013/03/13 14:54:25 UTC
svn commit: r854277 [30/44] - in /websites/production/db/content/derby:
docs/10.4/ja_JP/ docs/10.4/ja_JP/getstart/ docs/10.4/ja_JP/images/
docs/10.4/ja_JP/ref/ manuals/
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefso2.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefso2.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefso2.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,70 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="ResultSet ãªãã¸ã§ã¯ã" />
+<meta content="ResultSets, errors in statement affecting creation of" name="DC.subject" />
+<meta content="ResultSets, errors in statement affecting creation of" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc40794.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefso2" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>ResultSet ãªãã¸ã§ã¯ã</title>
+</head>
+<body id="rrefso2"><a name="rrefso2"><!-- --></a>
+
+
+<h1 class="topictitle1">ResultSet ãªãã¸ã§ã¯ã</h1>
+
+
+<div>
+<div class="section"><p>å
ç«ã£ã¦SELECTæãå®è¡ãããæã«ä¾å¤ãçºçããã¨ã<em>ResultSet</em>ãéããã¨ãã§ãã¾ããã<em>ResultSet</em>ãéããå¾ã§ããã°ãåæ§ã®ã¨ã©ã¼ãçºçãã¦ãã<em>ResultSet</em>ãéãããããã¨ã¯ããã¾ããã</p>
+</div>
+
+<div class="section"><p>ä¾ãã°ã<em>java.sql.Statement</em>ã<em>java.sql.PreparedStatement</em>ã®<em>executeQuery</em>ã¡ã½ããã«ã¦ãé¶é¤ç®ã¨ã©ã¼ãçºçããå ´åãä¾å¤ãæãã£ã¦çµæã»ããã¯è¿ãã¾ãããä¸æ¹ã§åæ§ã®ã¨ã©ã¼ã<em>ResultSet</em>ãªãã¸ã§ã¯ãã®<em>next</em>ã¡ã½ããã§çºçãã¦ãçµæã»ãããéãã¦ãã¾ããã¨ã¯ããã¾ããã</p>
+</div>
+
+<div class="section"><p>æåã®è¡ãåãåºãããåã«ã·ã¹ãã ãé¨åçã«ååããå®è¡ããå ´åã<em>ResultSet</em>ãä½æãããã¨ãã«ã¨ã©ã¼ãçºçãããã¨ãããã¾ãã
+ãã®ã¨ã©ã¼ã¯ä¸ã¤ä»¥ä¸ã®è¡¨ã使ãååãããéç´ãGROUP BYãORDER BYãDISTINCTãINTERSECTãEXCEPTãUNIONã使ãååãã«ã¦çºçãããã¨ãããã¾ãã</p>
+</div>
+
+<div class="section"><p><em>Statement</em>ãéããã¨ããã®æã§éããå
¨ã¦ã®<em>ResultSet</em>ãªãã¸ã§ã¯ããéãã¾ãã</p>
+</div>
+
+<div class="section"><p><em>ResultSet</em>ã®ã«ã¼ã½ã«ã«ã¯ãæãå®è¡ãããåã«ã«ã¼ã½ã«åãä¸ãããã¨ãã§ãã¾ãããã ãä¸æ¦å®è¡ãããå¾ã§ã¯ãã«ã¼ã½ã«ã®ååãå¤æ´ãããã¨ã¯ã§ãã¾ããã</p>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefjdbc40794.html" title="">java.sql.Statementã¤ã³ã¿ã¼ãã§ã¤ã¹</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefso2.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsql9241891.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsql9241891.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsql9241891.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,1995 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="Derbyã®ãµãã¼ãããSQL-92ã®æ©è½" />
+<meta content="SQL-92, features supported by Derby, features not supported by Derby" name="DC.subject" />
+<meta content="SQL-92, features supported by Derby, features not supported by Derby" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj23296.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj28468.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj18919.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj39374.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefclauses.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj19433.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29840.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefqueries.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlbuiltinsystemfunctions.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefkeywords29722.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsistabs38369.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefexcept16677.html" />
+<meta scheme="URI" name="DC.Relation" content="crefjdbc12657.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc87220.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbcjsr169.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc32593.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc4_0summary.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc1020262.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsql9241891" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>Derbyã®ãµãã¼ãããSQL-92ã®æ©è½</title>
+</head>
+<body id="rrefsql9241891"><a name="rrefsql9241891"><!-- --></a>
+
+
+<h1 class="topictitle1">Derbyã®ãµãã¼ãããSQL-92ã®æ©è½</h1>
+
+
+<div>
+<div class="section"><div class="p"> SQL-92ã®ãµãã¼ãã«ã¯4ã¤ã®ã¬ãã«ãããã¾ãã <ul>
+<li>SQL92E <p>åæ©ç</p>
+</li>
+
+<li>SQL92T <p>é渡çãFIPS 127-2ã¨ããçºè¡ç©ã«ã¦NISTãå®ç¾©</p>
+</li>
+
+<li>SQL92I <p>ä¸ç´</p>
+</li>
+
+<li>SQL92F <p>å®å
¨</p>
+</li>
+
+</ul>
+ </div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">åºæ¬ãã¼ã¿å</h4>
+<div class="p">次ã®è¡¨ã§ã¯Derbyã«ã¦å©ç¨å¯è½ãªSQL-92ã®åºæ¬ãã¼ã¿åã示ãã¾ãã
+
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" width="100%" frame="border" border="1" rules="all"><caption>表 1. å©ç¨å¯è½ãªSQL-92ã®æ©è½: åºæ¬ãã¼ã¿å</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N100AC">æ©è½</th>
+
+<th valign="bottom" id="N100B3">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N100BA"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N100AC ">SMALLINT</td>
+
+<td valign="top" headers="N100B3 ">SQL92E</td>
+
+<td valign="top" headers="N100BA ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N100AC ">INTEGER</td>
+
+<td valign="top" headers="N100B3 ">SQL92E</td>
+
+<td valign="top" headers="N100BA ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N100AC ">DECIMAL(p,s)</td>
+
+<td valign="top" headers="N100B3 ">SQL92E</td>
+
+<td valign="top" headers="N100BA ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N100AC ">NUMERIC(p,s)</td>
+
+<td valign="top" headers="N100B3 ">SQL92E</td>
+
+<td valign="top" headers="N100BA ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N100AC ">REAL</td>
+
+<td valign="top" headers="N100B3 ">SQL92E</td>
+
+<td valign="top" headers="N100BA ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N100AC ">FLOAT(p)</td>
+
+<td valign="top" headers="N100B3 ">SQL92E</td>
+
+<td valign="top" headers="N100BA ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N100AC ">DOUBLE PRECISION</td>
+
+<td valign="top" headers="N100B3 ">SQL92E</td>
+
+<td valign="top" headers="N100BA ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N100AC ">CHAR(n)</td>
+
+<td valign="top" headers="N100B3 ">SQL92E</td>
+
+<td valign="top" headers="N100BA ">Yes</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">åºæ¬ç®è¡æ¼ç®</h4>
+
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã:åºæ¬çãªç®è¡æ¼ç®</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N101DC">æ©è½</th>
+
+<th valign="bottom" id="N101E3">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N101EA"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N101DC ">+, *, -, /, unary +, unary -</td>
+
+<td valign="top" headers="N101E3 ">SQL92E</td>
+
+<td valign="top" headers="N101EA ">Yes</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">åºæ¬çãªæ¯è¼</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã:åºæ¬çãªæ¯è¼</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N1024E">æ©è½</th>
+
+<th valign="bottom" id="N10255">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N1025C"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N1024E "><, >, <= ,>=, <>, =</td>
+
+<td valign="top" headers="N10255 ">SQL92E</td>
+
+<td valign="top" headers="N1025C ">Yes</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">åºæ¬çãªè¿°èª</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã:åºæ¬çãªè¿°èª</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N102C0">æ©è½</th>
+
+<th valign="bottom" id="N102C7">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N102CE"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N102C0 ">BETWEEN, LIKE, NULL</td>
+
+<td valign="top" headers="N102C7 ">SQL92E</td>
+
+<td valign="top" headers="N102CE ">Yes</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">å®éçãªè¿°èª</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã:å®éçãªè¿°èª</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N10332">æ©è½</th>
+
+<th valign="bottom" id="N10339">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N10340"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10332 ">IN, ALL/SOME, EXISTS</td>
+
+<td valign="top" headers="N10339 ">SQL92E</td>
+
+<td valign="top" headers="N10340 ">Yes</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">ã¹ãã¼ãã®å®ç¾©</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã:ã¹ãã¼ãã®å®ç¾©</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N103A4">æ©è½</th>
+
+<th valign="bottom" id="N103AB">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N103B2"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N103A4 ">表</td>
+
+<td valign="top" headers="N103AB ">SQL92E</td>
+
+<td valign="top" headers="N103B2 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N103A4 ">ãã¥ã¼</td>
+
+<td valign="top" headers="N103AB ">SQL92E</td>
+
+<td valign="top" headers="N103B2 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N103A4 ">権é</td>
+
+<td valign="top" headers="N103AB ">SQL92E</td>
+
+<td valign="top" headers="N103B2 ">Yes</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">åã®å±æ§</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã:åã®å±æ§</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N1044B">æ©è½</th>
+
+<th valign="bottom" id="N10452">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N10459"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N1044B ">æ¢å®å¤</td>
+
+<td valign="top" headers="N10452 ">SQL92E</td>
+
+<td valign="top" headers="N10459 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N1044B ">空å¤ãã¨ãããã®å®ç¾©</td>
+
+<td valign="top" headers="N10452 ">SQL92E</td>
+
+<td valign="top" headers="N10459 ">Yes</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">å¶ç´(延æã§ããªã)</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: å¶ç´(延æã§ããªã)</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N104D8">æ©è½</th>
+
+<th valign="bottom" id="N104DF">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N104E6"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N104D8 ">NOT NULL</td>
+
+<td valign="top" headers="N104DF ">SQL92E</td>
+
+<td valign="top" headers="N104E6 ">Yes (SYSCONSTRAINTSã«ã¯è¨é²ãããªã)</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N104D8 ">UNIQUE/PRIMARY KEY</td>
+
+<td valign="top" headers="N104DF ">SQL92E</td>
+
+<td valign="top" headers="N104E6 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N104D8 ">FOREIGN KEY</td>
+
+<td valign="top" headers="N104DF ">SQL92E</td>
+
+<td valign="top" headers="N104E6 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N104D8 ">CHECK</td>
+
+<td valign="top" headers="N104DF ">SQL92E</td>
+
+<td valign="top" headers="N104E6 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N104D8 ">View WITH CHECK OPTION</td>
+
+<td valign="top" headers="N104DF ">SQL92E</td>
+
+<td valign="top" headers="N104E6 ">No ãã¥ã¼ã®æ´æ°ã¯ã§ããªã</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">ã«ã¼ã½ã«</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã:ã«ã¼ã½ã«</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N105B5">æ©è½</th>
+
+<th valign="bottom" id="N105BC">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N105C3"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N105B5 ">DECLARE, OPEN, FETCH, CLOSE</td>
+
+<td valign="top" headers="N105BC ">SQL92E</td>
+
+<td valign="top" headers="N105C3 ">Yes JDBCã®ã¡ã½ããå¼ã³åºãã該å½</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N105B5 ">UPDATE, DELETE CURRENT</td>
+
+<td valign="top" headers="N105BC ">SQL92E</td>
+
+<td valign="top" headers="N105C3 ">Yes</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">åçãªSQL1</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: åçãªSQL1</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N10642">æ©è½</th>
+
+<th valign="bottom" id="N10649">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N10650"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10642 ">ALLOCATE / DEALLOCATE / GET / SET DESCRIPTOR</td>
+
+<td valign="top" headers="N10649 ">SQL92T</td>
+
+<td valign="top" headers="N10650 ">Yes JDBCã®ã¡ã½ããå¼ã³åºãã«ããå®ç¾</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10642 ">PREPARE / EXECUTE / EXECUTE IMMEDIATE</td>
+
+<td valign="top" headers="N10649 ">SQL92T</td>
+
+<td valign="top" headers="N10650 ">Yes JDBCã®ã¡ã½ããå¼ã³åºãã«ããå®ç¾</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10642 ">DECLARE, OPEN, FETCH, CLOSE, UPDATE, DELETE dynamic
+cursor</td>
+
+<td valign="top" headers="N10649 ">SQL92T</td>
+
+<td valign="top" headers="N10650 ">Yes JDBCã®ã¡ã½ããå¼ã³åºãã«ããå®ç¾</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10642 ">DESCRIBE output</td>
+
+<td valign="top" headers="N10649 ">SQL92T</td>
+
+<td valign="top" headers="N10650 ">JDBCã«ããå®ç¾</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">åºæ¬çãªæ
å ±ã¹ãã¼ã</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã åºæ¬çãªæ
å ±ã¹ãã¼ã</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N10704">æ©è½</th>
+
+<th valign="bottom" id="N1070B">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N10712"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10704 ">TABLES</td>
+
+<td valign="top" headers="N1070B ">SQL92T</td>
+
+<td valign="top" headers="N10712 "><em>SYS.SYSTABLES, SYS.SYSVIEWS, SYS.SYSCOLUMNS</em></td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10704 ">VIEWS</td>
+
+<td valign="top" headers="N1070B ">SQL92T</td>
+
+<td valign="top" headers="N10712 "><em>SYS.SYSTABLES, SYS.SYSVIEWS, SYS.SYSCOLUMNS</em></td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10704 ">COLUMNS</td>
+
+<td valign="top" headers="N1070B ">SQL92T</td>
+
+<td valign="top" headers="N10712 "><em>SYS.SYSTABLES, SYS.SYSVIEWS, SYS.SYSCOLUMNS</em></td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">åºæ¬çãªã¹ãã¼ãã¸ã®æä½</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: åºæ¬çãªã¹ãã¼ãã¸ã®æä½</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N107B8">æ©è½</th>
+
+<th valign="bottom" id="N107BF">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N107C6"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N107B8 ">CREATE / DROP TABLE</td>
+
+<td valign="top" headers="N107BF ">SQL92T</td>
+
+<td valign="top" headers="N107C6 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N107B8 ">CREATE / DROP VIEW</td>
+
+<td valign="top" headers="N107BF ">SQL92T</td>
+
+<td valign="top" headers="N107C6 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N107B8 ">GRANT / REVOKE</td>
+
+<td valign="top" headers="N107BF ">SQL92T</td>
+
+<td valign="top" headers="N107C6 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N107B8 ">ALTER TABLE ADD COLUMN</td>
+
+<td valign="top" headers="N107BF ">SQL92T</td>
+
+<td valign="top" headers="N107C6 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N107B8 ">ALTER TABLE DROP COLUMN</td>
+
+<td valign="top" headers="N107BF ">SQL92T</td>
+
+<td valign="top" headers="N107C6 ">Yes</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">表ã®çµå</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: 表ã®çµå</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N10896">æ©è½</th>
+
+<th valign="bottom" id="N1089D">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N108A4"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10896 ">INNER JOIN</td>
+
+<td valign="top" headers="N1089D ">SQL92T</td>
+
+<td valign="top" headers="N108A4 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10896 ">natural join</td>
+
+<td valign="top" headers="N1089D ">SQL92T</td>
+
+<td valign="top" headers="N108A4 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10896 ">LEFT, RIGHT OUTER JOIN</td>
+
+<td valign="top" headers="N1089D ">SQL92T</td>
+
+<td valign="top" headers="N108A4 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10896 ">join condition</td>
+
+<td valign="top" headers="N1089D ">SQL92T</td>
+
+<td valign="top" headers="N108A4 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10896 ">named columns join</td>
+
+<td valign="top" headers="N1089D ">SQL92T</td>
+
+<td valign="top" headers="N108A4 ">Yes</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ¥æã®ãã¼ã¿å</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: æ¥æã®ãã¼ã¿å</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N10974">æ©è½</th>
+
+<th valign="bottom" id="N1097B">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N10982"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10974 ">åç´ãªDATE, TIME, TIMESTAMP, INTERVAL</td>
+
+<td valign="top" headers="N1097B ">SQL92T</td>
+
+<td valign="top" headers="N10982 ">Yes ãã ãINTERVALã¯ç¡ãã</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10974 ">æ¥æã®å®æ°</td>
+
+<td valign="top" headers="N1097B ">SQL92T</td>
+
+<td valign="top" headers="N10982 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10974 ">æ¥æã®æ¼ç®</td>
+
+<td valign="top" headers="N1097B ">SQL92T</td>
+
+<td valign="top" headers="N10982 ">Yes Javaã®ã¡ã½ããã«ã¦å¯è½</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10974 ">æ¥æã®æ¯è¼</td>
+
+<td valign="top" headers="N1097B ">SQL92T</td>
+
+<td valign="top" headers="N10982 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10974 ">è¿°èª: OVERLAPS</td>
+
+<td valign="top" headers="N1097B ">SQL92T</td>
+
+<td valign="top" headers="N10982 ">Yes Javaã®ã¡ã½ããã«ã¦å¯è½</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">VARCHAR ãã¼ã¿å</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: VARCHAR</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N10A52">æ©è½</th>
+
+<th valign="bottom" id="N10A59">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N10A60"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10A52 ">LENGTH</td>
+
+<td valign="top" headers="N10A59 ">SQL92T</td>
+
+<td valign="top" headers="N10A60 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10A52 ">é£çµ (||)</td>
+
+<td valign="top" headers="N10A59 ">SQL92T</td>
+
+<td valign="top" headers="N10A60 ">Yes</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">ãã©ã³ã¶ã¯ã·ã§ã³ã®åé¢</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: ãã©ã³ã¶ã¯ã·ã§ã³ã®åé¢</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N10ADF">æ©è½</th>
+
+<th valign="bottom" id="N10AE6">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N10AED"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10ADF ">READ WRITE / READ ONLY</td>
+
+<td valign="top" headers="N10AE6 ">SQL92T</td>
+
+<td valign="top" headers="N10AED ">JDBCã®å©ç¨ããã¼ã¿ãã¼ã¹ã®å±æ§ãè¨é²åªä½ã«ãã</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10ADF ">RU, RC, RR, SER</td>
+
+<td valign="top" headers="N10AE6 ">SQL92T</td>
+
+<td valign="top" headers="N10AED ">Yes</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">ã¦ã¼ã¶æ¯ã«è¤æ°ã¹ãã¼ããæã¤</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: ã¦ã¼ã¶æ¯ã«è¤æ°ã¹ãã¼ããæã¤</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N10B6C">æ©è½</th>
+
+<th valign="bottom" id="N10B73">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N10B7A"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10B6C ">SCHEMATA ãã¥ã¼</td>
+
+<td valign="top" headers="N10B73 ">SQL92T</td>
+
+<td valign="top" headers="N10B7A "><em>SYS.SYSSCHEMAS</em></td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">権é表</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: 権é表</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N10BE2">æ©è½</th>
+
+<th valign="bottom" id="N10BE9">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N10BF0"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10BE2 ">TABLE_PRIVILEGES</td>
+
+<td valign="top" headers="N10BE9 ">SQL92T</td>
+
+<td valign="top" headers="N10BF0 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10BE2 ">COLUMNS_PRIVILEGES</td>
+
+<td valign="top" headers="N10BE9 ">SQL92T</td>
+
+<td valign="top" headers="N10BF0 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10BE2 ">USAGE_PRIVILEGES</td>
+
+<td valign="top" headers="N10BE9 ">SQL92T</td>
+
+<td valign="top" headers="N10BF0 ">No</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">表ã¸ã®æä½</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: 表ã¸ã®æä½</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N10C8A">æ©è½</th>
+
+<th valign="bottom" id="N10C91">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N10C98"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10C8A ">UNION relaxation</td>
+
+<td valign="top" headers="N10C91 ">SQL92I</td>
+
+<td valign="top" headers="N10C98 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10C8A ">EXCEPT</td>
+
+<td valign="top" headers="N10C91 ">SQL92I</td>
+
+<td valign="top" headers="N10C98 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10C8A ">INTERSECT</td>
+
+<td valign="top" headers="N10C91 ">SQL92I</td>
+
+<td valign="top" headers="N10C98 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10C8A ">CORRESPONDING</td>
+
+<td valign="top" headers="N10C91 ">SQL92I</td>
+
+<td valign="top" headers="N10C98 ">No</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">ã¹ãã¼ãã®å®ç¾©æ</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: ã¹ãã¼ãã®å®ç¾©æ</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N10D4D">æ©è½</th>
+
+<th valign="bottom" id="N10D54">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N10D5B"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10D4D ">CREATE SCHEMA</td>
+
+<td valign="top" headers="N10D54 ">SQL92I</td>
+
+<td valign="top" headers="N10D5B ">é¨åçã«å®ç¾</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">ã¦ã¼ã¶èªè¨¼</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: ã¦ã¼ã¶èªè¨¼</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N10DBF">æ©è½</th>
+
+<th valign="bottom" id="N10DC6">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N10DCD"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10DBF ">SET SESSION AUTHORIZATION</td>
+
+<td valign="top" headers="N10DC6 ">SQL92I</td>
+
+<td valign="top" headers="N10DCD ">SET SCHEMAã使ã</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10DBF ">CURRENT_USER</td>
+
+<td valign="top" headers="N10DC6 ">SQL92I</td>
+
+<td valign="top" headers="N10DCD ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10DBF ">SESSION_USER</td>
+
+<td valign="top" headers="N10DC6 ">SQL92I</td>
+
+<td valign="top" headers="N10DCD ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10DBF ">SYSTEM_USER</td>
+
+<td valign="top" headers="N10DC6 ">SQL92I</td>
+
+<td valign="top" headers="N10DCD ">No</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">表ã®å¶ç´</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã:表ã®å¶ç´</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N10E82">æ©è½</th>
+
+<th valign="bottom" id="N10E89">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N10E90"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10E82 ">TABLE CONSTRAINTS</td>
+
+<td valign="top" headers="N10E89 ">SQL92I</td>
+
+<td valign="top" headers="N10E90 "><em>SYS.SYSCONSTRAINTS</em></td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10E82 ">REFERENTIAL CONSTRAINTS</td>
+
+<td valign="top" headers="N10E89 ">SQL92I</td>
+
+<td valign="top" headers="N10E90 "><em>SYS.SYSFOREIGNKEYS</em></td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10E82 ">CHECK CONSTRAINTS</td>
+
+<td valign="top" headers="N10E89 ">SQL92I</td>
+
+<td valign="top" headers="N10E90 "><em>SYS.SYSCHECKS</em></td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">ã¹ãã¼ãæ
å ±ã®æä¾</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: ã¹ãã¼ãæ
å ±ã®æä¾</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N10F35">æ©è½</th>
+
+<th valign="bottom" id="N10F3C">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N10F43"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10F35 ">SQL_FEATURES</td>
+
+<td valign="top" headers="N10F3C ">SQL92I/FIPS 127-2</td>
+
+<td valign="top" headers="N10F43 ">JDBCã®<em>DatabaseMetaData</em>ãå©ç¨</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10F35 ">SQL_SIZING</td>
+
+<td valign="top" headers="N10F3C ">SQL92I/FIPS 127-2</td>
+
+<td valign="top" headers="N10F43 ">JDBCã®<em>DatabaseMetaData</em>ãå©ç¨</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ¥æã®å
¨æ©è½</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: æ¥æã®å
¨æ©è½</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N10FCD">æ©è½</th>
+
+<th valign="bottom" id="N10FD4">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N10FDB"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10FCD ">TIMEãTIMESTAMPã®ç²¾åº¦</td>
+
+<td valign="top" headers="N10FD4 ">SQL92F</td>
+
+<td valign="top" headers="N10FDB ">Yes</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">å
¨ã¦ã®æååå¦ç</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: å
¨ã¦ã®æååå¦ç</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N1103F">æ©è½</th>
+
+<th valign="bottom" id="N11046">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N1104D"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N1103F ">POSITIONå¼</td>
+
+<td valign="top" headers="N11046 ">SQL92F</td>
+
+<td valign="top" headers="N1104D ">Javaã®ã¡ã½ãããããã¯LOCATEãå©ç¨</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N1103F ">UPPER/LOWER é¢æ°</td>
+
+<td valign="top" headers="N11046 ">SQL92F</td>
+
+<td valign="top" headers="N1104D ">Yes</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§ã
</h4>
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92ã®æ©è½ã®ãµãã¼ã: æ§ã
</caption>
+<thead align="left">
+<tr valign="bottom">
+<th valign="bottom" id="N110CB">æ©è½</th>
+
+<th valign="bottom" id="N110D2">å®ç¾©ããä»æ§</th>
+
+<th valign="bottom" id="N110D9"><span>Derby</span></th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N110CB ">ããªãããããèå¥å</td>
+
+<td valign="top" headers="N110D2 ">SQL92E</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ç¸äºã«é¢é£ããå¯ååã</td>
+
+<td valign="top" headers="N110D2 ">SQL92E</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">æ¿å
¥ã»æ´æ°ã»åé¤æ</td>
+
+<td valign="top" headers="N110D2 ">SQL92E</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">çµå</td>
+
+<td valign="top" headers="N110D2 ">SQL92E</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">Whereã«ããéå®</td>
+
+<td valign="top" headers="N110D2 ">SQL92E</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">Group by</td>
+
+<td valign="top" headers="N110D2 ">SQL92E</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">Having</td>
+
+<td valign="top" headers="N110D2 ">SQL92E</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">éç´é¢æ°</td>
+
+<td valign="top" headers="N110D2 ">SQL92E</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">Order by</td>
+
+<td valign="top" headers="N110D2 ">SQL92E</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">é¸æå¼</td>
+
+<td valign="top" headers="N110D2 ">SQL92E</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">Select *</td>
+
+<td valign="top" headers="N110D2 ">SQL92E</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">SQLCODE</td>
+
+<td valign="top" headers="N110D2 ">SQL92E</td>
+
+<td valign="top" headers="N110D9 ">No SQL-92ã§ã¯æ¨å¥¨ãããªãã</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">SQLSTATE</td>
+
+<td valign="top" headers="N110D2 ">SQL92E</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ãã¥ã¼ã§ã®UNIONãINTERSECTããã³EXCEPT</td>
+
+<td valign="top" headers="N110D2 ">SQL92T</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">æé»ã®æ°å¤åå¤æ</td>
+
+<td valign="top" headers="N110D2 ">SQL92T</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">æé»ã®æåååå¤æ</td>
+
+<td valign="top" headers="N110D2 ">SQL92T</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">診ææ
å ±ã®åå¾</td>
+
+<td valign="top" headers="N110D2 ">SQL92T</td>
+
+<td valign="top" headers="N110D9 ">JDBCã®<em>SQLExceptions</em>ãå©ç¨</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ã°ã«ã¼ãã¸ã®å¦ç</td>
+
+<td valign="top" headers="N110D2 ">SQL92T</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">selectã®é¸æé
ç®ä¸è¦§ã«ãããéå®ããã*</td>
+
+<td valign="top" headers="N110D2 ">SQL92T</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">å°æåã®èå¥å</td>
+
+<td valign="top" headers="N110D2 ">SQL92T</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">空å¤ã¨ãããã¨ã®ã§ãã主ãã¼</td>
+
+<td valign="top" headers="N110D2 ">SQL92T</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">è¤æ°ã®ã¢ã¸ã¥ã¼ã«ãµãã¼ã</td>
+
+<td valign="top" headers="N110D2 ">SQL92T</td>
+
+<td valign="top" headers="N110D9 ">No (JDBCã®ä¸é¨ã§ã¯ãªããå¿
è¦ã§ã¯ãªãã)</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">åç
§æ§ã®åé¤å¦ç</td>
+
+<td valign="top" headers="N110D2 ">SQL92T</td>
+
+<td valign="top" headers="N110D9 ">CASCADEãSET NULLãRESTRICTãNO ACTION</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">CASTé¢æ°</td>
+
+<td valign="top" headers="N110D2 ">SQL92T</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">INSERTå¼</td>
+
+<td valign="top" headers="N110D2 ">SQL92T</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">æ示çãªæ¢å®å¤</td>
+
+<td valign="top" headers="N110D2 ">SQL92T</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ãã¼ã¯ã¼ãã®ç·©å</td>
+
+<td valign="top" headers="N110D2 ">SQL92T</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">Domainã®å®ç¾©</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">CASEå¼</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">é¨åçã«ãµãã¼ã</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">åæãããæååã®å®æ°</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">é£çµãå©ç¨ã§ãã</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">LIKEã®æ©è½å¼·å</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">UNIQUEã®è¿°èª</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">表ã®å©ç¨æ
å ±</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 "><em>SYS.SYSDEPENDS</em> </td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ä¸éçãªæ
å ±ã¹ãã¼ã</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">JDBCã®<em>DatabaseMetaData</em>ããã³<span>Derby</span>ã®ã·ã¹ãã 表ãå©ç¨å¯</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">å¯ããã°ã©ã ã®ãµãã¼ã</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">ããæ©è½ãè±å¯ãªJDBCã§ã¯é¢ä¿ãç¡ãã</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ä¸éçãªSQLã¸ã®ãã©ã°ä»ã</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ã¹ãã¼ãã®æä½</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">é·ãèå¥å</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">両å´ã¸ã®å¤é¨çµå</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ã¿ã¤ã ã¾ã¼ã³ã®æå®</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ã¹ã¯ãã¼ã«å¯è½ãªã«ã¼ã½ã«</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">é¨åç (JDBC2.0ã§ã¯ã¹ã¯ãã¼ã«å¯è½ãªinsensitiveãªã«ã¼ã½ã«ã)</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ä¸éçãªéåé¢æ°ã®ãµãã¼ã</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">é¨åçã«å®ç¾</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">æåã»ããã®å®ç¾©</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">Javaã®ãã±ã¼ã«ããµãã¼ã</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">æåã»ããã¸ã®ååä»ã</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">Javaã®ãã±ã¼ã«ããµãã¼ã</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ã¹ã«ã©ã¼å¯ååãã®å¤</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">æ¡å¼µãããnullè¿°é¨</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">å¶ç´ã®ç®¡ç</td>
+
+<td valign="top" headers="N110D2 ">SQL92I</td>
+
+<td valign="top" headers="N110D9 ">Yes (ADD/DROP CONSTRAINT)</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">FOR BIT DATA å</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">Yes </td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">Assertion å¶ç´</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ä¸æ表</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">DECLARE GLOBAL TEMPORARY TABLEã§ãé¨åçã«å®ç¾ã</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">å®å
¨ãªåçSQL</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">å®å
¨ãªvalueså¼</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">çã®å¤å¤å®</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">å°åºè¡¨ãFROMã«ããã</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ã¢ã³ãã¼ã¹ã³ã¢ãå¾ã«ã¤ãããã¨ãã§ãã</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">Indicatorãã¼ã¿å</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">JDBCã¨ã¯é¢é£ããªãã</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">åç
§ããååã®é çª</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">å®å
¨ãªSQLã®ãã©ã°ä»ã</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">è¡ããã³è¡¨ã®æ§ç¯å</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ã«ã¿ãã°åã®éå®å</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">åç´è¡¨</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">CHECKå¶ç´ã§ã®å¯ååã</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">No ãã ãJavaã®ã¡ã½ããã§åçã®ãã¨ãã§ããã</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">Union join</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">Collationãtranslation</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">Javaã®ãã±ã¼ã«ãå©ç¨å¯è½</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">åç
§æ§ã®æ´æ°å¦ç</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">RESTRICTããã³NO ACTIONã ããªã¬ã«ãããã®ä»ãå¯è½ã</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ALTER domain</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">INSERT å権é</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">åç
§æ§ã®MATCHå</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ãã¥ã¼ã®CHECKå¶ç´ã®æ©è½å¼·å</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">Noããã¥ã¼ã¯æ´æ°ã§ããªãã</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">Session管ç</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">JDBCãå©ç¨</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">æ¥ç¶ç®¡ç</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">JDBCãå©ç¨</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">èªå·±åç
§çãªæä½</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">Yes</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">insensitiveãªã«ã¼ã½ã«</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">Yes JDBC 2.0ãéãã¦å¯è½</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">å®å
¨ãªéåé¢æ°</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">é¨åçãªå®ç¾</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ã«ã¿ãã°ã¸ã®ãã©ã°ä»ã</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">å±æçãªè¡¨ã¸ã®åç
§</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N110CB ">ã«ã¼ã½ã«å
¨ä½ã®æ´æ°</td>
+
+<td valign="top" headers="N110D2 ">SQL92F</td>
+
+<td valign="top" headers="N110D9 ">No</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj23296.html" title="">SQLè¨èªã®ãªãã¡ã¬ã³ã¹</a></div>
+</div>
+<div class="relconcepts"><strong>é¢é£æ¦å¿µ</strong><br />
+<div><a href="crefsqlj18919.html" title="">SQLã®èå¥å</a></div>
+<div><a href="crefsqlj39374.html" title="">æ</a></div>
+<div><a href="crefsqlbuiltinsystemfunctions.html" title="">çµè¾¼ã¿ã·ã¹ãã é¢æ°</a></div>
+<div><a href="crefjdbc12657.html" title="Derbyã¯çµã¿è¾¼ã¿ã®JDBCãã©ã¤ãã¨å
±ã«æä¾ããã¾ãã">JDBC ãªãã¡ã¬ã³ã¹</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefsqlj28468.html" title="">大æåå°æåã¨ç¹æ®æå</a></div>
+<div><a href="rrefclauses.html" title="">SQL ç¯</a></div>
+<div><a href="rrefsqlj19433.html" title="å¤ãã®æãå¼ã®æ§æã®èªå¥ã«ãå¼ã表å¯ååãã®ãããªå¼ã®ä¸ç¨®ãããã¾ãã å¼ã¯æã®å®ããããå ´æã«ç½®ããã¨ãã§ãã¾ãã">SQLå¼</a></div>
+<div><a href="rrefsqlj29840.html" title="">JOIN æ¼ç®</a></div>
+<div><a href="rrefqueries.html" title="">SQL åãåãã</a></div>
+<div><a href="rrefsqlj29026.html" title="">çµã¿è¾¼ã¿é¢æ°</a></div>
+<div><a href="rrefkeywords29722.html" title="">SQLäºç´èª</a></div>
+<div><a href="rrefsistabs38369.html" title="">Derbyã®ã·ã¹ãã 表</a></div>
+<div><a href="rrefexcept16677.html" title="Derbyã«ã¦çºçããå
¨ã¦ã®ã¨ã©ã¼ã¯ãJDBCããSQLExceptionã¨ãã¦æããã¾ãã ããã¦ã¼ã¶ã®å®ç¾©ããåããä¾å¤ãæãã£ã¦ããã®ä¾å¤ãSQLExceptionã§ã¯ç¡ãå ´åããã®ä¾å¤ã¯SQLExceptionã«ã©ããããã¦ãã¾ãã Derbyåºæã®SQLExceptionã¯ãSQLStateã¯ã©ã¹ã«å®ç¾©ãããXã§å§ã¾ãã³ã¼ããç¨ãã¾ããæ¨æºã«å®ç¾©ãããSQLStateã®å¤ã¯ã対å¿ããä¾å¤ã«å¯¾ãã¦è¿ããã¾ãã">Derbyã®ä¾å¤ã¡ãã»ã¼ã¸ã¨SQL state</a></div>
+<div><a href="rrefjdbc87220.html" title="">java.sql.BatchUpdateException ã¯ã©ã¹</a></div>
+<div><a href="rrefjdbcjsr169.html" title="">Connected Device Configurationããã³Foundation Profileåãã®JDBCããã±ã¼ã¸(JSR169)</a></div>
+<div><a href="rrefjdbc32593.html" title="">JDBC 3.0ã®æ©è½</a></div>
+<div><a href="rrefjdbc4_0summary.html" title="">JDBC 4.0ã®æ©è½</a></div>
+<div><a href="rrefjdbc1020262.html" title="">JDBCã¨ã¹ã±ã¼ãã®æ§æ</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsql9241891.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj1055824.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj1055824.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj1055824.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,57 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="CURRENT TIME" />
+<meta content="CURRENT TIME é¢æ°" name="DC.subject" />
+<meta content="CURRENT TIME é¢æ°" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj1055824" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>CURRENT TIME</title>
+</head>
+<body id="rrefsqlj1055824"><a name="rrefsqlj1055824"><!-- --></a>
+
+
+<h1 class="topictitle1">CURRENT TIME</h1>
+
+
+<div>
+<div class="section"> <p>CURRENT TIME ã¯<a href="rrefsqlj33772.html#rrefsqlj33772">CURRENT_TIME</a>ã®å¥åã§ãã</p>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefsqlj29026.html" title="">çµã¿è¾¼ã¿é¢æ°</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj1055824.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj10696.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj10696.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj10696.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,81 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="INTEGER ãã¼ã¿å" />
+<meta content="INTEGER data type" name="DC.subject" />
+<meta content="INTEGER data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj10696" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>INTEGER ãã¼ã¿å</title>
+</head>
+<body id="rrefsqlj10696"><a name="rrefsqlj10696"><!-- --></a>
+
+
+<h1 class="topictitle1">INTEGER ãã¼ã¿å</h1>
+
+
+<div>
+<div class="section"> <p>INTEGERã¯æ´æ°ã4ãã¤ãã®é åã«è¨é²ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>{ INTEGER | INT }</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">対å¿ããã³ã³ãã¤ã«æã®Javaã®å</h4> <p><em>java.lang.Integer</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBCã®ã¡ã¿ãã¼ã¿å (java.sql.Types)</h4> <p>INTEGER</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">æå°å¤</h4> <p id="rrefsqlj10696__sqlj88368"><a name="rrefsqlj10696__sqlj88368"><!-- --></a>-2147483648
+(<em>java.lang.Integer.MIN_VALUE</em>)</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">æ大å¤</h4> <p id="rrefsqlj10696__sqlj81992"><a name="rrefsqlj10696__sqlj81992"><!-- --></a>2147483647 (<em>java.lang.Integer.MAX_VALUE</em>)</p>
+
+<p>ä»ã®ãã¼ã¿åã¨æ··å¨ãã¦å¼ä¸ã§å©ç¨ãããå ´åãå¼ã®çµæã¨ãªãåã¯<a href="rrefsqlj27767.html#rrefsqlj27767">å¼ã«ã¦è¡ãããæ°å¤åã®é
ç®</a>ã«è¨è¿°ãããè¦åã«ã®ã£ã¨ã£ã¦æ±ºã¾ãã¾ãã</p>
+
+<p><a href="rrefsqlj20204.html#rrefsqlj20204">æ°å¤ãç°ãªãæ°å¤åã®åã«è¨é²ãã</a>ãåç
§ãã¦ãã ããã</p>
+ </div>
+
+<div class="example"> <pre><strong>3453
+425</strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj31068.html" title="">ãã¼ã¿å</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj10696.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj1080779.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj1080779.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj1080779.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,101 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="å¼ã«é¢ããåªå
é ä½" />
+<meta content="Expressions, hierarchy of, precedence of" name="DC.subject" />
+<meta content="Expressions, hierarchy of, precedence of" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj19433.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefselectexpression.html" />
+<meta scheme="URI" name="DC.Relation" content="rreftableexpression.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj11277.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj23075.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj29911.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj1080779" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>å¼ã«é¢ããåªå
é ä½</title>
+</head>
+<body id="rrefsqlj1080779"><a name="rrefsqlj1080779"><!-- --></a>
+
+
+<h1 class="topictitle1">å¼ã«é¢ããåªå
é ä½</h1>
+
+
+<div>
+<div class="section"><div class="p">æ¼ç®åã®åªå
é ä½ãé«ããã®ããä½ããã®ã«ä¸¦ã¹ã¦ç¤ºãã¾ãã <ul>
+<li>(), ?, å®æ° (符å·ãå«ã), NULL, <em>ååç
§</em>, <em>ã¹ã«ã©ã¼å¯ååã</em>,
+CAST</li>
+
+<li>LENGTH, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, ãã®ä»ã®çµè¾¼ã¿é¢æ°</li>
+
+<li>åä¸ã®ãªãã©ã³ããã¨ã+ããã³-</li>
+
+<li>*, /, || (é£çµ)</li>
+
+<li>äºã¤ã®ãªãã©ã³ããã¨ã+ããã³-</li>
+
+<li>æ¯è¼ã å®éæ¯è¼ã EXISTS, IN, IS NULL, LIKE, BETWEEN,
+IS</li>
+
+<li>NOT</li>
+
+<li>AND</li>
+
+<li>OR</li>
+
+</ul>
+</div>
+</div>
+
+<div class="section"><p>æ¼ç®åãæ¬å¼§ã®ä¸ã«æ¸ããã¨ã«ãããåªå
é ä½ãæ示çã«æå®ãããã¨ãã§ãã¾ããæ¬å¼§ã®å¤ã«ããæ¼ç®åãæ¬å¼§ã®ä¸ã®å¼ã«é©ç¨ãããåã«ãæ¬å¼§ã®ä¸ã®æ¼ç®åã¯è©ä¾¡ããã¾ãã</p>
+</div>
+
+<div class="example"><h4 class="sectiontitle">ä¾</h4>
+<pre><strong>(3+4)*9
+(age < 16 OR age > 65) AND employed = TRUE</strong></pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefsqlj19433.html" title="å¤ãã®æãå¼ã®æ§æã®èªå¥ã«ãå¼ã表å¯ååãã®ãããªå¼ã®ä¸ç¨®ãããã¾ãã å¼ã¯æã®å®ããããå ´æã«ç½®ããã¨ãã§ãã¾ãã">SQLå¼</a></div>
+</div>
+<div class="relconcepts"><strong>é¢é£æ¦å¿µ</strong><br />
+<div><a href="crefsqlj29911.html" title="">åçãã©ã¡ã¼ã¿</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefselectexpression.html" title="">é¸æå¼</a></div>
+<div><a href="rreftableexpression.html" title="">TableExpression</a></div>
+<div><a href="rrefsqlj11277.html" title="">VALUESå¼</a></div>
+<div><a href="rrefsqlj23075.html" title="">çå½å¼</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj1080779.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj1082953.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj1082953.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj1082953.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,68 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="åçãã©ã¡ã¼ã¿ã®ä¾" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj29911.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj1083019.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj1082953" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>åçãã©ã¡ã¼ã¿ã®ä¾</title>
+</head>
+<body id="rrefsqlj1082953"><a name="rrefsqlj1082953"><!-- --></a>
+
+
+<h1 class="topictitle1">åçãã©ã¡ã¼ã¿ã®ä¾</h1>
+
+<div>
+<div class="example"> <pre><strong>PreparedStatement ps2 = conn.prepareStatement(
+ "UPDATE HotelAvailability SET rooms_available = " +
+ "(rooms_available - ?) WHERE hotel_id = ? " +
+ "AND booking_date BETWEEN ? AND ?");
+<span>-- ãã®ã³ã¼ãä¾ã§ã¯åçãã©ã¡ã¼ã¿ã«
+-- ããã°ã©ã å¤æ°ã®å¤ã代å
¥ãã¾ãã</span>
+ps2.setInt(1, numberRooms);
+ps2.setInt(2, theHotel.hotelId);
+ps2.setDate(3, arrival);
+ps2.setDate(4, departure);
+updateCount = ps2.executeUpdate();</strong></pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj29911.html" title="">åçãã©ã¡ã¼ã¿</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefsqlj1083019.html" title="">åçãã©ã¡ã¼ã¿ãç½®ããå ´æ</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj1082953.html
------------------------------------------------------------------------------
svn:eol-style = native