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 [37/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/rrefsqlj33923.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33923.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33923.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,176 @@
+<!--
+ 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="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj33923" 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="rrefsqlj33923"><a name="rrefsqlj33923"><!-- --></a>
+
+
+<h1 class="topictitle1">éç´ (éåé¢æ°)</h1>
+
+<div>
+<div class="section">
+<p>ãã®ç¯ã¯éç´(ANSI SQL-92ã§ã¯<em>éåé¢æ°</em>ããã¼ã¿ãã¼ã¹ã®æ¸ç±ã«ãã£ã¦ã¯<em>åé¢æ°</em>ã¨å¼ã³ã¾ãã)ã«ã¤ãã¦èª¬æãã¾ããéç´ã¯ãè¡ã®éåã«å¯¾ãã¦å¼ãè©ä¾¡ããæ¹æ³ãæä¾ãã¾ããä»ã®çµè¾¼ã¿é¢æ°ã¯åå¼ã«å¯¾ãã¦ä½ç¨ãã¾ãããéç´ã¯å¤ã®éåã«å¯¾ãã¦ä½ç¨ãã¦ä¸ã¤ã®ã¹ã«ã©ã¼å¤ã«ã¾ã¨ãããã¾ããçµè¾¼ã¿ã®éç´ã«ãããå¤ã®éåã«å¯¾ãã¦ãå¼ã®æå°å¤ãæ大å¤ãåè¨ãè¨�
�°ãè¡ããä¾ãã°è¡ãæ°ãããããªäºãã§ãã¾ããã¾ãçµè¾¼ã¿ã®ãã®ã¨ã¯å¥ã«éç´ãä½ã£ã¦ãä¾ãã°æ¨æºåå·®ãè¨ç®ãããããªãã¨ãã§ãã¾ãã</p>
+</div>
+
+<div class="section"><div class="p">
+çµè¾¼ã¿ã®éç´ã¯ã<a href="rrefsqlj33923.html#rrefsqlj33923__sqlj92398">çµè¾¼ã¿ã®éç´ã«ã¦å¯è½ãªãã¼ã¿å</a>ã«ãããã¼ã¿åã«ä½ç¨ããããã¨ãã§ãã¾ãã
+
+<div class="tablenoborder"><a name="rrefsqlj33923__sqlj92398"><!-- --></a><table summary="" cellspacing="0" cellpadding="4" id="rrefsqlj33923__sqlj92398" frame="border" border="1" rules="all"><caption>表 1. çµè¾¼ã¿ã®éç´ã«ã¦å¯è½ãªãã¼ã¿å</caption>
+
+<thead align="left">
+<tr>
+<th valign="top" width="33.33333333333333%" id="N1007E"> </th>
+
+<th align="left" valign="bottom" width="33.33333333333333%" id="N10084">å
¨ãã¼ã¿å</th>
+
+<th align="left" valign="bottom" width="33.33333333333333%" id="N1008D">çµè¾¼ã¿ã®æ°å¤å</th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" width="33.33333333333333%" headers="N1007E ">COUNT</td>
+
+<td valign="top" width="33.33333333333333%" headers="N10084 ">X</td>
+
+<td valign="top" width="33.33333333333333%" headers="N1008D ">X</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="33.33333333333333%" headers="N1007E ">MIN</td>
+
+<td valign="top" width="33.33333333333333%" headers="N10084 "> </td>
+
+<td valign="top" width="33.33333333333333%" headers="N1008D ">X</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="33.33333333333333%" headers="N1007E ">MAX</td>
+
+<td valign="top" width="33.33333333333333%" headers="N10084 "> </td>
+
+<td valign="top" width="33.33333333333333%" headers="N1008D ">X</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="33.33333333333333%" headers="N1007E ">AVG</td>
+
+<td valign="top" width="33.33333333333333%" headers="N10084 "> </td>
+
+<td valign="top" width="33.33333333333333%" headers="N1008D ">X</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="33.33333333333333%" headers="N1007E ">SUM</td>
+
+<td valign="top" width="33.33333333333333%" headers="N10084 "> </td>
+
+<td valign="top" width="33.33333333333333%" headers="N1008D ">X</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+</div>
+
+<div class="section"><div class="p">
+éç´ã¯ä»¥ä¸ã®æèã«ã®ã¿ç½®ããã¨ãã§ãã¾ãã<ul>
+<li><em><a href="rrefselectexpression.html#rrefselectexpression">é¸æå¼</a></em>ã®<em>é¸æé
ç®</em></li>
+
+<li><a href="rrefsqlj14854.html#rrefsqlj14854">HAVINGç¯</a></li>
+
+<li>éç´ããã®ååãã«ãããªãã°ã<a href="rrefsqlj13658.html#rrefsqlj13658">ORDER BY ç¯</a>(å¥åã使ã)ã¤ã¾ãã<em><a href="rrefselectexpression.html#rrefselectexpression">é¸æå¼</a></em>ã®<em>é¸æé
ç®</em>ã«éç´ãããå ´åã«éããéç´ã¸ã®å¥åã<a href="rrefsqlj13658.html#rrefsqlj13658">ORDER BY ç¯</a>ã«ç½®ããã¨ãã§ãã¾ãã</li>
+
+</ul>
+</div>
+</div>
+
+<div class="section"><div class="p"><em><a href="rrefselectexpression.html#rrefselectexpression">é¸æå¼</a></em>ã®<em>é¸æé
ç®</em>ã«ããå
¨å¼ã¯ãéç´ãåé¡åã§ããå¿
è¦ãããã¾ãã(<a href="rrefsqlj32654.html#rrefsqlj32654">GROUP BY ç¯</a>ãåç
§ãã¦ãã ããã)
+(GROUP BY ç¯ããªãã«ãããããããHAVINGç¯ãããå ´åãåæ§ã§ãã)
+ãªããªãã°ã<em><a href="rrefselectexpression.html#rrefselectexpression">é¸æå¼</a></em>ã®<em>ResultSet</em>ã¯ãã¹ã«ã©ã¼(åå¤)ããã¯ãã«(å¯å¤)ã®ããããã§ãªããã°ãªããããã®æ··åã¯è¨±ããã¦ããªãããã§ãã(éç´ã¯ã¹ã«ã©ã¼ã®å¤ã¨è©ä¾¡ãããåã¸ã®åç
§ã¯ãã¯ãã«ã®å¤ã¨è©ä¾¡ããã¾ãã)ä¾ãã°æ¬¡ã®ååãã¯ã¹ã«ã©ã¼ã¨ãã¯ãã«ã®å¤ãæ··ãã£ã¦ããã®ã§ç¡å¹ã§ãã
+<pre><strong><span>-- not valid</span>
+SELECT MIN(flying_time), flight_id
+FROM Flights</strong></pre>
+</div>
+</div>
+
+<div class="section"><div class="p">éç´ã«ã¦å¤é¨ã¸ã®åç
§(ç¸é¢)ã¯ç¡å¹ã§ããã¤ã¾ããå¯ååããéç´ãå«ããªãã°ããã®éç´ãä½ç¨ããå¼ã¯ãå¯ååãã®å¤ã«ããååãã®åãåç
§ã§ãã¾ããã
+ä¾ãã°ãSUMæ¼ç®åãå¤ã®ååãã®åã«å¯¾ãã¦è¡ããã¦ããã®ã§ã次ã®ååãã¯æå¹ã§ã¯ããã¾ããã
+<pre><strong>SELECT c1
+FROM t1
+GROUP BY c1
+HAVING c2 >
+ (SELECT t2.x
+ FROM t2
+ WHERE t2.y = SUM(t1.c3)) </strong></pre>
+</div>
+</div>
+
+<div class="section"><p>éç´ãå¤ã®ååãã«ããå ´åããã®<em>ResultSet</em>ã®ã«ã¼ã½ã«ã¯æ´æ°å¯è½ã§ã¯ããã¾ããã</p>
+</div>
+
+<div class="section"><div class="p">ãã®ç¯ã«ã¯ä»¥ä¸ã®éç´ãããã¾ãã<ul>
+<li><a href="rrefsqlj32693.html#rrefsqlj32693">AVGé¢æ°</a></li>
+
+<li><a href="rrefsqlj38716.html#rrefsqlj38716">COUNT é¢æ°</a></li>
+
+<li><a href="rrefsqlj27781.html#rrefsqlj27781">MAXé¢æ°</a></li>
+
+<li><a href="rrefsqlj33520.html#rrefsqlj33520">MINé¢æ°</a></li>
+
+<li><a href="rrefsqlj13083.html#rrefsqlj13083">SUMé¢æ°</a></li>
+
+</ul>
+</div>
+</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/rrefsqlj33923.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj34148.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj34148.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj34148.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="DROP TABLE æ" />
+<meta content="DROP TABLE statement, Tables, dropping" name="DC.subject" />
+<meta content="DROP TABLE statement, Tables, dropping" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj80721.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefdropfunctionstatement.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj59893.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefdropprocedurestatement.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj31648.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljdropsynonym.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj42082.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj61102.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj34148" 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>DROP TABLE æ</title>
+</head>
+<body id="rrefsqlj34148"><a name="rrefsqlj34148"><!-- --></a>
+
+
+<h1 class="topictitle1">DROP TABLE æ</h1>
+
+
+<div>
+<div class="section"> <p>DROP TABLE ã«ãã表ãç ´æ£ã§ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>DROP TABLE <em><a href="rreftablename.html#rreftablename">表å</a></em></strong></pre>
+ </div>
+
+<div class="section" id="rrefsqlj34148__sqlj38361"><a name="rrefsqlj34148__sqlj38361"><!-- --></a><h4 class="sectiontitle">æã®ä¾å</h4>
+<p>表ã®ããªã¬ãå¶ç´(主ãã¼ãä¸æããã§ãã¯ãç ´æ£ãã表ããåç
§)ãç´¢å¼ã¯ãæé»è£¡ã«åé¤ããã¾ããç ´æ£ãããã¨ãã表ã«éããã«ã¼ã½ã«ããã£ãå ´åãDROP TABLEã¯ã¨ã©ã¼ã¨ãªã表ã¯ç ´æ£ããã¾ããã</p>
+ <p>表ãç ´æ£ããã¨ããã®è¡¨ã«ä¾åããæãç¡å¹ã¨ãªãã¾ãã(ç¡å¹ã¨ãªã£ãæã¯æ¬¡åã®å®è¡ã§åã³ã³ãã¤ã«ããã¾ãã<a href="crefsqlj22771.html#crefsqlj22771">ä¾åé¢ä¿</a>ãåç
§ãã¦ãã ããã)</p>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj80721.html" title="">DROPæ</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefdropfunctionstatement.html" title="">DROP FUNCTION æ</a></div>
+<div><a href="rrefsqlj59893.html" title="">DROP INDEX æ</a></div>
+<div><a href="rrefdropprocedurestatement.html" title="">DROP PROCEDURE æ</a></div>
+<div><a href="rrefsqlj31648.html" title="">DROP SCHEMA æ</a></div>
+<div><a href="rrefsqljdropsynonym.html" title="">DROP SYNONYM æ</a></div>
+<div><a href="rrefsqlj42082.html" title="">DROP TRIGGER æ</a></div>
+<div><a href="rrefsqlj61102.html" title="">DROP VIEW æ</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj34148.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj34177.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj34177.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj34177.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,67 @@
+<!--
+ 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_DATEé¢æ°" />
+<meta content="CURRENT_DATE function" name="DC.subject" />
+<meta content="CURRENT_DATE function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj34177" 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_DATEé¢æ°</title>
+</head>
+<body id="rrefsqlj34177"><a name="rrefsqlj34177"><!-- --></a>
+
+
+<h1 class="topictitle1">CURRENT_DATEé¢æ°</h1>
+
+
+<div>
+<div class="section"> <p>CURRENT_DATEã¯ç¾å¨ã®æ¥ä»ãè¿ãã¾ãããªãä¸ã¤ã®æã§è¤æ°å¼ã°ããæã«è¿ãããå¤ã¯åãã§ããå¾ã£ã¦æéãç½®ãã¦ã«ã¼ã½ã«ãè¡ãæ¾ãã¨ãã§ããå¤ã¯åºå®ããã¦ãã¦åãã¨ãããã¨ã§ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4>
+<pre><strong>CURRENT_DATE</strong></pre>
+ <p>ãããã¯</p>
+ <pre><strong>CURRENT DATE</strong></pre>
+ </div>
+
+<div class="example"> <pre><strong><span>-- ç¾å¨ãã以éã®æ¥ä»ã®ä¾¿ãæ¢ãã</span>
+SELECT * FROM Flightavailability where flight_date > CURRENT_DATE;</strong></pre>
+ </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/rrefsqlj34177.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj35034.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj35034.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj35034.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,120 @@
+<!--
+ 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="INNER JOIN æ¼ç®" />
+<meta content="INNER JOIN æ¼ç®" name="DC.subject" />
+<meta content="INNER JOIN æ¼ç®" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29840.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj35034" 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>INNER JOIN æ¼ç®</title>
+</head>
+<body id="rrefsqlj35034"><a name="rrefsqlj35034"><!-- --></a>
+
+
+<h1 class="topictitle1">INNER JOIN æ¼ç®</h1>
+
+
+<div>
+<div class="section"> <p>INNER JOINã¨ã¯ãæ示çãªçµåå¥ãè¨è¿°ãããã¨ãã§ããã<a href="rrefsqlj29840.html#rrefsqlj29840">JOIN æ¼ç®</a>ã§ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong><em><a href="rreftableexpression.html#rreftableexpression">表å¼</a></em> [ INNER ] JOIN <em><a href="rreftableexpression.html#rreftableexpression">表å¼</a></em> { ON <em>çå½å¼</em> }</strong></pre>
+
+<p>ONã«çå½å¼ãè¨è¿°ãããã¨ã§ãçµåå¥ãè¨è¿°ã§ãã¾ãã</p>
+
+<div class="p">ONç¯ã«ããå¼ã§ã¯ãç´æ¥ã®è¡¨ããã³ãå¤é¨ã®åãåããæãããç´æ¥ã®SELECTæã¾ã§ã®éã«ãã表ãå¯è¦ã§ãã
+以ä¸ã®ä¾ã§ã¯ONç¯ã¯ç´æ¥ã®è¡¨ãåç
§ãã¦ãã¾ãã
+<pre><strong>SELECT *
+FROM SAMP.EMPLOYEE INNER JOIN SAMP.STAFF
+ON EMPLOYEE.SALARY < STAFF.SALARY
+</strong></pre>
+</div>
+
+<p>ONç¯ã§ã¯çµåããã¦ããªã表ãåç
§ãããã¨ãã§ãã¾ããã¾ãçµåãã¦ãã表ãåç
§ããªãã¦ããã¾ãã¾ããã(ä¸è¬çã«ã¯åç
§ãã¾ãã)</p>
+ </div>
+
+<div class="example"> <pre><strong><span>-- EMP_ACTã¨EMPLOYEEã¨ãã表ãçµåãã¾ãã</span>
+-- EMP_ACTã¨ãã表ããå
¨åãé¸æãã¦ã
+-- EMPLOYEEã¨ãã表ããå¾æ¥å¡ã®èå(LASTNAME)ãããããã®è¡ã«
+-- å ãã¾ãã
+SELECT SAMP.EMP_ACT.*, LASTNAME
+ FROM SAMP.EMP_ACT JOIN SAMP.EMPLOYEE
+ ON EMP_ACT.EMPNO = EMPLOYEE.EMPNO
+-- EMPLOYEEã¨DEPARTMENTã¨ãã表ãçµåãã¦ã
+-- 1930å¹´ããåã«çã¾ãã(BIRTDATE)å
¨ã¦ã®å¾æ¥å¡ã®ã
+-- å¾æ¥å¡çªå·(EMPNO)ãå¾æ¥å¡ã®èå(LASTNAME)ã
+-- é¨ç½²çªå·(EMPLOYEEã¨ãã表ã®WORKDEPTã¨ãDEPARTMENTã¨ãã表ã®DEPTNO)ã
+-- é¨ç½²å(DEPTNAME)ãé¸æããã
+SELECT EMPNO, LASTNAME, WORKDEPT, DEPTNAME
+ FROM SAMP.EMPLOYEE JOIN SAMP.DEPARTMENT
+ ON WORKDEPT = DEPTNO
+ AND YEAR(BIRTHDATE) < 1930
+
+<span>-- VALUESç¯ããé¸æããåãåãã(selectæã®ä¸ä¾)ã«ããå¤ã"çæ"ããå¥ã®ä¾ </span>
+-- ãã®åãåããã«ãããä¸è¡ã®æ
å ±ãæã¤"R1"ã¨"R2"ã¨ãã2åã®"x"ã¨ãã表ã
+-- ã©ã®ããã«å°åºããã®ã示ãã
+SELECT *
+FROM (VALUES (3, 4), (1, 5), (2, 6))
+AS VALUESTABLE1(C1, C2)
+JOIN (VALUES (3, 2), (1, 2),
+(0, 3)) AS VALUESTABLE2(c1, c2)
+ON VALUESTABLE1.c1 = VALUESTABLE2.c1
+-- This results in:
+-- C1 |C2 |C1 |2
+-- -----------------------------------------------
+-- 3 |4 |3 |2
+-- 1 |5 |1 |2
+
+<span>
+-- å
¨ã¦ã®é¨ç½²ãã管çè
ã®èåã¨å¾æ¥å¡çªå·ã¨å
±ã«ä¸è¦§ããã</span>
+
+SELECT DEPTNO, DEPTNAME, EMPNO, LASTNAME
+ FROM DEPARTMENT INNER JOIN EMPLOYEE
+ ON MGRNO = EMPNO
+
+<span>-- å
¨ã¦ã®å¾æ¥å¡ã®å¾æ¥å¡çªå·ã¨èåãã
+-- ãã®ç®¡çè
ã®å¾æ¥å¡çªå·ã¨èåã¨å
±ã«ä¸è¦§ããã</span>
+SELECT E.EMPNO, E.LASTNAME, M.EMPNO, M.LASTNAME
+ FROM EMPLOYEE E INNER JOIN
+ DEPARTMENT INNER JOIN EMPLOYEE M
+ ON MGRNO = M.EMPNO
+ ON E.WORKDEPT = DEPTNO</strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefsqlj29840.html" title="">JOIN æ¼ç®</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj35034.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj35981.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj35981.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj35981.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,87 @@
+<!--
+ 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="DELETE æ" />
+<meta content="DELETE statement, Read-write VTIs, and DELETES" name="DC.subject" />
+<meta content="DELETE statement, Read-write VTIs, and DELETES" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj39374.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj35981" 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>DELETE æ</title>
+</head>
+<body id="rrefsqlj35981"><a name="rrefsqlj35981"><!-- --></a>
+
+
+<h1 class="topictitle1">DELETE æ</h1>
+
+
+<div>
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>{
+ DELETE FROM 表å
+ [<em><a href="rrefsqlj33602.html#rrefsqlj33602">WHERE ç¯</a></em>] |
+ DELETE FROM 表å <a href="rrefsqlj15309.html#rrefsqlj15309">WHERE CURRENT OF</a>
+}</strong></pre>
+</div>
+
+<div class="section">
+<p>ä¸ã¤ç®ã®æ¸ãæ¹ã¯ãæ¤ç´¢ã«ããåé¤ã¨å¼ã°ãã表åã¨WHERE ç¯ã«ããçµãè¾¼ã¾ããè¡ãåé¤ããã¾ãã</p>
+</div>
+
+<div class="section"><p>äºã¤ç®ã®æ¸ãæ¹ã¯ãä½ç½®ã«ããåé¤ã¨å¼ã°ããæ´æ°å¯è½ãªã«ã¼ã½ã«ã§ç¾å¨éãã¦ããè¡ãåé¤ããã¾ããæ´æ°å¯è½ãªã«ã¼ã½ã«ã«ã¤ãã¦ã¯<a href="rrefsqlj41360.html#rrefsqlj41360">SELECT æ</a>ãåç
§ãã¦ãã ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">ä¾</h4> <pre><strong>DELETE FROM SAMP.IN_TRAY
+
+stmt.executeUpdate("DELETE FROM SAMP.IN_TRAY WHERE CURRENT OF " +
+ resultSet.getCursorName());</strong></pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æã®ä¾å</h4>
+<p>æ¤ç´¢ã«ããåé¤ã§ã¯ãæãæ´æ°ãã表ããã®ã³ã³ã°ãããªãã(ãã¼ããç´¢å¼ã®ãããªè¨é²ã®åä½)ã«ãæãä¾åãã¾ããæºåãããæ¤ç´¢ã«ããåé¤æã対象ã¨ãã表ã®CREATEãDROP INDEXæã¯ããã®æºåãããæ¤ç´¢ã«ããåé¤æãç¡å¹ã¨ãã¾ãã</p>
+</div>
+
+<div class="section">
+<p>ä½ç½®ã«ããåé¤ã§ã¯ãæãã«ã¼ã½ã«ãã«ã¼ã½ã«ãåç
§ãã表ã«ä¾åãã¾ãããã¨ãã¾ã ã«ã¼ã½ã«ãéãã¦ãªãã¦ããä½ç½®ã«ããåé¤ã®æã¯ã³ã³ãã¤ã«å¯è½ã§ããããã§ããJDBCã®<em>close</em>ã¡ã½ããã«ããéããã«ã¼ã½ã«ãåãé¤ãããã¨ãä½ç½®ã«ããåé¤ã®æã¯ç¡å¹ã«ãªãã¾ãã</p>
+</div>
+
+<div class="section">
+<p>
+æºåãããä½ç½®ã«ããåé¤ã®æã対象ã¨ãã表ã®CREATEãDROP INDEXæã¯ããã®æºåãããä½ç½®ã«ããåé¤ã®æãç¡å¹ã¨ãã¾ãã</p>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj39374.html" title="">æ</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj35981.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj36146.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj36146.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj36146.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,122 @@
+<!--
+ 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="Precision, of decimal arithmetic expressions, Scale" name="DC.subject" />
+<meta content="Precision, of decimal arithmetic expressions, Scale" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj41507.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj28138.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj27767.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj20204.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj36146" 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="rrefsqlj36146"><a name="rrefsqlj36146"><!-- --></a>
+
+
+<h1 class="topictitle1">å°æ°ãè¨ç®ããã¨ãã®ç®çã</h1>
+
+
+<div>
+<div class="section"><p>SQLæã«ã¯ãç°ãªã<em>精度</em>(å°æ°ç¹ãã¯ããã 両æ¹ã«ããæ¡ã®æ°ã§ã)ã<em>ç®çã</em>(å°æ°é¨ã®æ¡ã®æ°ã§ã)ã®å°æ°åã使ã£ãè¨ç®å¼ãæ¸ããã¨ãã§ãã¾ãã
+è¨ç®çµæã«ã¦å°æ°åã®ç²¾åº¦ãç®çããã©ããªããã¯ãªãã©ã³ãã«ä¾åãã¾ãã</p>
+</div>
+
+<div class="section"><div class="p">å°æ°ã®ãªãã©ã³ããäºã¤ä¸ããããã¨ãã¦ã:
+ <ul>
+<li><em>lp</em>ã¯å·¦è¾ºã®ãªãã©ã³ãã®ç²¾åº¦ã¨ãã¾ãã</li>
+
+<li><em>rp</em>ã¯å³è¾ºã®ãªãã©ã³ãã®ç²¾åº¦ã¨ãã¾ãã</li>
+
+<li><em>ls</em>ã¯å·¦è¾ºã®ãªãã©ã³ãã®ç®çãã¨ãã¾ãã</li>
+
+<li><em>rs</em>ã¯å³è¾ºã®ãªãã©ã³ãã®ç®çãã¨ãã¾ãã</li>
+
+</ul>
+</div>
+</div>
+
+<div class="section"><div class="p">çµæã®ãã¼ã¿åã®ç®çãã¯ãããããã®è¨ç®æ¹æ³ã«ã¤ãã¦ã次å¼ã®ã¨ããã§ãã<ul>
+<li><em>æãç®</em> <p>ls + rs</p>
+</li>
+
+<li><em>å²ãç®</em> <p>31 - lp + ls - rs</p>
+</li>
+
+<li><em>AVG()</em> <p>max(max(ls, rs), 4)</p>
+</li>
+
+<li><em>ãã®ä»å
¨é¨</em> <p>max(ls, rs)</p>
+</li>
+
+</ul>
+</div>
+</div>
+
+<div class="section"><div class="p">ä¾ãã°ã次å¼ã®çµæã§ã¯ãã¼ã¿åã®ç®çãã¯27ã§ãã
+<pre>11.0/1111.33
+<strong>// 31 - 3 + 1 - 2 = 27 </strong></pre>
+</div>
+</div>
+
+<div class="section"><div class="p">çµæã®ãã¼ã¿åã®ç²¾åº¦ã¯ãããããã®è¨ç®æ¹æ³ã«ã¤ãã¦ã次å¼ã®ã¨ããã§ãã<ul>
+<li><em>æãç®</em> <p>lp + rp</p>
+</li>
+
+<li><em>足ãç®</em> <p>2 * (p - s) + s</p>
+</li>
+
+<li><em>å²ãç®</em> <p>lp - ls + rp + max(ls + rp - rs + 1, 4)</p>
+</li>
+
+<li><em>ãã®ä»å
¨é¨</em> <p>max(lp - ls, rp - rs) + 1 + max(ls, rs)</p>
+</li>
+
+</ul>
+</div>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj41507.html" title="">æ°å¤å</a></div>
+</div>
+<div class="relconcepts"><strong>é¢é£æ¦å¿µ</strong><br />
+<div><a href="crefsqlj28138.html" title="">æ°å¤åã®æ¦è¦</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefsqlj27767.html" title="">å¼ã«ã¦è¡ãããæ°å¤åã®é
ç®</a></div>
+<div><a href="rrefsqlj20204.html" title="">æ°å¤ãç°ãªãæ°å¤åã®åã«è¨é²ãã</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj36146.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj37836.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj37836.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj37836.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,185 @@
+<!--
+ 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="en-us" xml:lang="en-us">
+<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="Identity column attributes, generated-column-spec" name="DC.subject" />
+<meta content="Identity column attributes, generated-column-spec" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj24513.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj30540.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj37836" name="DC.Identifier" />
+<meta content="en-us" 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="rrefsqlj37836"><a name="rrefsqlj37836"><!-- --></a>
+
+
+<h1 class="topictitle1">çºçªåä»æ§</h1>
+
+
+<div>
+<div class="example"> <pre><strong>[ GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY
+[ ( START WITH å®æ´æ°
+[ ,INCREMENT BY å®æ´æ°] ) ] ] ]
+</strong></pre>
+</div>
+
+<div class="section" id="rrefsqlj37836__sqlj69411"><a name="rrefsqlj37836__sqlj69411"><!-- --></a><h4 class="sectiontitle">èå¥ååå±æ§</h4>
+<p>SMALLINTãINTãBIGINTåã®åã«èå¥åå±æ§ãããã¨ã<span>Derby</span>ã¯èªåçã«åã®å¤ã«ãå¢å ããæ´æ°å¤ããã¦ã¾ããæ¿å
¥æã§åã®å¤ãæå®ãããªãå ´åãèå¥ååå±æ§ã¯æ¢å®å¤ã¨åæ§ã«æ¯ãèãã<span>Derby</span>ã¯åã«èªåçã«å¤ãä¸ãã¾ãã
+ããããªããããã®å¤ã¯å®æ°ã§ã¯ããã¾ããã<span>Derby</span>ã¯è¡ã«æ¿å
¥ããæãèªåçã«æ¢å®å¤ã¸å ç®ãã¦ããã¾ãã</p>
+<div class="p">IDENTITYã¨ãããã¼ã¯ã¼ãã¯åã®ãã¼ã¿åã次ã®ãããã®æ´æ°ã§ããå ´åã«ã®ã¿æå®å¯è½ã§ãã<ul>
+<li>SMALLINT</li>
+
+<li>INT</li>
+
+<li>BIGINT</li>
+
+</ul>
+</div>
+<div class="p"><span>Derby</span>ã«ã¯äºç¨®é¡ã®èå¥ååãããã¾ããã²ã¨ã¤ã¯GENERATED ALWAYSã§ãããä¸ã¤ã¯GENERATED BY DEFAULTã§ãã<dl>
+
+<dt class="dlterm">GENERATED ALWAYS</dt>
+
+<dd>GENERATED ALWAYSã®èå¥ååã¯åã®æ¢å®å¤ããæ¿å
¥ãè¡ãããã¨ããã¨ã«å¢å ããã¦ããã®å¢å ãããå¤ãåã«è¨é²ãã¾ããä»ã®æ¢å®å¤ã¨ã¯éããGENERATED ALWAYSã®èå¥ååã«å¤ãç´æ¥æ¿å
¥ãããããã®å¤ãå¤æ´ããããããã¨ã¯ã§ãã¾ããããã®ä»£ããã«èå¥ååã®å¤ã«ã¯DEFAULTã¨ãããã¼ã¯ã¼ããä¸ããããèå¥ååãæ¿å
¥ããåã®ä¸è¦§ããã¯ããããã¾ãã
+ä¾ãæãã¾ãã<pre>create table greetings
+ (i int generated always as identity, ch char(50));
+insert into greetings values (DEFAULT, 'hello');
+insert into greetings(ch) values ('bonjour');</pre>
+GENERATED ALWAYSãªèå¥ååã«èªåçã«çºçªãããå¤ã¯ä¸æã§ããã¾ãèå¥ååãä½æãã¦ããåã«ç´¢å¼ã¯ä½ããã¾ããã</dd>
+
+
+<dt class="dlterm">GENERATED BY DEFAULT</dt>
+
+<dd><p>GENERATED BY DEFAULTã®èå¥ååã¯ãæ¿å
¥æã«åã¸æ示çãªå¤ãä¸ããããªãã£ãå ´åã®ã¿ãæ¢å®å¤ãå¢å ããã¦ä½¿ãã¾ããGENERATED ALWAYSã®åã¨ã¯éããæ¿å
¥æã«ã¦æ示çãªå¤ãæ¢å®å¤ã®å¤ããã«ä¸ãããã¨ãã§ãã¾ãã</p>
+<div class="p">çæãããæ¢å®å¤ã使ãããã«ã¯ãæ¿å
¥æã«DEFAULTã¨ãããã¼ã¯ã¼ãã使ãããèå¥ååãæ¿å
¥åãªã¹ãããå¤ãã¾ããæ¿å
¥ããå¤ãæå®ããã«ã¯ããã®å¤ãæ¿å
¥æã«å«ãã¾ããä¾ãæãã¾ãã<pre>create table greetings
+ (i int generated by default as identity, ch char(50));
+<strong>-- "1"ãæå®ãã:</strong>
+insert into greetings values (1, 'hi');
+<strong>-- çæãããæ¢å®å¤ã使ã</strong>
+insert into greetings values (DEFAULT, 'salut');
+<strong>-- çæãããæ¢å®å¤ã使ã</strong>
+insert into greetings(ch) values ('bonjour'); </pre>
+
+GENERATED ALWAYSåã¨ã¯ç°ãªããGENERATED BY DEFAULTã®åã§ã¯ä¸ææ§ã¯ä¿éããã¾ããããããã£ã¦ãä¸è¨ã®ä¾ã§ã¯<samp class="codeph">hi</samp>ããã³<samp class="codeph">salut</samp>ã®è¡ã¯ã©ã¡ããåã"1"ã¨ããèå¥å¤ãåãã¾ãããªããªããçæãããåã®å¤ã¯"1"ããå§ã¾ããã¦ã¼ã¶ãæå®ããå¤ã"1"ã ã£ãããã§ããéè¤ãé¿ããããã«ãæ
å ±ã®ãã¼ããã¤ã³ãã¼ããè¡ãã¨ãã«ãã¼ãã«ãä½æãã¦ãã·ã¹ãã ãèªåçæããã�
�ãã®START WITHã®å¤ãä¸ãã¦ãã ããããã®ãããªç¶æ³ããã§ãã¯ãã¦ãèµ·ããªãããã«ããããã«ã主ãã¼ãä¸ææ§å¶ç´ãGENERATED BY DEFAULTã®èå¥ååã«ä½¿ããã¨ãã§ãã¾ãã</div>
+</dd>
+
+</dl>
+</div>
+<p>æ¢å®ã§ã¯èå¥ååã®åæå¤ã¯1ã§ããããã«å¢åå¤ã¯1ã§ãã
+åãå®ç¾©ããã¨ããåæå¤ã¨å¢åå¤ã®ä¸¡æ¹ã«ãSTART WITHã¨INCREMENT BYã¨ãããã¼ã¯ã¼ãã使ã£ã¦ãæ示çãªå¤ãæå®ãããã¨ãã§ãã¾ããããã«å¢åå¤ã«è² ã®å¤ãä¸ããã¨ãæ¿å
¥æ¯ã«<span>Derby</span>ã¯å¤ã<em>æ¸ãã¦</em>ããã¾ãã
+ããå¤ãæ£ã®å¤ã§ããã°ãæ¿å
¥æ¯ã«<span>Derby</span>ã¯å¤ãå¢å ããã¦ããã¾ãã å¤ã«0ãä¸ããã¨ä¾å¤ãçºçãã¾ãã</p>
+
+<div class="p">èå¥ååã«ã¦å¯è½ãªæ大å¤ã¨æå°å¤ã¯ãåã®ãã¼ã¿åã«ããã¾ãããã¼ã¿åã§æ¡ããã¨ã®ã§ããç¯å²å¤ã®å¤ãæ¿å
¥ãããã¨ããã¨ãä¾å¤ãçºçãã¾ãã
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>Table 1. çºçªåä»æ§ã«ã¦ãåã§ã¨ããã¨ãå¯è½ãªæ大å¤ã¨æå°å¤</caption>
+
+<thead align="left">
+<tr>
+<th align="left" valign="bottom" width="16%" id="N10137">ãã¼ã¿å</th>
+
+<th align="left" valign="bottom" width="42%" id="N10140">æ大å¤</th>
+
+<th align="left" valign="bottom" width="42%" id="N10149">æå°å¤</th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" width="16%" headers="N10137 ">SMALLINT</td>
+
+<td valign="top" width="42%" headers="N10140 ">32767 (<em>java.lang.Short.MAX_VALUE</em>)</td>
+
+<td valign="top" width="42%" headers="N10149 ">-32768 (<em>java.lang.Short.MIN_VALUE</em>)</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="16%" headers="N10137 ">INT</td>
+
+<td valign="top" width="42%" headers="N10140 ">2147483647 (<em>java.lang.Integer.MAX_VALUE</em>)</td>
+
+<td valign="top" width="42%" headers="N10149 ">-2147483648 (<em>java.lang.Integer.MIN_VALUE</em>)</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="16%" headers="N10137 ">BIGINT</td>
+
+<td valign="top" width="42%" headers="N10140 ">9223372036854775807 (<em>java.lang.Long.MAX_VALUE</em>)</td>
+
+<td valign="top" width="42%" headers="N10149 ">-9223372036854775808 (<em>java.lang.Long.MIN_VALUE</em>)</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+<p>èå¥ååã«ã¦èªåçã«çæãããå¤ã¯ä¸æã§ãã主ãã¼å¶ç´ãä¸ææ§å¶ç´ãåã«å®ç¾©ãããã¨ã§ãä¸ææ§ãä¿éããäºãã§ãã¾ããèå¥ååãå®ç¾©ãã¦ããåã®ç´¢å¼ã¯<em>ä½ããã¾ãã
+ã</em></p>
+
+<p><samp class="codeph">IDENTITY_VAL_LOCAL</samp>é¢æ°ã¯ãé決å®æ§ã®é¢æ°ã§æå¾ã«èå¥ååã«ä¸ããããå¤ãè¿ãã¾ãã詳細ã«ã¤ãã¦ã¯ã<a href="rrefidentityvallocal.html#rrefidentityvallocal">IDENTITY_VAL_LOCALé¢æ°</a>ãåç
§ãã¦ãã ããã</p>
+
+<div class="note"><span class="notetitle">Note: </span>ã¹ãã¼ãã»è¡¨ã»åã®ååã¯ããªãããããèå¥åã使ããªãéãã常ã«ã·ã¹ãã 表ã«ã¦å¤§æåã§è¨é²ããã¾ãã</div>
+
+<p><span>Derby</span>ã¯åã«å¯¾ãã¦æå¾ã«çºçªãããå¤ããã£ãã·ã¥ã«æ®ãã¦ãã¾ããã¾ãããã£ã¹ã¯ä¸ã§ã¯ã<em>SYS.SYSCOLUMNS</em>ã¨ããã·ã¹ãã 表ã®<em>AUTOINCREMENTVALUE</em>ã¨ããåã«ã次ã®å¤ãè¨é²ãã¦ãã¾ãã ãã©ã³ã¶ã¯ã·ã§ã³ããã¼ã«ããã¯ãã¦ããã®å¤ã¯åãæ¶ããã¾ããããããã£ã¦ããã©ã³ã¶ã¯ã·ã§ã³ããã¼ã«ããã¯ãããã¨ãèå¥ååã«æ¿å
¥ãããèªåçæå¤ã«ã¯ã空ããçºçãããã¨ã¨ã�
�ãã¾ãã
+<span>Derby</span> ã¯ãã®ããã«åä½ãããã¨ã§ã<em>SYS.SYSCOLUMNS</em>ã®è¡ããã©ã³ã¶ã¯ã·ã§ã³ã®æéä¸ããã¯ãç¶ãããã¨ãåé¿ãã¦ãé«ãå¹³è¡æ§ãä¿ã£ã¦ãã¾ãã</p>
+<p>ããªã¬ãããSQLæã«ã¦èå¥ååã«å¤ãæ¿å
¥ãããå ´åããã®SQLæã§æ¿å
¥ãããå¤ã¯ãããªã¬ã®ã³ã¼ãå
ã§ã®ã¿<em>ConnectionInfo</em>ããåå¾å¯è½ã§ãã
+ã¾ããããªã¬ã®ã³ã¼ãã¯ããªã¬ãã²ããæãæ¿å
¥ããå¤ãåå¾ãããã¨ãã§ãã¾ãã
+ããããããªã¬ãã²ããæã¯ãããªã¬ãããSQLæãèå¥ååã«æ¿å
¥ããå¤ãç¥ããã¨ãã§ãã¾ããã
+ããã«ããªã¬ã¯å
¥ãå(å帰)ã®å ´åãåããããªãã¨ã¨ãªãã¾ãã
+SQLæã«ããT1ã¨ããããªã¬ãçºç«ããã次ã«T1ã®å®è¡ããSQLã«ããT2ã¨ããããªã¬ãçºç«ãããã¨ãã¾ããããã§T1ãT2ã表ã«èå¥ååã«å¤ãããè¡ãæ¿å
¥ããå ´åãT1ã¯T2ãæ¿å
¥ããå¤ãè¦ããã¨ã¯ã§ãã¾ããããT2ã¯T1ãæ¿å
¥ããå¤ãè¦ããã¨ãã§ãã¾ããããããã®å
¥ãåã«ãªã£ãããªã¬ã¯èªåèªèº«ã¨ãå帰çãªããªã¬ãéå§ããSQLãå«ãã¦ãå
¥ãåã®ã¬ãã«ãåã®å¦çã«ã¦çæ
ãããå¤ãè¦ããã¨ãã§ãã¾ãã
+ãªãããªã¬ã®å帰ã¯16ã¾ã§å¯è½ã§ãã</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">ä¾</h4><pre>create table greetings
+ (i int generated by default as identity (START WITH 2, INCREMENT BY 1),
+ ch char(50));
+-- 1ãæå®ããã
+insert into greetings values (1, 'hi');
+-- çæãããæ¢å®å¤ã使ã
+insert into greetings values (DEFAULT, 'salut');
+-- çæãããæ¢å®å¤ã使ã
+insert into greetings(ch) values ('bonjour'); </pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="rrefsqlj24513.html" title="">CREATE TABLE æ</a></div>
+</div>
+<div class="relref"><strong>Related reference</strong><br />
+<div><a href="rrefsqlj30540.html" title="">åå®ç¾©</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj37836.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj38716.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj38716.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj38716.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,80 @@
+<!--
+ 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="COUNT é¢æ°" />
+<meta content="COUNT aggregate function, DISTINCT, qualifier in COUNT aggregate function" name="DC.subject" />
+<meta content="COUNT aggregate function, DISTINCT, qualifier in COUNT aggregate function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj38716" 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>COUNT é¢æ°</title>
+</head>
+<body id="rrefsqlj38716"><a name="rrefsqlj38716"><!-- --></a>
+
+
+<h1 class="topictitle1">COUNT é¢æ°</h1>
+
+
+<div>
+<div class="section"> <p>COUNTã¯å¼ã®è¡æ°ãæ°ããéç´é¢æ°ã§ãã(<a href="rrefsqlj33923.html#rrefsqlj33923">éç´ (éåé¢æ°)</a>ãåç
§ãã¦ãã ããã)
+COUNTã¯ã©ã®ãããªåã®å¼ã§ãå©ç¨ã§ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4><pre><strong>COUNT ( [ DISTINCT | ALL ] <em>å¼</em> ) </strong></pre>
+<p>DISTINCTã¨ããéå®è©ã«ããéè¤ãåãé¤ããã¨ãã§ãã¾ããALLã¨ããéå®è©ã«ããéè¤ããã®ã¾ã¾ã«ãããã¨ãã§ãã¾ããããDISTINCTãALLãæå®ãããªããã°ãALLãä¸ãããããã®ã¨ãã¾ããä¾ãã°ãåã«1ã1ã1ã1ããã³2ã¨ããå¤ããã£ãå ´åãCOUNT(col)ã¯COUNT(DISTINCT col)ãã大ããªæ°ãè¿ãã¾ãã</p>
+
+<p>ä¸ã¤ã®<em><a href="rrefselectexpression.html#rrefselectexpression">é¸æå¼</a></em>ã«ã¯ãå¯ä¸ã¤ã®DISTINCTéç´å¼ãã¨ããã¨ãã§ãã¾ããä¾ãã°æ¬¡ã®ããã«ååããäºã¯ã§ãã¾ããã</p>
+<pre><strong><span>-- åãåããã§ããªã</span>
+SELECT COUNT (DISTINCT flying_time), SUM (DISTINCT miles)
+FROM Flights</strong></pre>
+
+<p><em>å¼</em>ã«ã¯è¤æ°ã®åã¸ã®åç
§ãå¼ãç½®ãäºãã§ãã¾ãããä»ã®éç´ãå¯ååããç½®ããã¨ã¯ã§ãã¾ããã
+ãã<em>å¼</em>ãNULLã¨è©ä¾¡ãããå ´åããã®è©ä¾¡å¤ã«ã¤ãã¦éç´ã¯è¡ããã¾ããã</p>
+
+<p>COUNTã«ããçµæã®ãã¼ã¿åã¯ã<a href="rrefsqlj10696.html#rrefsqlj10696">INTEGER</a>ã§ãã</p>
+ </div>
+
+<div class="example"> <pre><strong><span>-- ããããã®å°åã®å½ã®æ°ãæ°ãã
+-- äºå½ä»¥ä¸ããå°åã表示ããã</span>
+SELECT COUNT (country), region
+FROM Countries
+GROUP BY region
+HAVING COUNT (country) > 1</strong></pre>
+ </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/rrefsqlj38716.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj38831.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj38831.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj38831.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,75 @@
+<!--
+ 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="SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICSã·ã¹ãã æç¶ã" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlbuiltinsystemprocedures.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj38831" 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>SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICSã·ã¹ãã æç¶ã</title>
+</head>
+<body id="rrefsqlj38831"><a name="rrefsqlj38831"><!-- --></a>
+
+
+<h1 class="topictitle1">SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICSã·ã¹ãã æç¶ã</h1>
+
+<div>
+<div class="section"><p><samp class="codeph">SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS()</samp>ã·ã¹ãã æç¶ãã«ãããæ¥ç¶ã«å¯¾ããå®è¡æçµ±è¨ã®onã¨offãåãæ¿ãããã¾ãã
+æ¢å®ã§ã¯å®è¡æçµ±è¨ã¯åä½ãã¦ãã¾ããã<samp class="codeph">runtimestatistics</samp>å±æ§ãonã«ããã¨ãå±æ§ãoffã«ãªãã¾ã§ã®éã<span>Derby</span>ã¯ãæ¥ç¶ã§å®è¡ãããcommit以å¤ã®åæã®å®è¡è¨ç»ã®æ
å ±ãããã¡ç¶ãã¾ãã
+<samp class="codeph">runtimestatistics</samp>å±æ§ãoffã«ããã«ã¯ãå¼æ°ã0ã§æç¶ããå¼ã³ã¾ãã
+<samp class="codeph">runtimestatistics</samp>å±æ§ãonã«ããã«ã¯ãå¼æ°ã0ã§ã¯ãªãä»»æã®æ°ã§æç¶ããå¼ã³ã¾ãã</p>
+</div>
+
+<div class="section">
+<p>è¡ãè¿ããªãæã«å¯¾ãã¦å®è¡è¨ç»ã®æ
å ±ãä½ãããã®ã¯ãã¯ã©ã¤ã¢ã³ãããã°ã©ã ã«å¦çãè¿ãåã®å
é¨å¦çãçµãã£ãæã§ããè¡ãè¿ãæã«å¯¾ãã¦ã¯ãåãã¦å¼ãã <samp class="codeph">next()</samp>ã0è¡è¿ããæããããã¯<samp class="codeph">close()</samp>ãå¼ã³åºãããæã®ãä½ããæ©ãã»ãã§ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre>SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(IN SMALLINT ENABLE)</pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">ä¾</h4>
+<pre>
+-- æ¥ç¶ãã¾ãã
+-- æ¥ç¶ã®RUNTIMESTATISTICãonã«ãã¾ãã
+<strong>CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);</strong>
+-- è¤éãªååããè¡ãã¾ãã
+-- çµæã»ããããªãã¾ãã
+-- å®è¡æçµ±è¨ã®æ
å ±ã«ã¢ã¯ã»ã¹ãã¾ãã
+<strong>CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(0);</strong></pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlbuiltinsystemprocedures.html" title="">çµã¿è¾¼ã¿ã·ã¹ãã æç¶ã</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj38831.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj40506.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj40506.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj40506.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,116 @@
+<!--
+ 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="LOCK TABLE æ" />
+<meta content="LOCK TABLE statement, LOCK TABLE, SQL statements, tables, locking, lock escalation, by user" name="DC.subject" />
+<meta content="LOCK TABLE statement, LOCK TABLE, SQL statements, tables, locking, lock escalation, by user" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj39374.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj40506" 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>LOCK TABLE æ</title>
+</head>
+<body id="rrefsqlj40506"><a name="rrefsqlj40506"><!-- --></a>
+
+
+<h1 class="topictitle1">LOCK TABLE æ</h1>
+
+
+<div>
+<div class="section">
+<p>LOCK TABLEæã«ããæ示çã«ã表ã«å
±æãããã¯æä»ã®ããã¯ãããããã¨ãã§ãã¾ãã
+表ã¸ã®ããã¯ã¯ç¾å¨ã®ãã©ã³ã¶ã¯ã·ã§ã³ãçµäºããã¾ã§ã®éãç¶ãã¾ãã</p>
+
+<p>表ãããã¯ã§ããã®ã¯ã<a href="rrefattrib26867.html#rrefattrib26867">ãã¼ã¿ãã¼ã¹ã®ææè
</a>ã¨è¡¨ã®ææè
ã§ãã</p>
+
+<div class="p">æ示çãªè¡¨ã¸ã®ããã¯ã¯æ¬¡ã®å ´åã«ä¾¿å©ã§ãã<ul>
+<li>表ã®è¤æ°è¡ã¸ã®ããã¯ã«ãããªã¼ãã¼ããããé¿ããæã(è¨ãæããã°ã¦ã¼ã¶èªããããã¯ã¨ã¹ã«ã¬ã¼ã·ã§ã³ãè¡ãæã)</li>
+
+<li>ãããããã¯ãé¿ããæ</li>
+
+</ul>
+</div>
+
+<p>ãã®æã§ã·ã¹ãã 表ã«ããã¯ãããããã¨ã¯ã§ãã¾ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>LOCK TABLE <em><a href="rreftablename.html#rreftablename">表å</a></em> IN { SHARE | EXCLUSIVE } MODE</strong></pre>
+
+<p>ãããã®ã¢ã¼ãã§ãã£ã¦ãããã©ã³ã¶ã¯ã·ã§ã³ã¯è¡¨ãããã¯ããå¾ããã以ä¸ã®è¡ãã¨ã®ããã¯ãå¾ããã¨ã¯ã§ãã¾ãããä¾ãã°ãæ
å ±ãèªãããã«ãã©ã³ã¶ã¯ã·ã§ã³ã<samp class="codeph">Flights</samp>ã¨ãã表ã®å
¨ä½ãå
±æã¢ã¼ãã§ããã¯ããå¾ãããæã«ã¦è¡ãæ´æ°ããããã«ç¹å®ã®è¡ã¸ã®æä»ããã¯ãå¿
è¦ã¨ããã¨ãã¾ããããããªãããæ¢ã«<samp class="codeph">Flights</samp>表ã¸ã®ããã¯ããããã
ãæä»ããã¯ã表æ¯ã¨ãªãå¿
è¦ãããã¾ãã</p>
+
+<p>ä»ã®æ¥ç¶ã表ã«å¯¾ãã¦æ¢ã«ããã¯ãããã¦ããããããã®è¡¨ã¸ã®ããã¯ãåå¾ã§ããªãå ´åããããããã¯ã®ã¿ã¤ã ã¢ã¦ãæéãçµéããå¾ãæã¸ã®ä¾å¤ãçºçãã¾ãã(<em>SQLState</em> X0X02)</p>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">ä¾</h4>
+<div class="p">è¡æ¯ã®ããã¯ãå¤éã«çºçãããã¨ãé¿ãããããå
±æã¢ã¼ãã§<samp class="codeph">Flights</samp>ã¨ãã表å
¨ä½ã¸ã®ããã¯ãè¡ãã«ã¯ä»¥ä¸ã®æã使ãã¾ãã
+<pre>LOCK TABLE Flights IN SHARE MODE;
+SELECT *
+FROM Flights
+WHERE orig_airport > 'OOO';
+</pre>
+</div>
+
+<div class="p">è¤æ°ã®UPDATEæãçºè¡ãããã©ã³ã¶ã¯ã·ã§ã³ãä¸ã¤ããã¨ãã¾ãã
+åã
ã®æã¯ããããªè¡æ¯ã®ããã¯ããå¿
è¦ã¨ããªãã®ã§ããã©ã³ã¶ã¯ã·ã§ã³ã¯ããã¯ã表æ¯ã«å¤æ´ãã¾ããããããUPDATEæã®æ°ãå¤ãã®ã§ãåå¾ã¨éæ¾ãè¡ãããããã¯ã®å»¶ã¹æ°ã¯å¤ããªãããããããã¯ã«ãªãããã¾ããã
+ãã®ãããªãã©ã³ã¶ã¯ã·ã§ã³ã§ã¯ãæåã«æä»ã¢ã¼ãã§è¡¨ãããã¯ãã¾ãã
+ä¾ã以ä¸ã«ç¤ºãã¾ãã<pre>LOCK TABLE FlightAvailability IN EXCLUSIVE MODE;
+UPDATE FlightAvailability
+SET economy_seats_taken = (economy_seats_taken + 2)
+WHERE flight_id = 'AA1265' AND flight_date = DATE('2004-03-31');
+
+UPDATE FlightAvailability
+SET economy_seats_taken = (economy_seats_taken + 2)
+WHERE flight_id = 'AA1265' AND flight_date = DATE('2004-04-11');
+
+UPDATE FlightAvailability
+SET economy_seats_taken = (economy_seats_taken + 2)
+WHERE flight_id = 'AA1265' AND flight_date = DATE('2004-04-12');
+
+UPDATE FlightAvailability
+SET economy_seats_taken = (economy_seats_taken + 2)
+WHERE flight_id = 'AA1265' AND flight_date = DATE('2004-04-15');
+</pre>
+</div>
+
+<div class="p">ãã©ã³ã¶ã¯ã·ã§ã³ã表ãæ´æ°ããåã«ããã®è¡¨ãã¿ãå¿
è¦ãããå ´åããããããã¯ãé¿ããããã表ã«æä»ããã¯ãããã¾ãã
+ä¾:<pre>LOCK TABLE Maps IN EXCLUSIVE MODE;
+SELECT MAX(map_id) + 1 FROM Maps;
+-- INSERT INTO Maps . . .</pre>
+</div>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj39374.html" title="">æ</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj40506.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj40774.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj40774.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj40774.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,117 @@
+<!--
+ 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="INSERT æ" />
+<meta content="INSERT statement" name="DC.subject" />
+<meta content="INSERT statement" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj39374.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj40774" 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>INSERT æ</title>
+</head>
+<body id="rrefsqlj40774"><a name="rrefsqlj40774"><!-- --></a>
+
+
+<h1 class="topictitle1">INSERT æ</h1>
+
+
+<div>
+<div class="section"> <p>
+INSERTæã«ããä¸ã¤ä»¥ä¸ã®è¡ãä½æãã¦ãæå®ããååã®è¡¨ã«æ ¼ç´ã§ãã¾ãã
+INSERTæã§æå®ãããå¤ã®æ°ã¯ãæå®ãããåãããã¯æ示ãããåã®æ°ã¨åãã§ãªããã°ãªãã¾ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>INSERT INTO 表å
+ [ (<em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">åç´åå</a></em> [ , <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">åç´åå</a></em>]* ) ]
+ ååã</strong></pre>
+ <div class="p"><em>ååãã«ã¯</em>以ä¸ã®ãããããã¨ããã¨ãã§ãã¾ãã
+<ul>
+<li><em><a href="rrefselectexpression.html#rrefselectexpression">é¸æå¼</a></em></li>
+
+<li>VALUESä¸è¦§</li>
+
+<li>è¤æ°è¡VALUESå¼<p>åä¸è¡ãããã¯è¤æ°è¡ã®ä¸è¦§ã«ã¯ãDEFAULTã¨ãããã¼ã¯ã¼ããå«ãããã¨ãã§ãã¾ããåã«DEFAULTãæå®ããã¨ããã®åã«ã¯æ¢å®å¤ãæ¿å
¥ããã¾ããåã«æ¢å®å¤ãæ¿å
¥ããå ´åãåã®ä¸è¦§ã«ã¦ãã®åãçç¥ãã¦ã表ã®ã»ãã®åã«å¤ãæ¿å
¥ãããã¨ãã§ãã¾ãã詳細ã«ã¤ãã¦ã¯<a href="rrefsqlj11277.html#rrefsqlj11277">VALUESå¼</a>ãåç
§ãã¦ãã ããã</p>
+</li>
+
+<li>UNIONå¼</li>
+
+</ul>
+</div>
+ <p>ååãã®è©³ç´°ã«ã¤ãã¦ã¯ã<a href="rrefsqlj21571.html#rrefsqlj21571">ååã</a>ãåç
§ãã¦ãã ããã</p>
+ </div>
+
+<div class="example"> <pre><strong>INSERT INTO COUNTRIES
+ VALUES ('Taiwan', 'TW', 'Asia')
+
+-- DEPARTMENTã¨ãã表ã«æ°ããé¨ç½²ãæ¿å
¥ãã¾ãã
+-- ãã ããæ°ããé¨ç½²ã«æ°ãã管çè
ã¯å²ãå½ã¦ã¾ããã
+INSERT INTO DEPARTMENT (DEPTNO, DEPTNAME, ADMRDEPT)
+ VALUES ('E31', 'ARCHITECTURE', 'E01')
+<span>-- 2ã¤ã®æ°ããé¨ç½²ãä¸ã¤ã®æã§åã¨åãããã«DEPARTMENTã¨ãã表ã«æ¿å
¥ãã¾ãã
+-- ãã ããæ°ããé¨ç½²ã«æ°ãã管çè
ã¯å²ãå½ã¦ã¾ããã</span>
+INSERT INTO DEPARTMENT (DEPTNO, DEPTNAME, ADMRDEPT)
+ VALUES ('B11', 'PURCHASING', 'B01'),
+ ('E41', 'DATABASE ADMINISTRATION', 'E01')
+<span>-- EMP_ACTã¨åãåãæã¤ãMA_EMP_ACTã¨ãã
+-- ä¸æ表ãä½ãã¾ãã
+-- MA_EMP_ACTã«EMP_ACTã¨ãã表ããã
+-- ããã¸ã§ã¯ãçªå·(PROJNO)ã'MA'ã¨ããæåã§å§ã¾ãè¡ããã¼ããã¾ãã</span>
+CREATE TABLE MA_EMP_ACT
+ (
+ EMPNO CHAR(6) NOT NULL,
+ PROJNO CHAR(6) NOT NULL,
+ ACTNO SMALLINT NOT NULL,
+ EMPTIME DEC(5,2),
+ EMSTDATE DATE,
+ EMENDATE DATE
+ );
+
+INSERT INTO MA_EMP_ACT
+ SELECT * FROM EMP_ACT
+ WHERE SUBSTR(PROJNO, 1, 2) = 'MA';
+<span>-- LOCATIONã¨ããåã«DEFAULTã®å¤ãæ¿å
¥ãã¾ãã</span>
+INSERT INTO DEPARTMENT
+ VALUES ('E31', 'ARCHITECTURE', '00390', 'E01', DEFAULT)
+</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">æã®ä¾å</h4>
+<p>INSERT æã¯æ¿å
¥å
ã®è¡¨ãããã®è¡¨ã®å
¨ã¦ã®ã³ã³ã°ãããªãã(ãã¼ããç´¢å¼ãªã©ã®è¨é²ã®åä½ã§ãã)ããæä¸ã®ãã®ä»ã®è¡¨ã«ä¾åãã¾ããæºåãããINSERTæã®å¯¾è±¡è¡¨ã«ã¦ãç´¢å¼ãå¶ç´ãä½æãããç ´æ£ãããããã¨ããã®æºåãããINSERTæã¯ç¡å¹ã¨ãªãã¾ãã</p>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj39374.html" title="">æ</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj40774.html
------------------------------------------------------------------------------
svn:eol-style = native