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 [34/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/rrefsqlj24513.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj24513.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj24513.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,162 @@
+<!--
+ 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="CREATE TABLE æ" />
+<meta content="CREATE TABLE statement, CREATE TABLE, SQL statements, tables, creating" name="DC.subject" />
+<meta content="CREATE TABLE statement, CREATE TABLE, SQL statements, tables, creating" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj95081.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefcreatefunctionstatement.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj20937.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefcreateprocedurestatement.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj31580.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljcreatesynonym.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj43125.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj15446.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj30540.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj37836.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj24513" 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>CREATE TABLE æ</title>
+</head>
+<body id="rrefsqlj24513"><a name="rrefsqlj24513"><!-- --></a>
+
+
+<h1 class="topictitle1">CREATE TABLE æ</h1>
+
+
+<div>
+<div class="section"> <p>CREATE TABLEæã«ãã表ãä½æãã¾ãã表ã«ã¯åããã³å¶ç´ããã£ã¦ãæ
å ±ã沿ãã¹ãè¦åã決ãããã¦ãã¾ãã表ãã¨ã®å¶ç´ã¯åã®éåãªããã¯åãæå®ãã¾ããåã«ã¯ãã¼ã¿åã決ã¾ã£ã¦ãã¦ãåã®å¶ç´(åãã¨ã®å¶ç´)ãããã¾ãã</p>
+
+<div class="p">表ã<a href="rrefattrib26867.html#rrefattrib26867">ãã¼ã¿ãã¼ã¹ã®ææè
</a>ã¯èªåçã«ä»¥ä¸ã®æ¨©éãæã¡ãã¾ãä»ã®ã¦ã¼ã¶ã«ãããã®æ¨©éãä¸ããäºãã§ãã¾ãã<ul>
+<li>INSERT</li>
+
+<li>SELECT</li>
+
+<li>REFERENCES</li>
+
+<li>TRIGGER</li>
+
+<li>UPDATE</li>
+
+</ul>
+ãããã®æ¨©éã表ããã¼ã¿ãã¼ã¹ã®ææè
ããå¥å¥ªãããã¨ã¯ã§ãã¾ããã</div>
+
+<p>å¶ç´ã«ã¤ãã¦ã®æ
å ±ã¯ã<a href="rrefsqlj13590.html#rrefsqlj13590">CONSTRAINT ç¯</a>ãåç
§ãã¦ãã ããã</p>
+
+<p>åã«ã¯æ¢å®å¤ãä¸ãããã¨ãã§ãã¾ããæ¢å®å¤ã¨ã¯å¤ãæå®ãããªãã£ãã¨ããåã«æ¿å
¥ãããå¤ã§ããæ示ãããªãå ´ååã®æ¢å®å¤ã¯NULLã§ãã詳細ã¯<a href="rrefsqlj30540.html#rrefsqlj30540__sqlj64478">åã®æ¢å®å¤</a>ãåç
§ãã¦ãã ããã</p>
+
+<p><samp class="codeph">SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY</samp>ã¨ããã·ã¹ãã ã®æç¶ãå¼ã¶ãã¨ã§ããã¼ã¸ãµã¤ãºã®ãããªè¨é²ã®å±æ§ãè¨å®ãããã¨ãã§ãã¾ãã</p>
+
+<p>表ãéå®ããå ´åãã¹ãã¼ãåã¯<em>SYS</em>ã§å§ã¾ã£ã¦ã¯ãªãã¾ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4>
+ <p>CREATE TABLEã«ã¯äºéãã®æ¸ãæ¹ãããã¾ããããã¯ãåã®å®ç¾©ã¨å¶ç´ãæå®ãããã¨ããããåãåããå¼ã®çµæã«åºã¥ãåãå®ç¾©ãããã«ããã¾ãã</p>
+
+<pre><strong>CREATE TABLE <em><a href="rreftablename.html#rreftablename">表å</a></em></strong>
+ ( {<em><a href="rrefsqlj30540.html#rrefsqlj30540">åå®ç¾©</a></em> | <em><a href="rrefsqlj42154.html#rrefsqlj42154">表æ¯å¶ç´</a></em>}
+ [ , {<em><a href="rrefsqlj30540.html#rrefsqlj30540">åå®ç¾©</a></em> | <em><a href="rrefsqlj42154.html#rrefsqlj42154">表æ¯å¶ç´</a></em>} ] * )
+ |
+ [ ( <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">åå</a></em> [ , <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">åå</a></em> ] * ) ]
+ <strong>AS</strong> <em>åãåããå¼</em>
+ <strong>WITH NO DATA</strong>
+ }
+
+</pre>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">ä¾</h4><pre><strong>CREATE TABLE HOTELAVAILABILITY
+ (HOTEL_ID INT NOT NULL, BOOKING_DATE DATE NOT NULL,
+ ROOMS_TAKEN INT DEFAULT 0, PRIMARY KEY (HOTEL_ID, BOOKING_DATE));
+<span>-- 表ã§ä¸»ãã¼ãå®ç¾©ãããã¨ã§ã2åãããªã主ãã¼ãå®ç¾©ã§ãã¾ãã</span>
+PRIMARY KEY (hotel_id, booking_date))
+<span>-- èå¥ååã®å±æ§ããINTEGERã®åã«ä¸ãã
+-- ããã«åã«ä¸»ãã¼å¶ç´ãå®ç¾©ãã¾ãã</span>
+CREATE TABLE PEOPLE
+ (PERSON_ID INT NOT NULL GENERATED ALWAYS AS IDENTITY
+ CONSTRAINT PEOPLE_PK PRIMARY KEY, PERSON VARCHAR(26));
+<span>-- èå¥ååã®å±æ§ããSMALLINTã®åã«ä¸ãã
+-- åæå¤ã5ã«å¢åå¤ã5ã«è¨å®ãã¾ãã</span>
+CREATE TABLE GROUPS
+ (GROUP_ID SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY
+ (START WITH 5, INCREMENT BY 5), ADDRESS VARCHAR(100), PHONE VARCHAR(15));</strong></pre>
+<div class="note"><span class="notetitle">注: </span>ãã¾ãã¾ãªå¶ç´ã使ã£ããããå¤ãã®CREATE TABLEæã®ä¾ã<a href="rrefsqlj13590.html#rrefsqlj13590">CONSTRAINT ç¯</a>ã«ããã¾ãã</div>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">CREATE TABLE ... AS ... </h4>
+ <p>ããä¸ã¤ã®CREATE TABLEæã®æ¸ãæ¹ã¯ãåãåããã§åã®ååã¨/ãããã¯åã®ãã¼ã¿åãæå®ãã¾ããåãåããçµæã®åã¯ãæ°ãã表ã®ååãä½æããã¨ãã«ã¢ãã«ã¨ãã¦å©ç¨ããã¾ãã</p>
+
+<p>æ°ãã表ã«ååãæå®ãããªãã£ãå ´åãåãåããã®çµæã®å
¨åããæ°ãã表ã«åãååã¨å¯¾å¿ãããã¼ã¿åã§ä½æããã¾ãã
+ã²ã¨ã¤ãããã¯ãã以ä¸ã®åã®ååãæ°ãã表ã«æå®ãããå ´åãåãåããå¼ã®çµæã«ã¯åæ°ã®åãç¡ããã°ãªãã¾ãããåãåããçµæã®åã®ãã¼ã¿åã¯æ°ãã表ã®å¯¾å¿ããåã«å¼ãç¶ããã¾ãã</p>
+
+<p>WITH NO DATAç¯ã¯åãåããçµæè¡ã®ãã¼ã¿ã¯ä½¿ããããåã®å称ã¨åã ããå©ç¨ããããã¨ã表ãã¾ãã
+WITH NO DATAã¯<strong>å¿
ã</strong>æå®ãã¦ãã ãããä»å¾ã®ãªãªã¼ã¹ã«ã¦ãDerbyã§ãWITH DATAãæå®ãã¦ãåãåããå¼ã®çµæãæ°è¦ä½æããã表ã«æ¿å
¥ããããã«åºæ¥ãããã«ãªãããããã¾ããããããç¾å¨ã®ãªãªã¼ã¹ã§ã¯ãWITH NO DATAã®æããå¦çããã¾ããã</p>
+
+</div>
+
+<div class="example"><h4 class="sectiontitle">ä¾</h4>
+ <pre><strong>
+<span>-- æ¢åã®è¡¨ã®å
¨åã¨ãã¼ã¿åã使ã£ã¦æ°ãã表ãä½æããã</span>
+CREATE TABLE T3 AS SELECT * FROM T1 WITH NO DATA;
+<span>-- åã«ååãæå®ãã¦è¡¨ãä½æããããã®ãã¼ã¿åã¯æ¢å表ã®åã«æ²¿ã£ããã®ã¨ããã</span>
+CREATE TABLE T3 (A,B,C,D,E) AS SELECT * FROM T1 WITH NO DATA;
+<span>-- åã«ååãæå®ãã¦è¡¨ãä½æããããã®ãã¼ã¿åã¯æ¢å表ã®æå®ãããåã®ãã¼ã¿åã«æ²¿ã£ããã®ã¨ããã</span>
+CREATE TABLE T3 (A,B,C) AS SELECT V,DP,I FROM T1 WITH NO DATA;
+<span>-- ãã®ä¾ã§ã¯åãåããå¼ã®çµæã«ããåã«ååããªããããã®ãã¼ã¿åã¯æ°è¦ä½æããã表ã«ã¦å¯¾å¿ããåã®ãã¼ã¿åã¨ãªãã</span>
+CREATE TABLE T3 (X,Y) AS SELECT 2*I,2.0*F FROM T1 WITH NO DATA;
+</strong></pre>
+
+</div>
+
+</div>
+
+<div>
+<ul class="ullinks">
+<li class="ulchildlink"><strong><a href="rrefsqlj30540.html">åå®ç¾©</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj37836.html">çºçªåä»æ§</a></strong><br />
+</li>
+</ul>
+
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj95081.html" title="">CREATE æ</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefcreatefunctionstatement.html" title="CREATE FUNCTIONæã«ãããå¼ã§å©ç¨ã§ããJavaé¢æ°ãä½æã§ãã¾ãã">CREATE FUNCTION æ</a></div>
+<div><a href="rrefsqlj20937.html" title="">CREATE INDEX æ</a></div>
+<div><a href="rrefcreateprocedurestatement.html" title="">CREATE PROCEDURE æ</a></div>
+<div><a href="rrefsqlj31580.html" title="">CREATE SCHEMA æ</a></div>
+<div><a href="rrefsqljcreatesynonym.html" title="">CREATE SYNONYM æ</a></div>
+<div><a href="rrefsqlj43125.html" title="">CREATE TRIGGER æ</a></div>
+<div><a href="rrefsqlj15446.html" title="">CREATE VIEW æ</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj24513.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj25228.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj25228.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj25228.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="SESSION_USERé¢æ°" />
+<meta content="SESSION_USER function" name="DC.subject" />
+<meta content="SESSION_USER function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj25228" 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>SESSION_USERé¢æ°</title>
+</head>
+<body id="rrefsqlj25228"><a name="rrefsqlj25228"><!-- --></a>
+
+
+<h1 class="topictitle1">SESSION_USERé¢æ°</h1>
+
+
+<div>
+<div class="section"> <p>SESSION_USERã¯ãç¾å¨ã®ã¦ã¼ã¶ã®èªè¨¼èå¥åãããã¯ååãè¿ãã¾ãã
+ç¾å¨ã®ã¦ã¼ã¶ããªãå ´åã¯ã<em>APP</em>ãè¿ãã¾ãã</p>
+
+<p><a href="rrefsqlj42476.html#rrefsqlj42476">USER</a>ã<a href="rrefsqlj42324.html#rrefsqlj42324">CURRENT_USER</a>ã
+SESSION_USER ã¯äºãã«å¥åã§ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>SESSION_USER</strong></pre>
+ </div>
+
+<div class="example"> <pre><strong>VALUES SESSION_USER</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/rrefsqlj25228.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj26498.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj26498.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj26498.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,115 @@
+<!--
+ 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="UPDATEæ" />
+<meta content="UPDATE statement" name="DC.subject" />
+<meta content="UPDATE statement" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj39374.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj26498" 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>UPDATEæ</title>
+</head>
+<body id="rrefsqlj26498"><a name="rrefsqlj26498"><!-- --></a>
+
+
+<h1 class="topictitle1">UPDATEæ</h1>
+
+
+<div>
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>{
+ UPDATE <em><a href="rreftablename.html#rreftablename">表å</a></em>
+ SET <em><a href="rrefcolumnname.html#rrefcolumnname">åå</a></em> = <em>å¤</em>
+ [ , <em><a href="rrefcolumnname.html#rrefcolumnname">åå</a></em> = <em>å¤</em>} ]*
+ [<em><a href="rrefsqlj33602.html#rrefsqlj33602">WHEREç¯</a></em>] |
+ UPDATE <em><a href="rreftablename.html#rreftablename">表å</a></em>
+ SET <em><a href="rrefcolumnname.html#rrefcolumnname">åå</a></em> = <em>å¤</em>
+ [ , <em><a href="rrefcolumnname.html#rrefcolumnname">åå</a></em> = <em>å¤</em> ]*
+ <em><a href="rrefsqlj15309.html#rrefsqlj15309">WHERE CURRENT OF</a></em>
+}</strong></pre>
+
+<p><var class="varname">å¤</var>ã®å®ç¾©ã¯ä»¥ä¸ã®éãã§ãã</p>
+
+<pre><strong><em>å¼</em> | DEFAULT</strong></pre>
+
+<p>ä¸ã¤ç®ã®æ¸ãæ¹ã¯æ¤ç´¢ã«ããæ´æ°ã¨ãããWHEREç¯ãçã«è©ä¾¡ãããå
¨è¡ã®ä¸ã¤ä»¥ä¸ã®åãæ´æ°ãã¾ãã</p>
+
+<p>äºã¤ç®ã®æ¸ãæ¹ã¯ä½ç½®ã«ããæ´æ°ã¨ãããæ´æ°å¯è½ãªéããã«ã¼ã½ã«ã®ç¾å¨è¡ã®ä¸ã¤ä»¥ä¸ã®åãæ´æ°ãã¾ããã«ã¼ã½ã«ãä½æããSELECTæã®<a href="rrefsqlj31783.html#rrefsqlj31783">FOR UPDATE ç¯</a>ã«ã¦åãæ示ãããå ´åããã®åã ããæ´æ°å¯è½ã§ããããåãæ示ããã¦ããªããSELECTæã«FOR UPDATEç¯ãç¡ãã£ãå ´åã¯ãå
¨ã¦ã®åãæ´æ°ã§ãã¾ãã</p>
+
+<p>æ´æ°å¾ã®å¤ã«DEFAULTãæå®ããã¨ã表ã«ã¦å®ç¾©ãããæ¢å®å¤ã«åã®å¤ãè¨å®ããã¾ãã</p>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">ä¾</h4> <pre><strong>
+<span>
+-- 'E21'ã®é¨ç½²(WORKDEPT)ã«ã¦ç®¡çè
以å¤ãä¸æçã«åé
å±ããã¦ããã
+-- ãã®ãã¨ããEMPLOYEEã¨ãã表ã®å½¼ãã®ä»äº(JOB)ãNULLã«ã
+-- å½¼ãã¸ã®æ¯æã(SALARY, BONUS, COMM)ã0ã«ãã¦ããããã</span>
+UPDATE EMPLOYEE
+ SET JOB=NULL, SALARY=0, BONUS=0, COMM=0
+ WHERE WORKDEPT = 'E21' AND JOB <> 'MANAGER'
+
+-- ç¹å®ã®è©æ¸ããæããªã社å¡ã管çè
ã«ææ ¼ããã
+UPDATE EMPLOYEE
+ SET JOB = 'MANAGER'
+ WHERE JOB IS NULL;
+<span>// å
¨ã¦ã®ããã¸ã§ã¯ãã®äººå¡é
ç½®(PRSTAFF)ã1.5å¢ããã</span>
+stmt.executeUpdate("UPDATE PROJECT SET PRSTAFF = "
+"PRSTAFF + 1.5" +
+"WHERE CURRENT OF" + ResultSet.getCursorName());
+
+<span>-- EMPLOYEEã¨ãã表ã«ã¦ç¤¾å¡çªå·(EMPNO)ã'000290'ã®ç¤¾å¡ã®ä»äº(JOB)ãã
+-- æ¢å®å¤ã§ããNULLã«æ´æ°ããã</span>
+UPDATE EMPLOYEE
+ SET JOB = DEFAULT
+ WHERE EMPNO = '000290'
+</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">æã®ä¾å</h4> <p>æ¤ç´¢ã«ããæ´æ°ã®æã¯ãæ´æ°ãããã¨ãã¦ãã表ãããã®ã³ã³ã°ãããªãã(ãã¼ããç´¢å¼ãªã©ã®è¨é²åä½)ããã®å¶ç´ãWHEREç¯ãSETå¼ã«æ¸ããã表ã«ä¾åãã¾ããæ¤ç´¢ã«ããæ´æ°ã®æºåãããæã®å¯¾è±¡è¡¨ã«CREATE INDEXãDROP INDEXæãALTER TABLEæãå®è¡ãããã¨ããã®æã¯ç¡å¹ã¨ãªãã¾ãã</p>
+
+<p>ä½ç½®ã«ããæ´æ°ã®æã¯ã«ã¼ã½ã«ãã«ã¼ã½ã«ãåç
§ããå
¨ã¦ã®è¡¨ã«ä¾åãã¾ããã«ã¼ã½ã«ãã¾ã éãã¦ããªãã¨ããä½ç½®ã«ããæ´æ°ã®æãã³ã³ãã¤ã«ãããã¨ãã§ãã¾ããããããªããJDBCã®<em>close</em>ã¡ã½ããã«ããéããã«ã¼ã½ã«ããªããã¨ãä½ç½®ã«ããæ´æ°ã®æã¯ç¡å¹ã¨ãªãã¾ãã</p>
+
+<p>
+ä½ç½®ã«ããæ´æ°ã®æºåãããæã®å¯¾è±¡è¡¨ã«ãCREATE INDEXãDROP INDEXæãALTER TABLEæãå®è¡ãããã¨ããã®æã¯ç¡å¹ã¨ãªãã¾ãã
+</p>
+
+<p>å¥åãç ´æ£ããã¨ããã®å¥åã使ã£ã¦ããæ´æ°ã®æºåãããæã¯ç¡å¹ã«ãªãã¾ãã</p>
+
+<p>æ´æ°ã®å¯¾è±¡è¡¨ã«ã¦ããªã¬ã®ç ´æ£ãä½æãè¡ãããã¨ãæ´æ°ã®æã¯ç¡å¹ã«ãªãã¾ãã</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/rrefsqlj26498.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj27281.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj27281.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj27281.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,72 @@
+<!--
+ 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="FLOATãã¼ã¿å" />
+<meta content="FLOAT data type, as alias for REAL or DOUBLE PRECISION" name="DC.subject" />
+<meta content="FLOAT data type, as alias for REAL or DOUBLE PRECISION" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj27281" 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>FLOATãã¼ã¿å</title>
+</head>
+<body id="rrefsqlj27281"><a name="rrefsqlj27281"><!-- --></a>
+
+
+<h1 class="topictitle1">FLOATãã¼ã¿å</h1>
+
+
+<div>
+<div class="section"> <p>FLOATã¯ãæå®ãã精度ã«ããREALãããã¯DOUBLE PRECISIONã®å¥åã¨ãªãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>FLOAT [ (<em>精度</em>) ]</strong></pre>
+ <p>æ¢å®ã®<em>精度</em>ã¯53ã§ãããã¯DOUBLE PRECISIONã¨åçã§ãã
+精度ã23以ä¸ã§ããå ´åãFLOATã¯REALã¨åçã«ãªãã¾ãã精度ã24以ä¸ã§ããå ´åãFLOATã¯DOUBLE PRECISIONã¨åçã¨ãªãã¾ãããã精度ã«0ãæå®ããã¨ãã¨ã©ã¼ã¨ãªãã¾ããããè² ã®ç²¾åº¦ãæå®ããã¨ãæ§æã¨ã©ã¼ã¨ãªãã¾ãã</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBC ã®ã¡ã¿ãã¼ã¿å (java.sql.Types)</h4> <p>REAL
+or DOUBLE</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">å¶é</h4>
+<p>ãã24以ä¸ã®ç²¾åº¦ãæå®ããå ´åãFLOATã«ã¯DOUBLEã¨åãå¶éããããã¾ãã</p>
+
+<p>ãã23以ä¸ã®ç²¾åº¦ãæå®ããå ´åãFLOATã«ã¯REALã¨åãå¶éããããã¾ãã</p>
+ </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/rrefsqlj27281.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj27620.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj27620.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj27620.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,82 @@
+<!--
+ 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="TIMESTAMPãã¼ã¿å" />
+<meta content="TIMESTAMP data type" name="DC.subject" />
+<meta content="TIMESTAMP data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj27620" 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>TIMESTAMPãã¼ã¿å</title>
+</head>
+<body id="rrefsqlj27620"><a name="rrefsqlj27620"><!-- --></a>
+
+
+<h1 class="topictitle1">TIMESTAMPãã¼ã¿å</h1>
+
+
+<div>
+<div class="section"> <p>TIMESTAMPã§ã¯æ¥ä»ã¨æå»ãçµåãããå¤ãè¨é²ããã¾ããã¾ãç§ã®å°æ°ç¹ä»¥ä¸ã9æ¡ã®å¤ãè¨é²ããã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4><pre><strong>TIMESTAMP</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">対å¿ããã³ã³ãã¤ã«æã®Javaã®å</h4><p><em>java.sql.Timestamp</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBC ã¡ã¿ãã¼ã¿å (java.sql.Types)</h4><p>TIMESTAMP</p>
+
+<p>æ¥ä»ãæå»ãã¿ã¤ã ã¹ã¿ã³ãã¯ãä¸ã¤ã®å¼ã§æ··å¨ãã¦ä½¿ãã¾ããã</p>
+
+<div class="p"><span>Derby</span>ã§ã¯TIMESTAMPã以ä¸ã®æ¸å¼ã§æ¸ãã¾ãã<pre>yyyy-mm-dd hh:mm:ss[.nnnnnn]
+yyyy-mm-dd-hh.mm.ss[.nnnnnn]</pre>
+
+ä¸è¨ã®äºã¤ã®æ¸å¼ã®ãã¡ãæåã®ä¸ã¤ã¯<em>java.sql.Timestamp</em>ã®æ¸å¼ã§ãã</div>
+
+<p>å¹´ã¯å¸¸ã«4æåã®æ°åã§è¡¨ãããªããã°ãªãã¾ãããæãæ¥ãæã¯1æåãããã¯2æåã®æ°åã¨ãããã¨ãã§ãã¾ããåãç§ã¯2æåã®æ°åã§è¡¨ãããªããã°ãªãã¾ãããããã»ã«ã³ããæ¸ãããå ´åã1æåãã6æåã®æ°åã§è¡¨ããã¾ãã</p>
+
+<p><span>Derby</span> ã¯ãã¼ã¿ãã¼ã¹ãµã¼ãã®ãã±ã¼ã«ã«åºæã®æ¥ææ¸å¼ã§æ¸ãããæååãåãä»ãã¾ããããé©ç¨ããã¹ãæ¸å¼ãææ§ã§ããå ´åãå
ã«è¿°ã¹ãçµè¾¼ã¿ã®æ¸å¼ãåªå
ããã¾ãã</p>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">ä¾</h4> <pre><strong>VALUES '1960-01-01 23:03:20'
+VALUES TIMESTAMP('1962-09-23 03:23:34.234')
+VALUES TIMESTAMP('1960-01-01 23:03:20')</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/rrefsqlj27620.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj27767.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj27767.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj27767.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,136 @@
+<!--
+ 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="crefsqlj41507.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj28138.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj20204.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj36146.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj27767" 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="rrefsqlj27767"><a name="rrefsqlj27767"><!-- --></a>
+
+
+<h1 class="topictitle1">å¼ã«ã¦è¡ãããæ°å¤åã®é
ç®</h1>
+
+<div>
+<div class="section"><div class="p">å¼ã«ã¦æ´æ°åã使ãããã¨ã<span>Derby</span>ã¯çµæã®åãå°ãªãã¨ãINTEGERã«ã¾ã§ææ ¼ãã¾ããå¼ã«ã¦æ´æ°åã¨éæ´æ°åãæ··å¨ãã¦ä½¿ãããã¨ã<span>Derby</span>ã¯å¼ã®çµæãå¼ä¸ã®æãé«ãåã«ææ ¼ãã¾ãã<a href="#rrefsqlj27767__sqlj39640">å¼ã«ã¦è¡ãããåã®ææ ¼</a>ã«ã¦ãå¼ä¸ã®ãã¼ã¿åã®ææ ¼ã説æãã¾ãã
+
+
+<div class="tablenoborder"><a name="rrefsqlj27767__sqlj39640"><!-- --></a><table summary="" cellspacing="0" cellpadding="4" id="rrefsqlj27767__sqlj39640" frame="border" border="1" rules="all"><caption>表 1. å¼ã«ã¦è¡ãããåã®ææ ¼</caption>
+
+<thead align="left">
+<tr>
+<th align="left" valign="bottom" width="62%" id="N10062">å¼ã«ãããæã大ããªå</th>
+
+<th align="left" valign="bottom" width="38%" id="N1006B">å¼ã®çµæå</th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" width="62%" headers="N10062 ">DOUBLE PRECISION</td>
+
+<td valign="top" width="38%" headers="N1006B ">DOUBLE PRECISION</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="62%" headers="N10062 ">REAL</td>
+
+<td valign="top" width="38%" headers="N1006B ">DOUBLE PRECISION</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="62%" headers="N10062 ">DECIMAL</td>
+
+<td valign="top" width="38%" headers="N1006B ">DECIMAL</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="62%" headers="N10062 ">BIGINT</td>
+
+<td valign="top" width="38%" headers="N1006B ">BIGINT</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="62%" headers="N10062 ">INTEGER</td>
+
+<td valign="top" width="38%" headers="N1006B ">INTEGER</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="62%" headers="N10062 ">SMALLINT</td>
+
+<td valign="top" width="38%" headers="N1006B ">INTEGER</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+</div>
+
+<div class="section"><div class="p">ä¾:
+<pre><strong><span>-- å精度浮åå°æ°ç¹æ°ãè¿ãã¾ãã</span>
+VALUES 1 + 1.0e0
+<span>-- å°æ°ã®æ°ãè¿ãã¾ãã</span>
+VALUES 1 + 1.0
+<span>-- æ´æ°ãè¿ãã¾ãã</span>
+VALUES CAST (1 AS INT) + CAST (1 AS INT)</strong></pre>
+</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="rrefsqlj20204.html" title="">æ°å¤ãç°ãªãæ°å¤åã®åã«è¨é²ãã</a></div>
+<div><a href="rrefsqlj36146.html" title="">å°æ°ãè¨ç®ããã¨ãã®ç®çã</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj27767.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj27781.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj27781.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj27781.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,90 @@
+<!--
+ 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="MAXé¢æ°" />
+<meta content="MAX aggregate function" name="DC.subject" />
+<meta content="MAX aggregate function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj27781" 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>MAXé¢æ°</title>
+</head>
+<body id="rrefsqlj27781"><a name="rrefsqlj27781"><!-- --></a>
+
+
+<h1 class="topictitle1">MAXé¢æ°</h1>
+
+
+<div>
+<div class="section"> <p>MAXã¯è¡ã®éåããæ大ã®å¤ãæ±ããéç´é¢æ°ã§ãã(<a href="rrefsqlj33923.html#rrefsqlj33923">éç´ (éåé¢æ°)</a>ãåç
§ãã¦ãã ããã)
+MAXã¯çµã¿è¾¼ã¾ãããã¼ã¿åã®å¼ã«å¯¾ãã¦ã®ã¿é©ç¨ãããã¨ãã§ãã¾ãã
+(CHARãVARCHARãDATEãTIMEãCHAR FOR BIT DATAçãå«ã¿ã¾ãã)</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>MAX ( [ DISTINCT | ALL ] <em>å¼</em> )</strong></pre>
+ <div class="p">DISTINCTãALLã¨ããéå®è©ã«ãããéè¤ãé¤å»ãããããã®ã¾ã¾æ®ãããã決ã¾ãã¾ããããããã®éå®è©ã¯MAXã®å¼ã§ã¯æå³ãæã¡ã¾ããã
+<em><a href="rrefselectexpression.html#rrefselectexpression">é¸æå¼</a></em>ã«ç½®ããã¨ã®ã§ãããDISTINCTã®éå®è©ã¯ä¸ã¤ã ãã§ãã
+ä¾ãã°ã次ã®ååãã¯è¨±ããã¦ãã¾ããã
+<pre><strong>SELECT COUNT (DISTINCT flying_time), MAX (DISTINCT miles)
+FROM Flights</strong></pre>
+</div>
+
+<p><em>å¼</em>ã¯è¤æ°ã®åã¸ã®åç
§ãå¼ãå«ããã¨ãã§ãã¾ãããä»ã®éç´ãå¯ååããå«ããã¨ã¯ã§ãã¾ããã
+ã¾ãçµè¾¼ã¿ã®ãã¼ã¿åã«è©ä¾¡ãããªããã°ãªãã¾ããã
+å¾ã£ã¦çµè¾¼ã¿ã®ãã¼ã¿åã¨è©ä¾¡ãããã¡ã½ãããå¼ã¶ãã¨ãã§ãã¾ãã
+(ä¾ãã°<em>java.lang.Integer</em>ã<em>int</em>ãè¿ãã¡ã½ããã¯INTEGERã¨è©ä¾¡ããã¾ãã)
+ããå¼ãNULLã¨è©ä¾¡ãããå ´åãéç´ã«ããã¦ãã®å¤ã¯ç¡è¦ããã¾ãã</p>
+
+<p>CHARãVARCHARã«ã¤ãã¦ã¯ãå¤ã®æ«å°¾ã«ãã空ç½æååã¯ãMAXã®æ¯ãèãã«å½±é¿ãããã¾ãã
+ãã¨ãã°ã'z'ã¨'z 'ã®ä¸¡æ¹ãåã«æ ¼ç´ããã¦ããå ´åã空ç½ã¯æ¯è¼ã«ã¦ç¡è¦ãããã®ã§çµæã¯ä¸å®ã§ãããä½ããçæ¹ã®å¤ãè¿ããã¾ãã</p>
+
+<p>çµæã®ãã¼ã¿åã¯MAXãåä½ããå¼ã¨åããã®ã¨ãªãã¾ãã(ãªã¼ãã¼ããã¼ãããã¨ã¯ããã¾ããã)</p>
+ </div>
+
+<div class="example"> <pre><strong><span>-- FlightAvailabilityã¨ãã表ããæè¿ã®æ¥ä»ãæ¢ãã</span>
+SELECT MAX (flight_date) FROM FlightAvailability
+<span>-- ããããã®ç©ºæ¸¯ãåºçºããæãé·è·é¢ã®ä¾¿ãæ¢ãã
+-- ãªã10æé以ä¸ã®ä¾¿ã®ã¿ã¨ããã</span>
+SELECT MAX(flying_time), orig_airport
+FROM Flights
+GROUP BY orig_airport
+HAVING MAX(flying_time) > 10
+</strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="rrefsqlj29026.html" title="">çµã¿è¾¼ã¿é¢æ°</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj27781.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj28468.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj28468.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj28468.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,129 @@
+<!--
+ 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="Case sensitivity of keywords and identifiers, Keywords, case insensitivity of, Special characters, escaping in SQL statements, Escape character, for single-quotation mark, Strings, delimited by single quotation marks within SQL statements, Unicode escapes, support for in SQL statements, Java identifiers, case sensitivity of within SQL, * as wildcard in SQL SELECT, % as wildcard in SQL, _ as wildcard within SQL, Wildcards in SQL, Comment delimiters within SQL, -- (comment delimiters within SQL)" name="DC.subject" />
+<meta content="Case sensitivity of keywords and identifiers, Keywords, case insensitivity of, Special characters, escaping in SQL statements, Escape character, for single-quotation mark, Strings, delimited by single quotation marks within SQL statements, Unicode escapes, support for in SQL statements, Java identifiers, case sensitivity of within SQL, * as wildcard in SQL SELECT, % as wildcard in SQL, _ as wildcard within SQL, Wildcards in SQL, Comment delimiters within SQL, -- (comment delimiters within SQL)" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj23296.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="rrefsql9241891.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="rrefsqlj28468" 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="rrefsqlj28468"><a name="rrefsqlj28468"><!-- --></a>
+
+
+<h1 class="topictitle1">大æåå°æåã¨ç¹æ®æå</h1>
+
+
+<div>
+<div class="section"><div class="p">JDBCã®ã¯ã©ã¹ãã¡ã½ããã«SQLæã®æååã渡ãã¦ã<span>Derby</span>ã«SQLãçºè¡ãããã¨ãã§ãã¾ãã
+SQLæã®æååã«å¯è½ãªæåã»ããã¯Unicodeã§ãããã®æååã«ã¯ã次ã®è¦åãé©ç¨ããã¾ãã<ul>
+<li>äºéå¼ç¨ç¬¦ã§SQL-92ã«å®ç¾©ããã¦ããç¹æ®èå¥åãããªãããã¦ã<em>ããªãããããèå¥å</em>ã¨ãããã¨ãã§ãã¾ãã</li>
+
+<li>ä¸éå¼ç¨ç¬¦ã§æåã®åãåºåããã¨ãã§ãã¾ãã</li>
+
+<li>æåã®åã«ã¦ä¸éå¼ç¨ç¬¦ã¾ãã¯ã¢ãã¹ãããã£ã¼ãããããã«ã¯ãä¸éå¼ç¨ç¬¦ã2ã¤ä¸¦ã¹ã¾ãã(è¨ãæ¹ãå¤ããã°ãä¸éå¼ç¨ç¬¦ã¯ä¸éå¼ç¨ç¬¦ã®ã¨ã¹ã±ã¼ãæåã§ãã)<p>äºéå¼ç¨ç¬¦ã«ã¯ã¨ã¹ã±ã¼ãæåãå¿
è¦ã§ã¯ããã¾ãããäºéå¼ç¨ç¬¦ãããããã«ã¯ãåã«äºéå¼ç¨ç¬¦ã使ã£ã¦ãã ããããã ããJavaã®ããã°ã©ã ã§ã¯ãäºéå¼ç¨ç¬¦ã¯ããã¯ã¹ã©ãã·ã¥ã«ããã¨ã¹ã±ã¼ãã�
�å¿
è¦ã§ãããã¨ãæ°ã«çããå¿
è¦ãããã¾ãã</p>
+<span><strong>ä¾:</strong></span>
+<pre><strong><span>-- ä¸éå¼ç¨ç¬¦ã¯ã¨ã¹ã±ã¼ãæåã§ã-- ä¸éå¼ç¨ç¬¦ã«å¯¾ãã¦</span>
+
+VALUES 'Joe''s umbrella'
+<span>-- ijã§ã¯äºéå¼ç¨ç¬¦ã¯ã¨ã¹ã±ã¼ãããã¾ããã</span>
+VALUES 'He said, "hello!"'
+
+n = stmt.executeUpdate(
+ "UPDATE aTable setStringcol = 'He said, \"hello!\"'");</strong></pre>
+</li>
+
+<li>SQLã®ãã¼ã¯ã¼ãã¯å¤§æåå°æåãåºå¥ãã¾ãããä¾ãã°ãSELECTã¨ãããã¼ã¯ã¼ãã¯ãSELECTãSelectãselectãsELECTã®ãããã§ãæ¸ããã¨ãã§ãã¾ãã</li>
+
+<li>SQL-92ã®æ¸ãæ¹ã«ããèå¥åã¯å¤§æåå°æåãåºå¥ãã¾ããã(<em><a href="crefsqlj34834.html#crefsqlj34834">SQL92èå¥å</a></em>ãåç
§ãã¦ãã ããã)ãã ãããªãããããèå¥åã¯ããã§ã¯ããã¾ããã</li>
+
+<li>Javaã®æ¸ãæ¹ã«ããèå¥åã¯å¸¸ã«å¤§æåå°æåãåºå¥ãã¾ãã</li>
+
+<li>*ã¯ã<em><a href="rrefselectexpression.html#rrefselectexpression">SelectExpression</a>.</em>ã«ã¦ã¯ã¤ã«ãã«ã¼ãæåã§ãã<a href="rrefselectexpression.html#rrefselectexpression__sqlj38441">ã¯ã¤ã«ãã«ã¼ãã®*</a>ãåç
§ãã¦ãã ããã
+ãã®æåã¯åæã«æ
å ±æ¼ç®åã§ãããã¾ãããã®ã»ãã®å ´åãã®æåã¯ã0å以ä¸ã®ç¹°ãè¿ãã表ããæ§æã®ã¡ã¿æåã§ãã</li>
+
+<li>%ã¨_ã¯ãLIKEæ¼ç®åã«ç¶ãæåã®åã«ã¦ä½¿ãããã¨ãã¯ã¤ã«ãã«ã¼ãæåã¨ãªãã¾ãã(ããã¯ã¨ã¹ã±ã¼ããããªãã£ãå ´åã§ãã)詳細ã¯<a href="rrefsqlj23075.html#rrefsqlj23075">çå½å¼</a>ãåç
§ãã¦ãã ããã</li>
+
+<li>SQL-92ã®ä»æ§ã«æ²¿ã£ã¦ä¸è¡ãããã¯è¤æ°è¡ã®ã³ã¡ã³ããæ¸ããã¨ãã§ãã¾ããä¸è¡ã®ã³ã¡ã³ãã¯äºã¤ã®ããã·ã¥(--)ã§å§ã¾ãæ¹è¡æåã§çµããã¾ããè¤æ°è¡ã®æ¹è¡ã¯åå¾ãå²ãæ¸ãæ¹ã§ãã¹ã©ãã·ã¥ã»ã¹ã¿ã¼(/*)ã§å§ã¾ããã¹ã¿ã¼ã»ã¹ã©ãã·ã¥(*/)ã§çµããã¾ãããã®æ¸ãæ¹ã§ã¯å
¥ãåã¨ãªãå ´åããããã¨ãçæãã¦ãã ãããã³ã¡ã³ãã®éå§æåã¨çµäºæåã®éã«ããããã�
�ãæåã¯ç¡è¦ããã¾ãã</li>
+
+</ul>
+</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="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="rrefsql9241891.html" title="">Derbyã®ãµãã¼ãããSQL-92ã®æ©è½</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/rrefsqlj28468.html
------------------------------------------------------------------------------
svn:eol-style = native