db-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r854277 [36/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/
Date Wed, 13 Mar 2013 13:54:25 GMT
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32613.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32613.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32613.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,71 @@
+<!--
+  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="RTRIM関数" />
+<meta content="RTRIM function" name="DC.subject" />
+<meta content="RTRIM function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj32613" 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>RTRIM関数</title>
+</head>
+<body id="rrefsqlj32613"><a name="rrefsqlj32613"><!-- --></a>
+
+
+<h1 class="topictitle1">RTRIM関数</h1>
+
+
+<div>
+<div class="section"> <p>RTRIMは文字式の末尾にある空白を取り除きます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> 
+<pre><strong>RTRIM(<em>文字式</em>)</strong></pre>
+ <p>A
+文字式はCHAR、VARCHAR、LONG VARCHARおよび、文字列に暗黙に変換可能な組込みのデータ型です。</p>
+ 
+<p>もし<em>文字式</em>がnullなら、RTRIMの結果はnullです。</p>
+ </div>
+
+<div class="example"> <pre><strong><span>-- ' asdf'が返ります。</span>
+VALUES RTRIM(' asdf  ')
+<span>-- 'asdf'が返ります。</span>
+VALUES RTRIM('asdf  ')</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/rrefsqlj32613.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32654.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32654.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32654.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="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="GROUP BY 節" />
+<meta content="GROUP BY clause" name="DC.subject" />
+<meta content="GROUP BY clause" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefclauses.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj32654" 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>GROUP BY 節</title>
+</head>
+<body id="rrefsqlj32654"><a name="rrefsqlj32654"><!-- --></a>
+
+
+<h1 class="topictitle1">GROUP BY 節</h1>
+
+
+<div>
+<div class="section"> 
+<p>GROUP BY 節は<em><a href="rrefselectexpression.html#rrefselectexpression">選択式</a></em>の一部とすることができます。この節により結果を一列以上の列の間で同じ値を持つ、結果の部分集合にまとめることができます。
+それぞれの部分集合には、分類列が同じ値を持つ行はありません。
+NULLは部分集合へのまとめを行う場合、同じ値と見なされます。</p>
+  
+<p>典型的にいって、GROUP BY節は集約式と併せて使われます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>GROUP BY <em><a href="rrefcolumnname.html#rrefcolumnname">列名</a></em> [ , <em><a href="rrefcolumnname.html#rrefcolumnname">列名</a></em> ] *</strong></pre>
+ <p><em><a href="rrefcolumnname.html#rrefcolumnname">列名</a></em> は問い合わせにて可視でなければなりません。問い合わせにて不可視な列であってはなりません。
+例えば、GROUP BY節が副問い合わせにあった場合、その節は副問い合わせの外にある問い合わせの列を参照してはなりません。
+</p>
+
+<p>GROUP BY節を持つ<em><a href="rrefselectexpression.html#rrefselectexpression">選択式</a></em>にある<em>選択項目</em>は集約か分類列でなければなりません。</p>
+ </div>
+
+
+<div class="example"> <pre><strong><span>-- airportで分類されたflightsの、
+-- flying_timesの平均を探す。</span>
+SELECT AVG (flying_time), orig_airport
+FROM Flights
+GROUP BY orig_airport
+
+SELECT MAX(city_name), region
+FROM Cities, Countries
+WHERE Cities.country_ISO_code = Countries.country_ISO_code
+GROUP BY region
+<span>-- smallintによる分類</span>
+SELECT ID, AVG(SALARY)
+FROM SAMP.STAFF
+GROUP BY ID
+-- AVGSALARY、EMPCOUNT列と、DEPTNO列をAS節により取得する。
+-- さらにOTHERSという相関名で、WORKDEPT列による分類を行う。
+SELECT OTHERS.WORKDEPT AS DEPTNO,
+AVG(OTHERS.SALARY) AS AVGSALARY,
+COUNT(*) AS EMPCOUNT
+FROM SAMP.EMPLOYEE OTHERS
+GROUP BY OTHERS.WORKDEPT
+</strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</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/rrefsqlj32654.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32693.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32693.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32693.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="AVG関数" />
+<meta content="AVG aggregate function" name="DC.subject" />
+<meta content="AVG aggregate function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj32693" 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>AVG関数</title>
+</head>
+<body id="rrefsqlj32693"><a name="rrefsqlj32693"><!-- --></a>
+
+
+<h1 class="topictitle1">AVG関数</h1>
+
+
+<div>
+<div class="section"> <p>AVGは複数行にわたる式の平均を評価する集約関数です。(<a href="rrefsqlj33923.html#rrefsqlj33923">集約 (集合関数)</a>を参照してください。)
+AVGは数値型に評価される式に対してのみ作用させることができます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>AVG ( [ DISTINCT | ALL ] <em>式</em> )</strong></pre>
+ 
+<p>DISTICTを指定すると、重複が取り除かれます。
+ALLを指定すると、重複を残します。ALLもDISTINCTも指定されない場合の既定はALLです。
+例えば、列の値が1.0、1.0、1.0、1.0、2.0だったとします。この場合、AVG(col)はAVG(DISTINCT col)より小さな値を返します。</p>
+ 
+<div class="p">DISTINCTな集約式は、<em><a href="rrefselectexpression.html#rrefselectexpression">選択式</a></em>に一つだけ置くことができます。
+例えば、次の問合せは無効です。<pre><strong>SELECT AVG (DISTINCT flying_time), SUM (DISTINCT miles)
+FROM Flights</strong></pre>
+</div>
+ 
+<p>式には複数列への参照や式があってかまいませんが、他の集約や副問合せがあってはなりません。
+また評価結果はSQL-92の数値型でなければなりません。したがってSQL-92の型に評価される関数なら呼ぶことができます。もし評価結果がNULLであった場合、集約にてその値は省かれます。</p>
+ 
+<div class="p">結果のデータ型は操作される式と同じデータ型です。(オーバーフローはありません)
+例えば次の問合せは予想に反して整数の<em>1</em>を返します。
+<pre><strong>SELECT AVG(c1)
+FROM (VALUES (1), (1), (1), (1), (2)) AS myTable (c1)</strong></pre>
+</div>
+ 
+<div class="p">より精度が必要であれば、式をキャストします。<pre><strong>SELECT AVG(CAST (c1 AS DOUBLE PRECISION))
+FROM (VALUES (1), (1), (1), (1), (2)) AS myTable (c1)</strong></pre>
+</div>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefsqlj29026.html" title="">組み込み関数</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32693.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32714.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32714.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32714.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,76 @@
+<!--
+  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="VARCHAR FOR BIT DATA データ型" />
+<meta content="VARCHAR FOR BIT DATA type" name="DC.subject" />
+<meta content="VARCHAR FOR BIT DATA type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj32714" 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>VARCHAR FOR BIT DATA データ型</title>
+</head>
+<body id="rrefsqlj32714"><a name="rrefsqlj32714"><!-- --></a>
+
+
+<h1 class="topictitle1">VARCHAR FOR BIT DATA データ型</h1>
+
+
+<div>
+<div class="section"> <p>VARCHAR FOR BIT DATAでは指定された長さ以下のバイナリ列を記録することができます。これは画像のような文字列とすることが適当ではない、構造のない情報を記録するのに便利です。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>{ VARCHAR | CHAR VARYING | CHARACTER VARYING } (<em>長さ</em>) FOR BIT DATA </strong></pre>
+ 
+<p><em>長さ</em>は符号のない整数のリテラルで、長さをバイト数で指定します。</p>
+ 
+<p>CHAR FOR BIT DATAとは異なり、VARCHAR FOR BIT DATAには、既定の<em>長さ</em>は存在しません。<em>長さ</em>は最大で32,672バイトにする事ができます。</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBCメタデータ型 (java.sql.Types)</h4> 
+<p>VARBINARY</p>
+ 
+<p>
+VARCHAR FOR BIT DATAでは可変長のバイト列が記録されます。CHAR FOR BIT DATAとは異なり、VARCHAR FOR BIT DATAでは長さをそろえるための値詰めはありません。</p>
+ 
+<p>値の連結などをVARCHAR FOR BIT DATAとCHAR FOR BIT DATAの値に行うと、得られる結果の値はVARCHAR FOR BIT DATAとなります。</p>
+ </div>
+
+<div class="example"> <p>バイトのリテラル値は常にVARCHAR FOR BIT DATAです。CHAR FOR BIT DATAではありません。</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/rrefsqlj32714.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33215.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33215.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33215.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,63 @@
+<!--
+  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="rreftableexpression.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljtfinvoke.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj33215" 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="rrefsqlj33215"><a name="rrefsqlj33215"><!-- --></a>
+
+
+<h1 class="topictitle1">表またはビューあるいは関数式</h1>
+
+<div>
+<div class="example"> <pre><strong>{<em> <a href="rreftablename.html#rreftablename">表名</a></em> | <em> <a href="rrefviewname.html#rrefviewname">ビュー名</a></em> | <em><a href="rrefsqljtfinvoke.html#rrefsqljtfinvoke">表関数呼び出し</a></em>}
+    [ [ AS ] <em><a href="rrefcorrelationname.html#rrefcorrelationname">相関名</a></em>
+        [ (<em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">単純列名</a></em> [ , <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">単純列名</a></em>]* ) ] ] ]
+</strong></pre>
+</div>
+
+</div>
+
+<div>
+<ul class="ullinks">
+<li class="ulchildlink"><strong><a href="rrefsqljtfinvoke.html">表関数の呼び出し</a></strong><br />
+</li>
+</ul>
+
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rreftableexpression.html" title="">TableExpression</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33215.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33520.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33520.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33520.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,85 @@
+<!--
+  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="MIN関数" />
+<meta content="MIN aggregate function" name="DC.subject" />
+<meta content="MIN aggregate function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj33520" 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>MIN関数</title>
+</head>
+<body id="rrefsqlj33520"><a name="rrefsqlj33520"><!-- --></a>
+
+
+<h1 class="topictitle1">MIN関数</h1>
+
+
+<div>
+<div class="section"> <p>MINは集約関数で、全行に渡る式の最小値を求めます。
+(<a href="rrefsqlj33923.html#rrefsqlj33923">集約 (集合関数)</a>を参照してください。)
+MINは組み込みのデータ型に対してのみ適用可能です。(これにはCHAR、VARCHAR、DATE、TIME等が含まれます。)</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>MIN ( [ DISTINCT | ALL ] <em>式</em> )</strong></pre>
+ 
+<div class="p">
+DISTINCTとALLという限定詞には、重複を取り除いたり、重複を残す働きがあります。しかしこれらの限定詞はMIN式では効果がありません。
+<em><a href="rrefselectexpression.html#rrefselectexpression">選択式</a></em>には限定詞は唯一つしか書くことができません。
+例えば次の問合せは許されません。<pre><strong>SELECT COUNT (DISTINCT flying_time), MIN (DISTINCT miles)
+FROM Flights</strong></pre>
+</div>
+ 
+<p>この<em>式</em>には複数の列への参照や式を書くことができます。しかし、副問合せや他の集約を書くことはできません。
+式は組込みのデータ型として評価されなければならず、従ってメソッドを呼ぶなら組込みのデータ型に評価されなければなりません。(例えば、<em>java.lang.Integer</em>や<em>int</em>を返すメソッドであるなら、INTEGERと評価されます。)もし式がNULLと評価されるのであれば、その値は集約にて無視されます。</p>
+ 
+<p>型により最小値を決める規則は異なります。CHAR、VARCHARでは、MINの評価結果は値の末尾にある空白文字数に影響されます。
+例えば'z'と'z 'が列に記録されていたとして、どちらの値が最小値として返されるかを決める方法はありません。なぜならば文字列の比較にて空白文字は無視されるからです。</p>
+ 
+<p>結果のデータ型は処理する式のデータ型と同じです。(オーバーフローすることはありません。)</p>
+ </div>
+
+<div class="example"> <pre><strong><span>-- 有効ではありません。</span>
+SELECT DISTINCT flying_time, MIN(DISTINCT miles) from Flights
+<span>-- 有効です。</span>
+SELECT COUNT(DISTINCT flying_time), MIN(DISTINCT miles) from Flights
+<span>-- 最も若い日付を探します。</span>
+SELECT MIN (flight_date) FROM FlightAvailability;</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/rrefsqlj33520.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33562.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33562.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33562.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,1186 @@
+<!--
+  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="CAST 関数" />
+<meta name="abstract" content="CAST関数により値の型を他の型に変換します。また動的な引数(?)やNULL値に型を与えます。" />
+<meta name="description" content="CAST関数により値の型を他の型に変換します。また動的な引数(?)やNULL値に型を与えます。" />
+<meta content="CAST function, conversions, SQL-92 data types using CAST, CAST function (explicit)" name="DC.subject" />
+<meta content="CAST function, conversions, SQL-92 data types using CAST, CAST function (explicit)" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj33562" 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>CAST 関数</title>
+</head>
+<body id="rrefsqlj33562"><a name="rrefsqlj33562"><!-- --></a>
+
+
+<h1 class="topictitle1">CAST 関数</h1>
+
+
+
+<div><p>CAST関数により値の型を他の型に変換します。また動的な引数(?)やNULL値に型を与えます。</p>
+
+<div class="section"> <p>CASTの式は式を置くことができる場所ならどこにでも置くことができます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>CAST ( [ <em>式</em> | NULL | ? ]
+    AS <em>データ型</em>)</strong></pre>
+ 
+<p>式をキャストする先のデータ型のことを<em>目標型</em>といいます。キャストしようとしている式のデータ型のことを<em>源泉型</em>といいます。</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">CASTによるSQL-92 データ型間の変換</h4> 
+<div class="p">以下に示す表はSQLデータ型にて明示的な変換が有効な、源泉型と目標型を示します。
+この表は何れのデータ型の間で明示的な変換が有効なのかを示します。
+表の最初の列は源泉型を示します。表の最初の行は目標型を示します。
+Yは源泉型から目標型への型の変換が有効であることを示します。
+例えば、二行目の最初のコマにより源泉型はSMALLINTと記述されます。
+二行目のほかのコマは、表の最初の行に書かれている型を目標型として、SMALLINTの型を変換できるか否かを記述します。
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92 データ型間にて明示的な変換が有効な、源泉型と目標型</caption>
+<thead align="left">
+<tr>
+<th valign="top" width="17.1875%" id="N10126">Types</th>
+
+<th valign="top" width="4.375%" id="N1012E"> <p>S<br />
+M<br />
+A<br />
+L<br />
+L<br />
+I<br />
+N<br />
+T</p>
+</th>
+
+<th valign="top" width="4.375%" id="N1013C"> <p>I<br />
+N<br />
+T<br />
+E<br />
+G<br />
+E<br />
+R</p>
+</th>
+
+<th valign="top" width="4.375%" id="N1014A"> <p>B<br />
+I<br />
+G<br />
+I<br />
+N<br />
+T</p>
+</th>
+
+<th valign="top" width="4.375%" id="N10158"> <p>D<br />
+E<br />
+C<br />
+I<br />
+M<br />
+A<br />
+L</p>
+</th>
+
+<th valign="top" width="4.21875%" id="N10166"> <p>R<br />
+E<br />
+A<br />
+L</p>
+</th>
+
+<th valign="top" width="4.375%" id="N10174"> <p>D<br />
+O<br />
+U<br />
+B<br />
+L<br />
+E</p>
+</th>
+
+<th valign="top" width="4.375%" id="N10182"> <p>F<br />
+L<br />
+O<br />
+A<br />
+T</p>
+</th>
+
+<th valign="top" width="4.375%" id="N10190"> <p>C<br />
+H<br />
+A<br />
+R</p>
+</th>
+
+<th valign="top" width="4.375%" id="N1019E"> <p>V<br />
+A<br />
+R<br />
+C<br />
+H<br />
+A<br />
+R</p>
+</th>
+
+<th valign="top" width="4.21875%" id="N101AC"> <p>L<br />
+O<br />
+N<br />
+G<br />
+<br />
+V<br />
+A<br />
+R<br />
+C<br />
+H<br />
+A<br />
+R</p>
+</th>
+
+<th valign="top" width="4.375%" id="N101BA"> <p>C<br />
+H<br />
+A<br />
+R<br />
+ <br />
+F<br />
+O<br />
+R<br />
+ <br />
+B<br />
+I<br />
+T<br />
+<br />
+D<br />
+A<br />
+T<br />
+A</p>
+</th>
+
+<th valign="top" width="4.53125%" id="N101C8"> <p>V<br />
+A<br />
+R<br />
+C<br />
+H<br />
+A<br />
+R<br />
+ <br />
+F<br />
+O<br />
+R<br />
+ <br />
+B<br />
+I<br />
+T<br />
+<br />
+D<br />
+A<br />
+T<br />
+A</p>
+</th>
+
+<th valign="top" width="4.21875%" id="N101D6"> <p>L<br />
+O<br />
+N<br />
+G<br />
+ <br />
+V<br />
+A<br />
+R<br />
+C<br />
+H<br />
+A<br />
+R<br />
+ <br />
+F<br />
+O<br />
+R<br />
+ <br />
+B<br />
+I<br />
+T<br />
+<br />
+D<br />
+A<br />
+T<br />
+A</p>
+</th>
+
+<th valign="top" width="4.375%" id="N101E4"> <p>C<br />
+L<br />
+O<br />
+B</p>
+</th>
+
+<th valign="top" width="4.375%" id="N101F2"> <p>B<br />
+L<br />
+O<br />
+B</p>
+</th>
+
+<th valign="top" width="4.375%" id="N10200"> <p>D<br />
+A<br />
+T<br />
+E</p>
+</th>
+
+<th valign="top" width="4.375%" id="N1020E"> <p>T<br />
+I<br />
+M<br />
+E</p>
+</th>
+
+<th valign="top" width="4.375%" id="N1021C"> <p>T<br />
+I<br />
+M<br />
+E<br />
+S<br />
+T<br />
+A<br />
+M<br />
+P</p>
+</th>
+
+<th valign="top" width="4.375%" id="N1022A"> <p>X<br />
+M<br />
+L</p>
+</th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">SMALLINT</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">INTEGER</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">BIGINT</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">DECIMAL</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">REAL</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">DOUBLE</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">FLOAT</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">CHAR</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">VARCHAR</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">LONG VARCHAR</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">CHAR FOR BIT DATA</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">Y</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">VARCHAR FOR BIT DATA</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">Y</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">LONG VARCHAR FOR BIT DATA</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">Y</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">CLOB</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">BLOB</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">DATE</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">TIME</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">TIMESTAMP</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">XML</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">Y</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+<p>変換が有効なら、CASTは可能です。源泉型と目標型の間の大きさの非互換性は、実行時にエラーを起こすことがあります。</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">但し書き</h4> 
+<div class="p">この議論では、<span>Derby</span>にてSQL-92データ型は、以下のように分類されます。<ul>
+<li><em>数</em>   <ul>
+<li>正確な数 (<a href="rrefsqlj16221.html#rrefsqlj16221">SMALLINT</a>, 
+<a href="rrefsqlj10696.html#rrefsqlj10696">INTEGER</a>, 
+<a href="rrefsqlj30435.html#rrefsqlj30435">BIGINT</a>, 
+<a href="rrefsqlj15260.html#rrefsqlj15260">DECIMAL</a>, 
+<a href="rrefsqlj12362.html#rrefsqlj12362">NUMERIC</a>)</li>
+
+<li>近似の数 (<a href="rrefsqlj27281.html#rrefsqlj27281">FLOAT</a>, 
+<a href="rrefsqlj14122.html#rrefsqlj14122">REAL</a>, 
+<a href="rrefsqljdoubleprecision.html#rrefsqljdoubleprecision">DOUBLE PRECISION</a>)</li>
+
+</ul>
+</li>
+
+<li><em>列</em>   <ul>
+<li>文字列 (<a href="rrefclob.html#rrefclob">CLOB</a>, 
+<a href="rrefsqlj13733.html#rrefsqlj13733">CHAR</a>, 
+<a href="rrefsqlj41207.html#rrefsqlj41207">VARCHAR</a>, 
+<a href="rrefsqlj15147.html#rrefsqlj15147">LONG VARCHAR</a>)</li>
+
+<li>ビット列 (<a href="rrefblob.html#rrefblob">BLOB</a>, 
+<a href="rrefsqlj57924.html#rrefsqlj57924">CHAR FOR BIT DATA</a>, 
+<a href="rrefsqlj32714.html#rrefsqlj32714">VARCHAR FOR BIT DATA</a>, 
+<a href="rrefsqlj30118.html#rrefsqlj30118">LONG VARCHAR FOR BIT DATA</a>)</li>
+
+</ul>
+</li>
+
+<li><em>日時</em>   <ul>
+<li><a href="rrefsqlj18730.html#rrefsqlj18730">DATE</a></li>
+
+<li><a href="rrefsqlj21908.html#rrefsqlj21908">TIME</a></li>
+
+<li><a href="rrefsqlj27620.html#rrefsqlj27620">TIMESTAMP</a></li>
+
+</ul>
+</li>
+
+</ul>
+</div>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">数値型からの型変換</h4> 
+<p>数値型は他のいかなる数値型にも変換できます。もし数の小数部ではない部分を切り捨てなければ、変換した目標型で扱えないならば例外が発生します。もし源泉型の小数部を目標型で扱えないならば、目標型にて扱えるよう暗黙裡に源泉型の値は切り捨てられます。たとえば、763.1234をINTEGERに変換すると763となります。</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">ビット列の型への/からの型変換</h4> 
+<p>ビット列の型は他のビット列の型に変換できますが、文字列に変換することはできません。
+文字列の型をビット列の型に変換すると、目標のビット型の長さに会うように、末尾が0で詰められます。BLOB型はより限定されており、明示的な変換を必要とします。 ほとんどの場合、BLOB型からは/へは型変換できません。</p>
+ </div>
+
+<div class="section" id="rrefsqlj33562__sqlj75614"><a name="rrefsqlj33562__sqlj75614"><!-- --></a><h4 class="sectiontitle">日/時の型変換</h4> 
+<p>日/時の値はいかなる場合でもTIMESTAMPへ/から型変換できます。
+DATEがTIMESTAMPに型変換された場合、結果のTIMESTAMPにてTIMEの部分は常に00:00:00です。
+もしTIMEがTIMESTAMPに型変換された場合、結果のTIMESTAMPにてDATEの部分は、CASTが実行されたときのCURRENT_DATEの値となります。
+TIMESTAMPがDATEに型変換される場合、TIMEの部分は暗黙裡に切り捨てられます。
+TIMESTAMPがTIMEに型変換される場合、DATEの部分は暗黙裡に切り捨てられます。
+</p>
+ </div>
+
+<div class="example"> <pre><strong>SELECT CAST (miles AS INT)
+FROM Flights
+-- timestampを文字列に変換する
+INSERT INTO mytable (text_column)
+VALUES (CAST (CURRENT_TIMESTAMP AS VARCHAR(100)))
+-- NULLを適切なデータ型に変換しなければならない。
+SELECT airline
+FROM Airlines
+UNION ALL
+VALUES (CAST (NULL AS CHAR(2)))
+-- doubleをdecimalに変換する。
+SELECT CAST (FLYING_TIME AS DECIMAL(5,2))
+FROM FLIGHTS
+-- SMALLINTをBIGINTに変換する
+VALUES CAST (CAST (12 as SMALLINT) as BIGINT)</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">XML値の変換</h4>
+<p>明示的にも暗黙的にも、XMLの値はXML以外の如何なる型へも型変換できません。XML型を文字列型にする場合は、<a href="rreffuncxmlserialize.html#rreffuncxmlserialize">XMLSERIALIZE 演算子</a>を使ってください。</p>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefsqlj29026.html" title="">組み込み関数</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33562.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33602.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33602.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33602.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,97 @@
+<!--
+  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 節" />
+<meta content="WHERE clause" name="DC.subject" />
+<meta content="WHERE clause" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefclauses.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj33602" 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 節</title>
+</head>
+<body id="rrefsqlj33602"><a name="rrefsqlj33602"><!-- --></a>
+
+
+<h1 class="topictitle1">WHERE 節</h1>
+
+
+<div>
+<div class="section"> <p>WHERE節は必要に応じて、<em><a href="rrefselectexpression.html#rrefselectexpression">選択式</a></em>、<a href="rrefsqlj35981.html#rrefsqlj35981">DELETE 文</a>、<a href="rrefsqlj26498.html#rrefsqlj26498">UPDATE 文</a>に置くことができます。
+WHERE節の真偽式に基づいて行を選択することができます。
+式が真と評価された行だけが、結果にて返されます。
+もし、DELETE文であれば削除され、UPDATE文であれば更新されます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>WHERE <em><a href="rrefsqlj23075.html#rrefsqlj23075">真偽式</a></em></strong></pre>
+ <p>
+WHERE節には真偽式を置くことができます。<a href="rrefsqlj19433.html#rrefsqlj19433__sqlj18370">一般的な式の表</a>に一覧された一般式のほとんどは、真偽値になることができます。</p>
+ 
+<p>さらに、より一般的な真偽式もあります。表10に一覧された真偽演算子は、一つあるいはそれ以上のオペランドをとり、その式は真偽値を返します。</p>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">例</h4><pre><strong>
+<span>-- ビジネスクラスの席が予約されていない
+-- 便を見つける。</span>
+SELECT *
+FROM FlightAvailability
+WHERE business_seats_taken IS NULL
+OR business_seats_taken = 0
+<span>-- EMP_ACTとEMPLOYEEという表を結合して、
+-- EMP_ACTの全列に、EMPLOYEEより従業員の苗字(LASTNAME)を加えて
+-- 結果行として返す。</span>
+SELECT SAMP.EMP_ACT.*, LASTNAME
+  FROM SAMP.EMP_ACT, SAMP.EMPLOYEE
+  WHERE EMP_ACT.EMPNO = EMPLOYEE.EMPNO
+<span>-- 販売代理人の社員番号と給料を、彼らの部署の平均賃金と員数と共に、
+--返す。
+-- この問合せでは、まず問合せの一部(DINFO)にて、AS節で新しい列名を与えて、
+-- AVGSALARYとEMPCOUNT列およびWHERE節で使われているDEPTNOを
+-- 取得できるようにする必要がある。</span>
+SELECT THIS_EMP.EMPNO, THIS_EMP.SALARY, DINFO.AVGSALARY, DINFO.EMPCOUNT
+ FROM EMPLOYEE THIS_EMP,
+   (SELECT OTHERS.WORKDEPT AS DEPTNO,
+           AVG(OTHERS.SALARY) AS AVGSALARY,
+           COUNT(*) AS EMPCOUNT
+    FROM EMPLOYEE OTHERS
+    GROUP BY OTHERS.WORKDEPT
+   )AS DINFO
+ WHERE THIS_EMP.JOB = 'SALESREP'
+	   AND THIS_EMP.WORKDEPT = DINFO.DEPTNO</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/rrefsqlj33602.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33772.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33772.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33772.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="CURRENT_TIME関数" />
+<meta content="CURRENT_TIME function" name="DC.subject" />
+<meta content="CURRENT_TIME function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj33772" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>CURRENT_TIME関数</title>
+</head>
+<body id="rrefsqlj33772"><a name="rrefsqlj33772"><!-- --></a>
+
+
+<h1 class="topictitle1">CURRENT_TIME関数</h1>
+
+
+<div>
+<div class="section"> <p>CURRENT_TIMEは現在の時刻を返します。一つの文の内であれば、関数は何度呼ばれても同じ値を返します。ですから、カーソルで行を拾う間に経過した時間にかかわらず、この関数は一つに決まった値を返します。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">分布</h4> <pre><strong>CURRENT_TIME</strong></pre>
+ <p>あるいは</p>
+ <pre><strong>CURRENT TIME</strong></pre>
+ </div>
+
+<div class="example"> <pre><strong>VALUES CURRENT_TIME
+<span>-- または、</span>
+
+VALUES CURRENT TIME</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/rrefsqlj33772.html
------------------------------------------------------------------------------
    svn:eol-style = native



Mime
View raw message