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 [32/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/rrefsqlj14122.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj14122.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj14122.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,95 @@
+<!--
+ 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="REAL ãã¼ã¿å" />
+<meta content="REAL data type" name="DC.subject" />
+<meta content="REAL data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreffsqlj14122" 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>REAL ãã¼ã¿å</title>
+</head>
+<body id="rreffsqlj14122"><a name="rreffsqlj14122"><!-- --></a>
+
+
+<h1 class="topictitle1">REAL ãã¼ã¿å</h1>
+
+
+<div>
+<div class="section"> <p>REALåã§ã¯IEEEæµ®åå°æ°ç¹æ°ã®è¨æ³ã«å¾ãæ°ã4ãã¤ãã®é åã«è¨é²ããã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">è¨æ³</h4> <pre><strong>REAL</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">対å¿ããã³ã³ãã¤ã«æã®Javaã®å</h4> <p><em>java.lang.Float</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBCã®ã¡ã¿ãã¼ã¿å(java.sql.Types)</h4> <p>REAL</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">å¶é</h4> <p>REALã®å¤ã®ç¯å²:</p>
+ <ul>
+<li>REALã®æå°å¤: -3.402E+38</li>
+
+<li>REALã®æ大å¤: 3.402E+38</li>
+
+<li>REALã®æå°ã®æ£ã®å¤: 1.175E-37</li>
+
+<li>REALã®æ大ã®è² ã®å¤: -1.175E-37</li>
+
+</ul>
+ <p>ãããã®å¶éã¯Javaã§ã®<samp class="codeph">java.lang.Float</samp>åã®å¶éã¨ã¯ç°ãªãã¾ãã</p>
+
+<p>ãããã®ç¯å²å¤ã®å¤ãè¨ç®ãããã代å
¥ãããã¨ä¾å¤ããããã¾ãã
+ç®è¡æ¼ç®ã§ã¯çµæã¯é¶ã«ä¸¸ãå¦ç<strong>ããã¾ãã</strong>ã
+ããå¤ãå°ããããå ´åã¯ä¾å¤ãæããã¾ããã¢ã³ãã¼ããã¼ãæ¤ç¥ããããã«ãç®è¡æ¼ç®ã¯å精度ã§è¡ããã¾ãã</p>
+
+<div class="p">æµ®åå°æ°ç¹æ°ã®å®æ°ã¯æåé·ã30æåã¾ã§ã«å¶éããã¦ãã¾ãã
+<pre>-- ãã®ä¾ã§ã¯å®æ°ãé·ãããããã¨ã©ã¼ã¨ãªãã¾ãã
+<strong>values 01234567890123456789012345678901e0;</strong></pre>
+</div>
+
+<p>å¼ã«ããã¦ä»ã®ãã¼ã¿åã¨æ··å¨ãã¦å©ç¨ãããå ´åãçµæã®ãã¼ã¿åã¯<a href="rrefsqlj27767.html#rrefsqlj27767">å¼ã«ã¦è¡ãããæ°å¤åã®é
ç®</a>ã«è¨è¿°ãããè¦åã«ã®ã£ã¨ã£ã¦æ±ºã¾ãã¾ãã</p>
+
+<p><a href="rrefsqlj20204.html#rrefsqlj20204">æ°å¤ãç°ãªãæ°å¤åã®åã«è¨é²ãã</a>ãåç
§ãã¦ãã ããã</p>
+
+<p>å®æ°ã¯å¸¸ã«DOUBLE PRECISIONã¨ããã¾ããREALã«å¤æããã«ã¯CASTã使ã£ã¦ãã ããã</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/rrefsqlj14122.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj14854.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj14854.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj14854.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,83 @@
+<!--
+ 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="HAVING ç¯" />
+<meta content="HAVING clause" name="DC.subject" />
+<meta content="HAVING clause" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefclauses.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj14854" 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>HAVING ç¯</title>
+</head>
+<body id="rrefsqlj14854"><a name="rrefsqlj14854"><!-- --></a>
+
+
+<h1 class="topictitle1">HAVING ç¯</h1>
+
+<div>
+<div class="section">
+<p>HAVINGç¯ã«ãã<em><a href="rrefselectexpression.html#rrefselectexpression">é¸æå¼</a></em>ã®GROUP BYã®çµæãçµãè¾¼ã¾ãã¾ããWHEREç¯ãé¸æåä¸è¦§ã«ä½ç¨ããã®ã¨ã¯ç°ãªããHAVINGç¯ã¯è¡¨ããåé¡ãããé¨åéåã«å¯¾ãã¦ä½ç¨ãã¾ããããGROUP BYç¯ããªããã°ãHAVINGç¯ã¯çµæãåç¬ã®åé¡ã¨è¦ãªãã¦ä½ç¨ãã¾ãã
+SELECTç¯ã«ã¦GROUP BYå¥ã®ãªãåãç´æ¥åç
§ãããã¨ã¯ã§ãã¾ããããããå®æ°ãéç´ãç¹æ®å¤æ°ãåç
§ãããã¨ã¯ã§ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4>
+<pre><strong>HAVING <em>æ¤ç´¢æ¡ä»¶</em></strong></pre>
+
+<div class="p"><em>æ¤ç´¢æ¡ä»¶</em>ã¯ç¹æ®ãª<em>çå½å¼</em>ã§ãåé¡å(<a href="rrefsqlj32654.html#rrefsqlj32654">GROUP BY ç¯</a>ãåç
§ãã¦ãã ããã)ããéç´å¼ã®ä¸é¨ã§ããåã®ã¿å«ããäºãã§ãã¾ãã
+ä¾ãã°ä»¥ä¸ã®ä¾ã§ã¯ãSALARYã¨ããåã¯åé¡ã®åãéç´ãå¯åãåããã«ããåã§ã¯ãªãã®ã§ããã®æã¯ä¸æ£ã§ãã
+<pre><strong>-- SELECT COUNT(*)
+-- FROM SAMP.STAFF
+-- GROUP BY ID
+-- HAVING SALARY > 15000</strong></pre>
+</div>
+
+<p>HAVINGç¯ã®éç´ã¯SELECTã®ä¸è¦§ã«ãªãã¦ããã¾ãã¾ããã
+ããHAVINGç¯ãå¯åãåãããå«ããªãã°ããã®å¯åãåããã¯åé¡ã®åã«ã¤ãã¦ã®ã¿ãå¤ã®åãåãããåç
§ãããã¨ãã§ãã¾ãã</p>
+
+</div>
+
+<div class="example">
+<pre><strong><span>-- 2å¸ä»¥ä¸ã®èªè·¯ãã¨ã«ãã¨ã³ããã¼å¸ã®åè¨ã調ã¹ãã</span>
+SELECT SUM(ECONOMY_SEATS_TAKEN), AIRLINE_FULL
+FROM FLIGHTAVAILABILITY, AIRLINES
+WHERE SUBSTR(FLIGHTAVAILABILITY.FLIGHT_ID, 1, 2) = AIRLINE
+GROUP BY AIRLINE_FULL
+HAVING COUNT(*) > 1
+</strong></pre>
+
+</div>
+</div>
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefclauses.html" title="">SQL ç¯</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj14854.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15147.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15147.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15147.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,68 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="LONG VARCHARå" />
+<meta content="LONG VARCHAR data type" name="DC.subject" />
+<meta content="LONG VARCHAR data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj15147" 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>LONG VARCHARå</title>
+</head>
+<body id="rrefsqlj15147"><a name="rrefsqlj15147"><!-- --></a>
+
+
+<h1 class="topictitle1">LONG VARCHARå</h1>
+
+
+<div>
+<div class="section"> <p>LONG VARCHARåã«ããæ大ã§32,700æåãããªãæååãè¨é²ã§ãã¾ãããã®åã®åãå®ç¾©ããã¨ããæ大é·ãæå®ããå¿
è¦ããªããã¨ãé¤ãã°ããã®åã¯VARCHARã¨åæ§ã§ãã</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>LONG VARCHAR</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">対å¿ããã³ã³ãã¤ã«æã®Javaã®å</h4> <p><em>java.lang.String</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBCã¡ã¿ãã¼ã¿å (java.sql.Types)</h4> <p>LONGVARCHAR</p>
+
+<p>Javaã®å¤ãSQLã®å¤ã«å¤æããã¨ããLONG VARCHARã«å¯¾å¿ããJavaã®åã¯åå¨ãã¾ããã</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/rrefsqlj15147.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15260.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15260.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15260.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,101 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="DECIMAL ãã¼ã¿å" />
+<meta content="DECIMAL data type" name="DC.subject" />
+<meta content="DECIMAL data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj15260" 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>DECIMAL ãã¼ã¿å</title>
+</head>
+<body id="rrefsqlj15260"><a name="rrefsqlj15260"><!-- --></a>
+
+
+<h1 class="topictitle1">DECIMAL ãã¼ã¿å</h1>
+
+
+<div>
+<div class="section"> <p>DECIMALã«ãã精度ã¨ç®çããæå®ãã¦æ£ç¢ºãªæ°ãæ±ãã¾ãã
+ãã®åã§ã¯ç²¾åº¦(å°æ°ç¹ã®å·¦å³ã®æ¡æ°ã®åè¨)ã¨ç®çã(å°æ°ç¹ä»¥ä¸ã®æ¡æ°)ãæå®ã§ãã¾ãã
+è¨æ¶è£
ç½®ã«ã¦å¿
è¦ã¨ãããé åã®ãµã¤ãºã¯ã精度ã«ãã決ã¾ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>{ DECIMAL | DEC } [(<em>精度</em> [, <em>ç®çã</em> ])]</strong></pre>
+
+<p><em>精度</em>ã¯1ãã31ã®æ°ãã¨ãã¾ãã<em>ç®çã</em>ã¯ç²¾åº¦ä»¥ä¸ã®æ°ãã¨ãã¾ãã</p>
+
+<p>ç®çããæå®ãããªãã£ãå ´åã®æ¢å®å¤ã¯0ã¨ãªãã¾ãã精度ãæå®ãããªãã£ãå ´åã®æ¢å®å¤ã¯5ã¨ãªãã¾ãã</p>
+
+<p>DECIMALã«ä»£å
¥ãããã¨ãå¯è½ãªã®ã¯ãå°æ°é¨ä»¥å¤ã失ãããªãç¯å²ã®æ°ã§ãã
+DECIMALã®å¤ããå°æ°é¨ãç¡ãããå ´åã<span>Derby</span>ã¯åæ¨ã¦ãè¡ãã¾ãã</p>
+
+<div class="p">ä¾ãã°ã<pre>-- ãã®åå¤æã§å¤±ãããã®ã¯å°æ°é¨ã®ã¿ã§ãã
+<strong>values cast (1.798765 AS decimal(5,2));</strong>
+1
+--------
+1.79
+-- ãã®åå¤æã¯ãã¾ãè¡ãã¾ããã
+<strong>values cast (1798765 AS decimal(5,2));</strong>
+1
+--------
+ERROR 22003: The resulting value is outside the range
+for the data type DECIMAL/NUMERIC(5,2).</pre>
+</div>
+
+<p>ä»ã®ãã¼ã¿åãå¼ã«ã¦æ··å¨ãã¦å©ç¨ããã¦ããå ´åãå¼ã®çµæã¨ãªãåã¯<a href="rrefsqlj27767.html#rrefsqlj27767">å¼ã«ã¦è¡ãããæ°å¤åã®é
ç®</a>ã§æ¸ãããã¨ããã«æ±ºã¾ãã¾ãã</p>
+
+<p><a href="rrefsqlj20204.html#rrefsqlj20204">æ°å¤ãç°ãªãæ°å¤åã®åã«è¨é²ãã</a>ãåç
§ãã¦ãã ããã</p>
+
+<p>äºã¤ã®DECIMALã®å¤ãå¼ã«ã¦ç¨ãããã¦ããå ´åãå¼ã®çµæã¨ãªãåã¯<a href="rrefsqlj36146.html#rrefsqlj36146">å°æ°ãè¨ç®ããã¨ãã®ç®çã</a>ã«è¨è¿°ãããè¦åã«å¾ã£ã¦æ±ºã¾ãã¾ãã</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">対å¿ããã³ã³ãã¤ã«æã®Javaã®å</h4> <p><em>java.math.BigDecimal</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBC ã®ã¡ã¿ãã¼ã¿å (java.sql.Types)</h4> <p>DECIMAL</p>
+ </div>
+
+<div class="example"> <pre><strong>VALUES 123.456
+
+VALUES 0.001</strong></pre>
+
+<p>BIGINTã«ã¯å¤§ããããæ´æ°ã®å®æ°ã¯ãDECIMALã®å®æ°ã¨ãªãã¾ãã</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/rrefsqlj15260.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15309.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15309.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15309.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,74 @@
+<!--
+ 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="WHERE CURRENT OF ç¯" />
+<meta content="WHERE CURRENT OF clause" name="DC.subject" />
+<meta content="WHERE CURRENT OF clause" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefclauses.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj15309" 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>WHERE CURRENT OF ç¯</title>
+</head>
+<body id="rrefsqlj15309"><a name="rrefsqlj15309"><!-- --></a>
+
+
+<h1 class="topictitle1">WHERE CURRENT OF ç¯</h1>
+
+<div>
+<div class="section">
+<p>WHERE CURRENT OFç¯ã¯UPDATEãDELETEæã«ã¦ä½¿ããã¨ãã§ãã¾ãã
+ããã«ããæ´æ°å¯è½ãªã«ã¼ã½ã«ã®ä½ç½®ã«ããæ´æ°ãåé¤ãè¡ãã¾ãã
+æ´æ°å¯è½ãªã«ã¼ã½ã«ã®è©³ç´°ã«ã¤ãã¦ã¯ã<a href="rrefsqlj41360.html#rrefsqlj41360">SELECT æ</a>ãåç
§ãã¦ãã ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4>
+<pre><strong>WHERE CURRENT OF <em><a href="rrefcursorname.html#rrefcursorname">ã«ã¼ã½ã«å</a></em></strong></pre>
+
+</div>
+
+<div class="example">
+<pre>Statement s = conn.createStatement();
+s.setCursorName("AirlinesResults");
+ResultSet rs = conn.executeQuery(
+ "SELECT Airline, basic_rate " +
+ "FROM Airlines FOR UPDATE OF basic_rate");
+Statement s2 = conn.createStatement();
+s2.executeUpdate("UPDATE Airlines SET basic_rate = basic_rate " +
+ "+ .25 WHERE CURRENT OF AirlinesResults");</pre>
+
+</div>
+</div>
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefclauses.html" title="">SQL ç¯</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15309.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15446.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15446.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15446.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,127 @@
+<!--
+ 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="CREATE VIEW æ" />
+<meta content="CREATE VIEW statement, CREATE VIEW, SQL statements, views, creating" name="DC.subject" />
+<meta content="CREATE VIEW statement, CREATE VIEW, SQL statements, views, 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="rrefsqlj24513.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj43125.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj15446" 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>CREATE VIEW æ</title>
+</head>
+<body id="rrefsqlj15446"><a name="rrefsqlj15446"><!-- --></a>
+
+
+<h1 class="topictitle1">CREATE VIEW æ</h1>
+
+
+<div>
+<div class="section"> <p>ãã¥ã¼ã¨ã¯ã¯ã¨ãªã«ããå®ç¾©ãããä»®æ³çãªè¡¨ã§ãã表ã¯ç ´æ£ããã¾ã§å©ç¨å¯è½ãªãã£ã¯ã·ã§ããªã®æ
å ±ã§ãããã¥ã¼ã¯æ´æ°ã§ãã¾ããã</p>
+
+<p>éå®ããããã¥ã¼ã®ååã«ã¦ãã¹ãã¼ãåã¯<em>SYS</em>ã§å§ã¾ã£ã¦ã¯ãªãã¾ããã</p>
+
+<p>ãã¥ã¼ã®ææè
ã¯èªåçã«SELECT権éãå¾ã¾ãããã¥ã¼ã®ææè
ããSELECT権éãå¥å¥ªãããã¨ã¯ã§ãã¾ããã<a href="rrefattrib26867.html#rrefattrib26867">ãã¼ã¿ãã¼ã¹ã®ææè
</a>ã¯èªåçã«ãã¥ã¼ã¸ã®SELECT権éãæã¡ãSELECT権éãä»ã®ã¦ã¼ã¶ã«ä»ä¸ãããã¨ãã§ãã¾ãããã¼ã¿ãã¼ã¹ã®ææè
ããSELECT権éãå¥å¥ªãããã¨ã¯ã§ãã¾ããã</p>
+
+<p>ãã¥ã¼ã®ææè
ã¯ãã¥ã¼ãåç
§ããæ
å ±ãææããå ´åã®ã¿ãä»ã®ã¦ã¼ã¶ã«SELECT権éãä»ä¸ãããã¨ãã§ãã¾ãã</p>
+<p>ãã¥ã¼ã®ææè
ãããã¥ã¼ãåç
§ããæ
å ±ãææãã¦ããªãå ´åããã¥ã¼ã®ææè
ã¯é©åãªæ¨©éãä»ä¸ããã¦ããªããã°ãªãã¾ãããä¾ãã°ã<samp class="codeph">user2</samp>ã¨ããèªè¨¼èå¥åã<samp class="codeph">user1.t1</samp>ã¨ãã表ã¨<samp class="codeph">user1.f_abs()</samp>ã¨ããé¢æ°ãåç
§ããã<samp class="codeph">user2.v2</samp>ã¨ãããã¥ã¼ãä½æããå ´åã<samp class="codeph">user2</samp>ã¯<samp class="codeph">user1.t1</samp>ã¸ã®SELECT権éã¨<samp class="codeph">user1.f_abs()ã¸ã®EXECUTE権éãæããªããã°ã
ªãã¾ããã</samp>. </p>
+
+<p>SELECT権éãä»ä¸ãã権éã¯å¥å¥ªã§ãã¾ããããã¥ã¼ãåç
§ããæ
å ±ã¸ã®å¿
è¦ãªæ¨©éãå¥å¥ªãããå ´åããã¥ã¼ã¯ç ´æ£ããã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>CREATE VIEW <em><a href="rrefviewname.html#rrefviewname">ãã¥ã¼å</a></em>
+ [ ( <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">åç´åå</a></em> [, <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">åç´åå</a></em>] * ) ]
+AS <em><a href="rrefsqlj21571.html#rrefsqlj21571">åãåãã</a></em> </strong></pre>
+ <p>ãã¥ã¼ã®å®ç¾©ã«ãã¥ã¼ã®åä¸è¦§ãæ¸ããã¨ã§ããã¥ã¼ã®åã«æ示çãªååãä¸ãããã¨ãã§ãã¾ãã
+ãã¥ã¼ã®åä¸è¦§ããªãå ´åããã¥ã¼ã®ååã¯å
ã¨ãªãåãåããã®ååãå¼ç¶ãã¾ãããã¥ã¼ã®å
¨åã¯ä¸æãªååãæããªããã°ãªãã¾ããã</p>
+ </div>
+
+<div class="example"> <pre><strong>CREATE VIEW SAMP.V1 (COL_SUM, COL_DIFF)
+ AS SELECT COMM + BONUS, COMM - BONUS
+ FROM SAMP.EMPLOYEE;
+
+CREATE VIEW SAMP.VEMP_RES (RESUME)
+ AS VALUES 'Delores M. Quintana', 'Heather A. Nicholls', 'Bruce Adamson';
+
+CREATE VIEW SAMP.PROJ_COMBO
+ (PROJNO, PRENDATE, PRSTAFF, MAJPROJ)
+ AS SELECT PROJNO, PRENDATE, PRSTAFF, MAJPROJ
+ FROM SAMP.PROJECT UNION ALL
+SELECT PROJNO, EMSTDATE, EMPTIME, EMPNO
+ FROM SAMP.EMP_ACT
+ WHERE EMPNO IS NOT NULL;</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">æã®ä¾å</h4>
+<div class="p">ãã¥ã¼ã®å®ç¾©ã¯åç
§ãã表ããã¥ã¼ã«ä¾åãã¾ãã
+ãã¥ã¼ãåç
§ããDML(data manipulation language)æã¯ããã¥ã¼ãä¾åããã®ã¨åæ§ã«ããã®ãã¥ã¼ã«ä¾åãã¾ãã
+ãã¥ã¼ãåç
§ããæã¯ããã¥ã¼ãå©ç¨ããç´¢å¼ã«ä¾åãã¾ãããã®ç´¢å¼ã¯åãåãããã©ã®ããã«æé©åããããã«å¿ãã¦ææ¯ã«ç°ãªãã¾ãã
+ä¾ã以ä¸ã«æãã¾ãã<pre><strong>CREATE TABLE T1 (C1 DOUBLE PRECISION);
+
+CREATE FUNCTION SIN (DATA DOUBLE)
+ RETURNS DOUBLE EXTERNAL NAME 'java.lang.Math.sin'
+ LANGUAGE JAVA PARAMETER STYLE JAVA;
+
+CREATE VIEW V1 (C1) AS SELECT SIN(C1) FROM T1;</strong></pre>
+</div>
+
+<div class="p">æã¨ãããä¾åãããã¼ã¿ãã¼ã¹ã®æ
å ±ãæãã¾ãã
+<pre><strong>SELECT * FROM V1
+</strong></pre>
+</div>
+
+<p><em>V1</em>ã¨ãããã¥ã¼ã<em>T1</em>ã¨ãã表ã
+å¤é¨ã®ã¹ã«ã©ã¼é¢æ°ã®<em>SIN</em></p>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="crefsqlj95081.html" title="">CREATE æ</a></div>
+</div>
+<div class="relref"><strong>Related reference</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="rrefsqlj24513.html" title="">CREATE TABLE æ</a></div>
+<div><a href="rrefsqlj43125.html" title="">CREATE TRIGGER æ</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15446.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15866.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15866.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15866.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="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="CURRENT_TIMESTAMPé¢æ°" />
+<meta content="CURRENT_TIMESTAMP function" name="DC.subject" />
+<meta content="CURRENT_TIMESTAMP function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj15866" 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>CURRENT_TIMESTAMPé¢æ°</title>
+</head>
+<body id="rrefsqlj15866"><a name="rrefsqlj15866"><!-- --></a>
+
+
+<h1 class="topictitle1">CURRENT_TIMESTAMPé¢æ°</h1>
+
+<div>
+<div class="section">
+<p>CURRENT_TIMESTAMPã¯ç¾å¨ã®ã¿ã¤ã ã¹ã¿ã³ããè¿ãã¾ããé¢æ°ããè¿ãããå¤ã¯ä¸ã¤ã®æã®ãã¡ã§ããã°ãä½åº¦å®è¡ããã¦ãåãå¤ãè¿ãã¾ããã§ããããã«ã¼ã½ã«ããè¡ãæ¾ãéã«çµéããæéã«ãããããããã®é¢æ°ã¯åãå¤ãè¿ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">åå¸</h4>
+<pre><strong>CURRENT_TIMESTAMP</strong></pre>
+
+<p>ã¾ãã¯</p>
+
+<pre><strong>CURRENT TIMESTAMP</strong></pre>
+
+</div>
+
+<div class="example">
+<pre><strong>VALUES CURRENT_TIMESTAMP
+<span>-- ã¾ãã¯</span>
+
+VALUES CURRENT TIMESTAMP</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/rrefsqlj15866.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16095.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16095.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16095.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,73 @@
+<!--
+ 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="rrefsqlj13590.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj42154.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj16357.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj91438.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj16095" 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="rrefsqlj16095"><a name="rrefsqlj16095"><!-- --></a>
+
+
+<h1 class="topictitle1">åæ¯ã®å¶ç´</h1>
+
+<div>
+<div class="example"> <pre><strong>{
+ NOT NULL |
+ [ [CONSTRAINT <em><a href="rrefconstraintname.html#rrefconstraintname">å¶ç´å</a></em>]
+ {
+ CHECK (<em><a href="rrefsqlj91438.html#rrefsqlj91438">æ¤ç´¢æ¡ä»¶</a></em>) |
+ {
+ PRIMARY KEY |
+ UNIQUE |
+ <em><a href="rrefsqlj16357.html#rrefsqlj16357">REFERENCES ç¯</a></em>
+ }
+ }
+}</strong></pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefsqlj13590.html" title="">CONSTRAINT ç¯</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefsqlj42154.html" title="">表ãã¨ã®å¶ç´</a></div>
+<div><a href="rrefsqlj16357.html" title="">åç
§å®ç¾©</a></div>
+<div><a href="rrefsqlj91438.html" title="">æ¤ç´¢æ¡ä»¶</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16095.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16221.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16221.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16221.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,78 @@
+<!--
+ 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="SMALLINT ãã¼ã¿å" />
+<meta content="SMALLINT data type" name="DC.subject" />
+<meta content="SMALLINT data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj16221" 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>SMALLINT ãã¼ã¿å</title>
+</head>
+<body id="rrefsqlj16221"><a name="rrefsqlj16221"><!-- --></a>
+
+
+<h1 class="topictitle1">SMALLINT ãã¼ã¿å</h1>
+
+
+<div>
+<div class="section"> <p>SMALLINTã§ã¯2ãã¤ãã®è¨æ¶é åãæä¾ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">Syntax</h4> <pre><strong>SMALLINT</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">対å¿ããã³ã³ãã¤ã«æã®Javaã®å</h4> <p><em>java.lang.Short</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBCã®ã¡ã¿ãã¼ã¿å (java.sql.Types)</h4> <p>SMALLINT</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">æå°å¤</h4> <p id="rrefsqlj16221__sqlj22378"><a name="rrefsqlj16221__sqlj22378"><!-- --></a>-32768 (<em>java.lang.Short.MIN_VALUE</em>)</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">æ大å¤</h4> <p id="rrefsqlj16221__sqlj97879"><a name="rrefsqlj16221__sqlj97879"><!-- --></a>32767
+(<em>java.lang.Short.MAX_VALUE</em>)</p>
+
+<p>ä»ã®ãã¼ã¿åãå¼ã«ã¦æ··å¨ãã¦å©ç¨ãããå ´åãçµæã®ãã¼ã¿åã¯<a href="rrefsqlj27767.html#rrefsqlj27767">å¼ã«ã¦è¡ãããæ°å¤åã®é
ç®</a>ã«è¨ãããè¦åã«åã決ã¾ãã¾ãã</p>
+
+<p><a href="rrefsqlj20204.html#rrefsqlj20204">æ°å¤ãç°ãªãæ°å¤åã®åã«è¨é²ãã</a>ãåç
§ãã¦ãã ããã</p>
+ <p>æ´æ°ã®å®æ°ã¯ããã®å¤ã«ããINTEGERãããã¯BIGINTã¨ãªãã¾ãã</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/rrefsqlj16221.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16357.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16357.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16357.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="åç
§å®ç¾©" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj13590.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj16095.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj42154.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj91438.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj16357" 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="rrefsqlj16357"><a name="rrefsqlj16357"><!-- --></a>
+
+
+<h1 class="topictitle1">åç
§å®ç¾©</h1>
+
+<div>
+<div class="example"> <pre><strong>REFERENCES <em><a href="rreftablename.html#rreftablename">表å</a></em> [ ( <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">åç´åå</a></em> [ , <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">åç´åå</a></em> ]* ) ]
+[ ON DELETE {NO ACTION | RESTRICT | CASCADE | SET NULL}]
+ [ ON UPDATE {NO ACTION | RESTRICT }]
+|
+[ ON UPDATE {NO ACTION | RESTRICT }] [ ON DELETE
+ {NO ACTION | RESTRICT | CASCADE | SET NULL}] </strong></pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefsqlj13590.html" title="">CONSTRAINT ç¯</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefsqlj16095.html" title="">åæ¯ã®å¶ç´</a></div>
+<div><a href="rrefsqlj42154.html" title="">表ãã¨ã®å¶ç´</a></div>
+<div><a href="rrefsqlj91438.html" title="">æ¤ç´¢æ¡ä»¶</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16357.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16762.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16762.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16762.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,70 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="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="LENGTHé¢æ°" />
+<meta content="LENGTH function" name="DC.subject" />
+<meta content="LENGTH function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj16762" 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>LENGTHé¢æ°</title>
+</head>
+<body id="rrefsqlj16762"><a name="rrefsqlj16762"><!-- --></a>
+
+
+<h1 class="topictitle1">LENGTHé¢æ°</h1>
+
+
+<div>
+<div class="section"> <p>LENGTHã¯æååå¼ãããã¯ãããåå¼ã«é©ç¨ãã¦ãæåã®é·ããçµæã¨ãã¦è¿ãã¾ãã</p>
+
+<p>ããããçµè¾¼ã¿ã®ãã¼ã¿åã¯æé»ã®ãã¡ã«æååã«å¤æã§ããã®ã§ããã®é¢æ°ã¯ãããããã¼ã¿åã«é©ç¨ãããã¨ãã§ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>LENGTH ( { <em>æååå¼</em> | <em>ãããåå¼</em> } )</strong></pre>
+ </div>
+
+<div class="example"> <pre><strong><span>-- 20ãè¿ãã</span>
+VALUES LENGTH('supercalifragilistic')
+<span>-- 1ãè¿ãã</span>
+VALUES LENGTH(X'FF')
+-- 4ãè¿ã
+VALUES LENGTH(1234567890)</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/rrefsqlj16762.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj18730.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj18730.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj18730.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="DATEãã¼ã¿å" />
+<meta content="DATE data type" name="DC.subject" />
+<meta content="DATE data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj18730" 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>DATEãã¼ã¿å</title>
+</head>
+<body id="rrefsqlj18730"><a name="rrefsqlj18730"><!-- --></a>
+
+
+<h1 class="topictitle1">DATEãã¼ã¿å</h1>
+
+
+<div>
+<div class="section"> <p>DATEã«ããã<em>java.sql.Date</em>ã®ç¯å²ã§å¹´ææ¥ãè¨é²ã§ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>DATE</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">対å¿ããå®è¡æã®Javaã®å</h4> <p><em>java.sql.Date</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBCã¡ã¿ãã¼ã¿å(java.sql.Types)</h4><p>DATE</p>
+
+<p>ä¸ã¤ã®å¼ã«æ¥ä»ãæå»ãã¿ã¤ã ã¹ã¿ã³ããæ··å¨ããã¦ã¯ãªãã¾ããã</p>
+
+<div class="p"><em>java.sql.Date</em>ã®ã¡ã½ããã«ããæ±ããã¨ã®ã§ããå
¨ã¦ã®å¤ãã対å¿ããSQLã®æ¥ä»ãæå»ã®ãã¼ã¿åã®åã«ã¦è¨±ããã¦ãã¾ãã<span>Derby</span>ã¯DATEã®å¤ã«å¯¾ãã¦æ¬¡ã®æ¸å¼ãç¨æãã¦ãã¾ãã<pre>yyyy-mm-dd
+mm/dd/yyyy
+dd.mm.yyyy</pre>
+ä¸ã«ç¤ºããä¸ã¤ã®æ¸å¼ã®ãã¡ãæåã®ãã®ã¯<em>java.sql.Date</em>ã®æ¸å¼ã§ãã</div>
+
+<p>å¹´ã¯å¸¸ã«4æ¡ã®æ°åã§è¡¨ãããªããã°ãªãã¾ãããããã«å¯¾ãã¦æãæ¥ã¯ä¸æ¡ãããã¯äºæ¡ã®æ°åã§è¡¨ããã¨ãã§ãã¾ãã</p>
+
+<p>ããã«ã<span>Derby</span>ã¯DB2ãµã¼ãã®ãã±ã¼ã«ã«ç¹æãªæ¥æã®æ¸å¼ãåãä»ãã¾ããããã¨ãã¹ãæ¸å¼ãããã¾ãã§ããå ´åã¯ãä¸ã§ç¤ºããçµè¾¼ã¿ã®æ¸å¼ãåªå
ããã¾ãã</p>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">ä¾</h4> <pre><strong>VALUES DATE('1994-02-23')
+
+VALUES '1993-09-01'</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/rrefsqlj18730.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj18922.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj18922.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj18922.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,110 @@
+<!--
+ 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="LEFT OUTER JOINæ¼ç®" />
+<meta content="LEFT OUTER JOIN operation" name="DC.subject" />
+<meta content="LEFT OUTER JOIN operation" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29840.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj18922" 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>LEFT OUTER JOINæ¼ç®</title>
+</head>
+<body id="rrefsqlj18922"><a name="rrefsqlj18922"><!-- --></a>
+
+
+<h1 class="topictitle1">LEFT OUTER JOINæ¼ç®</h1>
+
+
+<div>
+<div class="section">
+<p>LEFT OUTER JOINæ¼ç®ã¯ãjoinç¯ãè¨è¿°ã§ãã<a href="rrefsqlj29840.html#rrefsqlj29840">JOINæ¼ç®</a>ã®ä¸ã¤ã§ãã
+ãã®æ¼ç®ã§ã¯æåã®(å·¦ã®)表ã«ã¦ãä¸è´ããè¡ãäºã¤ç®ã®(å³ã®)表ã«ãªãè¡ã¯ãäºã¤ç®ã®è¡¨ã®NULLã®è¡ã«çµåããããã®ã¨ãã¦ãçµæã«æ®ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4>
+<pre>
+<strong><em><a href="rreftableexpression.html#rreftableexpression">表å¼</a></em> LEFT [ OUTER ] JOIN <em><a href="rreftableexpression.html#rreftableexpression">表å¼</a></em>
+{
+ ON <em>çå½å¼</em>
+ }</strong></pre>
+
+<p>ONç¯ã«ãããããã®çå½å¼ããç´æ¥ã®è¡¨ã¨ç´æ¥ã®åãåããæã«ãããããªã表ãåç
§ãããã¨ãã§ãã¾ãã
+ONç¯ã¯çµåããã¦ããªã表ãåç
§ãããã¨ãã§ãã¾ãããçµåããã¦ãã表ãåç
§ããªãã¨ããã¾ãã¾ããã(ãã ãä¸è¬çã«ã¯åç
§ãã¾ãã)</p>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">ä¾ 1</h4><pre><strong>--é½å¸ã«å¯¾å¿ããã¢ã¸ã¢ã®å½</strong>
+
+SELECT CITIES.COUNTRY, CITIES.CITY_NAME, REGION
+FROM Countries
+LEFT OUTER JOIN Cities
+ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE
+WHERE REGION = 'Asia'
+
+<strong>-- LEFT JOINã¨ããå¥ã®æ¸ãæ¹ã«ãããåä¾ã¨åãçµæã
+-- å®ç¾ããã
+</strong>
+SELECT COUNTRIES.COUNTRY, CITIES.CITY_NAME,REGION
+FROM COUNTRIES
+LEFT JOIN CITIES
+ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE
+WHERE REGION = 'Asia'
+</pre>
+</div>
+
+<div class="example"><h4 class="sectiontitle">ä¾ 2</h4><pre><strong>
+-- EMPLOYEEã¨DEPAETMENTã¨ãã表ãçµåãã¦ã
+-- 1930ããåã«çã¾ãã(BIRTHDATE)å
¨ã¦ã®ç¤¾å¡ã®ã
+-- 社å¡çªå·(EMPNO)ã¨ã
+-- 社å¡ã®èå(LASTNAME)ã¨ã
+-- é¨ç½²çªå·(EMPLOYEEã¨ãã表ã®WORKDEPTã¨ãDEPARTMENTã¨ãã表ã®DEPTNO)ã¨ã
+-- é¨ç½²å(DEPTNAME)ãé¸æããã
+</strong>
+SELECT EMPNO, LASTNAME, WORKDEPT, DEPTNAME
+ FROM SAMP.EMPLOYEE LEFT OUTER JOIN SAMP.DEPARTMENT
+ ON WORKDEPT = DEPTNO
+ AND YEAR(BIRTHDATE) < 1930
+
+<strong>-- 管çè
ã®ããªãé¨ç½²ãå«ãå
¨ã¦ã®é¨ç½²ãã
+-- é¨ç½²ã®ç®¡çè
ã®ç¤¾å¡çªå·ã¨èåã¨å
±ã«ä¸è¦§ããã
+</strong>
+SELECT DEPTNO, DEPTNAME, EMPNO, LASTNAME
+ FROM DEPARTMENT LEFT OUTER JOIN EMPLOYEE
+ ON MGRNO = EMPNO</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/rrefsqlj18922.html
------------------------------------------------------------------------------
svn:eol-style = native