db-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r854277 [9/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/ref-single.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/ref-single.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/ref-single.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,3500 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
+<html><head><META http-equiv="Content-Type" content="text/html; charset=utf-8"><title>Derby リファレンスマニュアル</title><META content="text/css" http-equiv="Content-Style-Type"><style type="text/css">
+        a { color: black; border: none; text-decoration: none; }
+        img { border: none; }
+      </style></head><body topmargin="6" leftmargin="6" marginheight="6" marginwidth="6" bgcolor="white"><br><div valign="top"><div style="padding: 6pt; border-width: thin; border-color: black; font-family: Helvetica; margin-top: 2pc;"><div style="text-align: right; margin-bottom: 12pc; margin-top: 12pc; line-height: 100%; font-size: 12pt;"><img src="../images/logowithtext.jpg"></div></div><a name="cover"></a><div style="font-family: Helvetica; text-align: left;"><div style="line-height: 140%; font-weight: bold; font-size: 22pt;">Derby リファレンスマニュアル</div><div style="font-style: italic; margin-bottom: 1in; line-height: 140%; font-size: 8pt;">
+          Version 10.4</div></div><div style="line-height: normal; font-size: 8pt; text-align: right; margin-top: 3pc;">
+          Derby Document build: <div>April 14, 2008, 10:01:31 AM (CEST)</div></div></div><br><br><div valign="top"><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em; text-align: center; color: purple;"></div></div><br><br><div valign="top"><div style="font-style: italic; margin-bottom: 1in; line-height: 140%; font-size: 8pt;">
+          Version 10.4
+         &nbsp;
+	Derby リファレンスマニュアル</div></div><div valign="top"><a name="page1-1"></a><div style="font-family: Helvetica; font-size: 10pt; line-height: 12pt;"><div style="font-family: Helvetica; text-align: left;"><div> &nbsp;&nbsp;&nbsp; </div><a name="contents"></a><div style="line-height: 140%; font-weight: bold; font-size: 20pt;">
+              Contents </div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#rrefcopyright"><span style="font-weight: bold;">Copyright</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#rreflicense"><span style="font-weight: bold;">License</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#crefmpref1002477"><span style="font-weight: bold;">この文書について</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#crefmpref11181"><span style="font-weight: bold;">この文書の目的</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#crefmpref23223"><span style="font-weight: bold;">この文書の読者</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left
 : 7.5pc;"><a href="#crefmpref23947"><span style="font-weight: bold;">この文書の構成</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#crefsqlj23296"><span style="font-weight: bold;">SQL言語のリファレンス</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefsqlj28468"><span style="font-weight: bold;">大文字小文字と特殊文字</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#crefsqlj18919"><span style="font-weight: bold;">SQLの識別子 </span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj1003454">SQL92識別子の規則 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj34834">SQL92è­
 ˜åˆ¥å­ &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefcolumnname">列名 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefcorrelationname">相関名 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefnewtablename">新しい表名 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefschemaname">スキーマ名 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsimplecolumnname">単純列名 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsynonymname">別名 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreftablename">表名 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a
  href="#rrefviewname">ビュー名 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefindexname">索引名 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefconstraintname">制約名 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefcursorname">カーソル名 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreftriggername">TriggerName &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefrauthid">認証識別子 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#crefsqlj39374"><span style="font-weight: bold;">文</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj22771">依存関係 &nbsp;&nbsp;&nbsp; <sp
 an>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj81859">ALTER TABLE 文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefcallprocedure">CALL (手続き) 文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj95081">CREATE 文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefdeclaretemptable">DECLARE GLOBAL TEMPORARY TABLE 文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj35981">DELETE 文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj80721">DROP文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqljgrant">GRANT 文  &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj40774">INSERT 文 &nbsp;&nbsp
 ;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj40506">LOCK TABLE 文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqljrenamestatements">RENAME 文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqljrevoke">REVOKE 文  &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj35312">SET 文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj41360">SELECT 文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj26498">UPDATE文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefclauses"><span style="font-weight: bold;">SQL 節</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj13590">CONSTRAINT 節 &n
 bsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj31783">FOR UPDATE 節 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj21583">FROM 節 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj32654">GROUP BY 節 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj14854">HAVING 節 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj13658">ORDER BY 節 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj33602">WHERE 節 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj15309">WHERE CURRENT OF 節 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefsqlj19433"><span style="font-weight: bold;">SQL式</
 span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefselectexpression">選択式 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreftableexpression">TableExpression &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj11277">VALUES式 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj1080779">式に関する優先順位 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj23075">真偽式 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj29911">動的パラメータ &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefsqlj29840"><span style="font-weight: bold;">JOIN 演算</span> &nbsp;&nbsp;&nb
 sp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj35034">INNER JOIN 演算 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj18922">LEFT OUTER JOIN演算 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj57522">RIGHT OUTER JOIN 演算 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefqueries"><span style="font-weight: bold;">SQL 問い合わせ</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj21571">問合せ &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefscalarsubquery">スカラー副問合せ &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreftablesubquery">表副問合せ &nbsp;&nbsp
 ;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefsqlj29026"><span style="font-weight: bold;">組み込み関数</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj55788">標準組込み関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj33923">集約 (集合関数) &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj98067">ABSとABSVAL関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncacos">ACOS 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncasin">ASIN 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncatan">ATAN 関数 &nbsp;&nbsp;&nbsp; <span>&bull;
 </span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj32693">AVG関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefbuiltbigint">BIGINT関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefcase">CASE 式 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj33562">CAST 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncceil">CEILおよびCEILING関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefbuiltchar">CHAR 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj40899">Concatenation &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffunccos">COS 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span>
 </a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj38716">COUNT 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj66113">COUNT(*) 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqljcurrentdate">CURRENT DATE 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj34177">CURRENT_DATE関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefcurrentisolation">CURRENT ISOLATION 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqljcurrentschema">CURRENT SCHEMA関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj1055824">CURRENT TIME &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj33772">CURRENT_T
 IME関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqljcurrenttimestamp">CURRENT TIMESTAMP関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj15866">CURRENT_TIMESTAMP関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj42324">CURRENT_USER関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefdatefunc">DATE関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefdayfunc">DAY 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncdegrees">DEGREES 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefbuiltdouble">DOUBLE関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9
 pc;"><a href="#rreffuncexp">EXP関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncfloor">FLOOR関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefhourfunc">HOUR関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefidentityvallocal">IDENTITY_VAL_LOCAL関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefbuiltinteger">INTEGER関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj42049">LCASEあるいはLOWER関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj16762">LENGTH関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffunclog">LNあるいはLOG関数 &nbsp;&nbsp;&nbs
 p; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffunclog10">LOG10 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj61998">LOCATE関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj97870">LTRIM関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj27781">MAX関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj33520">MIN関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefminutefunc">MINUTE 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqljmod">MOD関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefmonthfunc">MONTH関数 &nbsp;&nbsp;&nbsp; <span>&bull;<
 /span></a></div><div style="margin-left: 9pc;"><a href="#rrefcasenullif">NULLIF式 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncpi">PI 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncradians">RADIANS 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj32613">RTRIM関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsecondfunc">SECOND関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj25228">SESSION_USER関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncsin">SIN 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefbuiltsmallint">SMALLINT関数 &nbsp;&nbsp;&nbsp; <span>&bull;</spa
 n></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj73147">SQRT関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj93082">SUBSTR関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj13083">SUM関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffunctan">TAN 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreftimefunc">TIME 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreftimestampfunc">TIMESTAMP関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreftrimfunc">TRIM 関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj29930">UCASE関数およびUPPER関数 &nbsp;&nbsp;&
 nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj42476">USER関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefbuiltvarchar">VARCHAR関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncxmlexists">XMLEXISTS 演算子 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncxmlparse">XMLPARSE演算子 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncxmlquery">XMLQUERY演算子 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncxmlserialize">XMLSERIALIZE 演算子 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefyearfunc">YEAR関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a hr
 ef="#crefsqlbuiltinsystemfunctions"><span style="font-weight: bold;">組込みシステム関数</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsyscschecktablefunc">SYSCS_UTIL.SYSCS_CHECK_TABLEシステム関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefgetdbpropfunc">SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTYシステム関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsyscsruntimestatsfunc">SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS システム関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlbuiltinsystemprocedures">組み込みシステム手続き &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsyscsdialgtables">SYSCS
 _DIAG 診断表および関数 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj31068">データ型 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefkeywords29722"><span style="font-weight: bold;">SQL予約語</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefsql9241891"><span style="font-weight: bold;">DerbyのサポートするSQL-92の機能</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefsistabs38369"><span style="font-weight: bold;">Derbyのシステム表</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs28114">SYSALIASES システム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9
 pc;"><a href="#rrefsistabs26665">SYSCHECKSシステム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabssyscolperms">SYSCOLPERMS システム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs22441">SYSCOLUMNSシステム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs39391">SYSCONGLOMERATES システム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs23241">SYSCONSTRAINTS システム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs12813">SYSDEPENDS システム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs40972">SYSFILESシステム表 &nbsp;&nb
 sp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs13420">SYSFOREIGNKEYSシステム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs33921">SYSKEYSシステム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabssysroutineperms">SYSROUTINEPERMS システム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs12085">SYSSCHEMAS システム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabslilanguageitemsysstatistics">SYSSTATISTICSシステム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs33768">SYSSTATEMENTSシステム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="marg
 in-left: 9pc;"><a href="#rrefsistabssystableperms">SYSTABLEPERMS システム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs24269">SYSTABLES システム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs79888">SYSTRIGGERSシステム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs24045">SYSVIEWS システム表 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefexcept16677"><span style="font-weight: bold;">Derbyの例外メッセージとSQL state</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefexcept71493">SQLのエラーメッセージと例外 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><d
 iv style="margin-left: 7.5pc;"><a href="#crefjdbc12657"><span style="font-weight: bold;">JDBC リファレンス</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#crefjdbc25142">java.sqlにある、JDBCの主なクラス、 インターフェイス、メソッド &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc32052">java.sql.Driverインターフェイス &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc34565">java.sql.DriverManager.getConnection メソッド &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc27734">java.sql.Connection インターフェイス &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a 
 href="#rrefjdbc15905">java.sql.DatabaseMetaData インターフェイス &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc40794">java.sql.Statementインターフェイス &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc20485">java.sql.CallableStatement インターフェイス &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc16643">java.sql.SQLException クラス &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc29874">java.sql.PreparedStatementインターフェイス &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc23502">java.sql.ResultSet インターフェイス &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></d
 iv><div style="margin-left: 9pc;"><a href="#rrefjdbc38274">java.sql.ResultSetMetaData インターフェイス &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc30469">java.sql.SQLWarning クラス &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcrefsqlxml">java.sql.SQLXMLインターフェイス &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc20377">SQL型とjava.sql.Typesの対応 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc2_0summary">JDBC 2.0 の機能 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc80004">java.sql.Connection インターフェイス: JDBC 2.0で利用可能なメソッド &nbsp;&
 nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc66688">java.sql.DatabaseMetaData インターフェイス: 利用可能なJDBC 2.0のメソッド &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc99392">java.sql.PreparedStatementインターフェイス: JDBC2.0で提供されるメソッド &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc77156">java.sql.ResultSet &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc71949">java.sql.ResultSetMetaData インターフェイス: JDBC 2.0で利用可能なメソッド &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc59162">java.sql.Statement ã
 ¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹: 利用可能なJDBC 2.0のメソッド &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefjdbc87220"><span style="font-weight: bold;">java.sql.BatchUpdateException クラス</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefjdbcjsr169"><span style="font-weight: bold;">Connected Device ConfigurationおよびFoundation Profile向けのJDBCパッケージ(JSR169)</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefjdbc32593"><span style="font-weight: bold;">JDBC 3.0の機能</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcjavasqlconnection30">java.sql.Connectionインターフェイス: JDBC3.0にて利用可能
 ªãƒ¡ã‚½ãƒƒãƒ‰  &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcdatabasemetadata30">java.sql.DatabaseMetaData インターフェイス: JDBC 3.0で利用可能なメソッド &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcparametermetadata30">java.sql.ParameterMetaDataインターフェイス:JDBC3.0で利用可能なメソッド  &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcjavasqlpreparedstatement30">java.sql.PreparedStatementインターフェイス: JDBC3.0で利用可能なメソッド &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcjavasqlsavepoint">java.sql.Savepoint インターフ
 ‚§ã‚¤ã‚¹ &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcjavasqlstatement30">java.sql.Statementインターフェイス: JDBC 3.0で利用可能なメソッド &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefjdbc4_0summary"><span style="font-weight: bold;">JDBC 4.0の機能</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc4_0sqlexception">洗練されたSQLExceptionのサブクラス &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc4_0connection">java.sql.Connectionインターフェイス:JDBC4.0で提供される機能 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc4_0databaseMe
 taData">java.sql.DatabaseMetaDataインターフェイス: JDBC4.0の機能 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc4_0statement">java.sql.Statementインターフェイス: JDBC 4.0で利用可能な機能 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc4_0dataSource">javax.sql.DataSource インターフェイス: JDBC 4.0の機能 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefjdbc1020262"><span style="font-weight: bold;">JDBCエスケープの構文</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc70824">呼び出し文のJDBCエスケープキーワード &nbsp;&nbsp;&nbsp; <span>&bu
 ll;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc27768">JDBCエスケープ構文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc28456">LIKE節のJDBCエスケープ構文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc88908">fnキーワードを使ったJDBCエスケープ構文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc37244">外部結合のJDBCエスケープ構文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc12124">時刻書式のJDBCエスケープ構文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcescapedate">日付書å
 ã®JDBCエスケープ構文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc41784">タイムスタンプ書式のJDBCエスケープ構文 &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#rrefattrib24612"><span style="font-weight: bold;">データベース接続URLに属性を指定する。</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib42100"><span style="font-weight: bold;">bootPassword=key属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribcollation"><span style="font-weight: bold;">collation=collation 属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href=
 "#rrefattrib26867"><span style="font-weight: bold;">create=true 属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefcreatefrom"><span style="font-weight: bold;">createFrom=Path属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib17246"><span style="font-weight: bold;">databaseName=nameofDatabase属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib15290"><span style="font-weight: bold;">dataEncryption=true属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribencryptkey"><span style="font-weight: bold;">encryptionKey=key属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib88843"><span style="font-weight: bold;">encryptionProvider=providerName属
 €§</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib60346"><span style="font-weight: bold;">encryptionAlgorithm=algorithm 属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib72457"><span style="font-weight: bold;">logDevice=logDirectoryPath 属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribnewencryptkey"><span style="font-weight: bold;">newEncryptionKey=key 属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribnewbootpw"><span style="font-weight: bold;">newBootPassword=newPassword 属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib42686"><span style="font-weight: bold;">password=userPassword</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></
 div><div style="margin-left: 7.5pc;"><a href="#rrefrestorefrom"><span style="font-weight: bold;">restoreFrom=path属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefrollforward"><span style="font-weight: bold;">rollForwardRecoveryFrom=path 属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib16471"><span style="font-weight: bold;">shutdown=true属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib56769"><span style="font-weight: bold;">territory=ll_CC 属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribtracedirectory"><span style="font-weight: bold;">traceDirectory=path 属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribtracefile"><span style="
 font-weight: bold;">traceFile=path 属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribtracefileappend"><span style="font-weight: bold;">traceFileAppend=true 属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribtracelevel"><span style="font-weight: bold;">traceLevel=value 属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribupgrade"><span style="font-weight: bold;">upgrade=true attribute</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib10035"><span style="font-weight: bold;">user=userName 属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribssl"><span style="font-weight: bold;">ssl=sslMode 属性</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></
 a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib34183"><span style="font-weight: bold;">属性を指定せずにデータベースに接続する</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#rrefjta16677"><span style="font-weight: bold;">J2EEへの準拠:Java Transaction APIとjavax.sql インターフェイス</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefjta51021"><span style="font-weight: bold;">JTA API </span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjta1003392">製品に関する但し書き &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefjta18596"><span style="font-weight: bold;">javax.sql:JDBCインタ
 ーフェイス</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#rrefapi10613"><span style="font-weight: bold;">Derby API</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefapi24806"><span style="font-weight: bold;">スタンドアローンのツールとユーティリティ</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefapi19690"><span style="font-weight: bold;">JDBCの実装クラス</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefapi33761">JDBC driver &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefapi1003363">データソースのクラス &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></di
 v><div style="margin-left: 7.5pc;"><a href="#rrefapi1005026"><span style="font-weight: bold;">ユーティリティ的なインターフェイス</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#rrefsqlj75638"><span style="font-weight: bold;">利用可能な地域情報</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#rreflimits"><span style="font-weight: bold;">Derbyの制限事項</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefdbmlimits"><span style="font-weight: bold;">データベース設定値の制限</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefdttlimits"><span style="font-weight: bold;">DATE、TIM
 EとTIMESTAMPの制限</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefidlengthlimits"><span style="font-weight: bold;">識別子の長さ制限</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefnumericlimits"><span style="font-weight: bold;">数値の制限</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefstringlimits"><span style="font-weight: bold;">並びの制限</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 7.5pc;"><a href="#rreflimitsxml"><span style="font-weight: bold;">XMLの制限</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#rreftrademderby"><span style="font-weight: bold;">Trademarks</span> &nbsp;&nbsp;&nbsp; <span>&bull;</span></a>
 </div></div></div></div><div valign="top"><div style="font-family: Helvetica; font-weight: bold; font-size: 10pt; text-align: center;"><span>&bull;</span></div></div><br><br><div valign="top"><div style="line-height: 8pt; font-size: 8pt;">Derby リファレンスマニュアル</div></div><div valign="top"><div style="font-family: Helvetica; font-size: 10pt; text-align: left;">Apache Software FoundationDerby リファレンスマニュアルApache Derby<div><a name="N1003D"></a><div style="margin-top: 0pc; margin-bottom: 1.4pc; font-size: 16pt; font-weight: bold; padding-top: 1.4pc;"><div style="border-right-width: 0pt; border-left-width: 0pt; line-height: 100%; border-top-width: 3pt; border-top-color: black;"><a name="rrefcopyright"></a><div></div>Copyright</div></div><div style="margin-left: 72pt; font-size: 10pt;"><div style="line-height: 12pt; margin-top: 0.6em; font-size: 10pt;"><a name="N10046"></a><span
 ></span><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;"><img src="../images/logowithtext.jpg"></div><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;">Copyright 2004-2008 The Apache Software Foundation</div><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;"> Licensed
+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 <span style="color: blue;"><a href="http://www.apache.org/licenses/LICENSE-2.0">http://www.apache.org/licenses/LICENSE-2.0</a></span>.</div></div><div style="line-height: 12pt; margin-top: 0.6em; font-size: 10pt;"><a name="N1006C"></a><span></span><div style="font-weight: bold;">Related information</div><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;"><span style="color: blue;"><a href="#rreflicense">License</a></span></div></div></div></div><div><a name="N1008A"></a><div style="margin-top: 0pc; margin-bottom: 1.4pc; font-size: 16pt; font-weight: bold; padding-top: 1.4pc;"><div style="border-right-width: 0pt; border-left-width: 0pt; line-height: 100%; border-top-width: 3pt; border-top-color: black;"><a name="rreflicense"></a><div></div>License</div></div><div style="margin-left: 72pt; font-size: 10pt;"><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em; margin-left: 72pt;"></div><div style="line-h
 eight: 12pt; margin-top: 0.6em; font-size: 10pt;"><a name="N100AD"></a><span></span><div style="font-weight: bold;">The Apache License, Version 2.0</div><pre><div style="margin-top: 1.2em; margin-bottom: 0.8em; background-color: #f0f0f0; font-family: Courier; line-height: 106%; font-size: 9pt;">
+                               Apache License
+                           Version 2.0, January 2004
+                        http://www.apache.org/licenses/
+
+   TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION
+
+   1. Definitions.
+
+      "License" shall mean the terms and conditions for use,
+      reproduction, and distribution as defined by Sections 1 through
+      9 of this document.
+
+      "Licensor" shall mean the copyright owner or entity authorized
+      by the copyright owner that is granting the License.
+
+      "Legal Entity" shall mean the union of the acting entity and all
+      other entities that control, are controlled by, or are under
+      common control with that entity. For the purposes of this
+      definition, "control" means (i) the power, direct or indirect,
+      to cause the direction or management of such entity, whether by
+      contract or otherwise, or (ii) ownership of fifty percent (50%)
+      or more of the outstanding shares, or (iii) beneficial ownership
+      of such entity.
+
+      "You" (or "Your") shall mean an individual or Legal Entity
+      exercising permissions granted by this License.
+
+      "Source" form shall mean the preferred form for making
+      modifications, including but not limited to software source code,
+      documentation source, and configuration files.
+
+      "Object" form shall mean any form resulting from mechanical
+      transformation or translation of a Source form, including but
+      not limited to compiled object code, generated documentation,
+      and conversions to other media types.
+
+      "Work" shall mean the work of authorship, whether in Source or
+      Object form, made available under the License, as indicated by a
+      copyright notice that is included in or attached to the work
+      (an example is provided in the Appendix below).
+
+      "Derivative Works" shall mean any work, whether in Source or
+      Object form, that is based on (or derived from) the Work and
+      for which the editorial revisions, annotations, elaborations,
+      or other modifications represent, as a whole, an original work
+      of authorship.  For the purposes of this License, Derivative
+      Works shall not include works that remain separable from, or
+      merely link (or bind by name) to the interfaces of, the Work
+      and Derivative Works thereof.
+
+      "Contribution" shall mean any work of authorship, including
+      the original version of the Work and any modifications or
+      additions to that Work or Derivative Works thereof, that is
+      intentionally submitted to Licensor for inclusion in the Work
+      by the copyright owner or by an individual or Legal Entity
+      authorized to submit on behalf of the copyright owner. For the
+      purposes of this definition,
+      "submitted" means any form of electronic, verbal, or written
+      communication sent to the Licensor or its representatives,
+      including but not limited to communication on electronic mailing
+      lists, source code control systems, and issue tracking systems
+      that are managed by, or on behalf of, the Licensor for the
+      purpose of discussing and improving the Work, but excluding
+      communication that is conspicuously marked or otherwise
+      designated in writing by the copyright owner as "Not a
+      Contribution."
+
+      "Contributor" shall mean Licensor and any individual or Legal
+      Entity on behalf of whom a Contribution has been received by
+      Licensor and subsequently incorporated within the Work.
+
+   2. Grant of Copyright License. Subject to the terms and conditions
+      of this License, each Contributor hereby grants to You a
+      perpetual, worldwide, non-exclusive, no-charge, royalty-free,
+      irrevocable copyright license to reproduce, prepare Derivative
+      Works of, publicly display, publicly perform, sublicense, and
+      distribute the Work and such Derivative Works in Source or
+      Object form.
+
+   3. Grant of Patent License. Subject to the terms and conditions of
+      this License, each Contributor hereby grants to You a perpetual,
+      worldwide, non-exclusive, no-charge, royalty-free, irrevocable
+      (except as stated in this section) patent license to make, have
+      made, use, offer to sell, sell, import, and otherwise transfer
+      the Work, where such license applies only to those patent claims
+      licensable by such Contributor that are necessarily infringed by
+      their Contribution(s) alone or by combination of their
+      Contribution(s) with the Work to which such Contribution(s) was
+      submitted. If You institute patent litigation against any entity
+      (including a cross-claim or counterclaim in a lawsuit) alleging
+      that the Work or a Contribution incorporated within the Work
+      constitutes direct or contributory patent infringement, then any
+      patent licenses granted to You under this License for that Work
+      shall terminate as of the date such litigation is filed.
+
+   4. Redistribution. You may reproduce and distribute copies of the
+      Work or Derivative Works thereof in any medium, with or without
+      modifications, and in Source or Object form, provided that You
+      meet the following conditions:
+
+      (a) You must give any other recipients of the Work or
+          Derivative Works a copy of this License; and
+
+      (b) You must cause any modified files to carry prominent notices
+          stating that You changed the files; and
+
+      (c) You must retain, in the Source form of any Derivative Works
+          that You distribute, all copyright, patent, trademark, and
+          attribution notices from the Source form of the Work,
+          excluding those notices that do not pertain to any part of
+          the Derivative Works; and
+
+      (d) If the Work includes a "NOTICE" text file as part of its
+          distribution, then any Derivative Works that You distribute
+          must include a readable copy of the attribution notices
+          contained within such NOTICE file, excluding those notices
+          that do not pertain to any part of the Derivative Works, in
+          at least one of the following places: within a NOTICE text
+          file distributed as part of the Derivative Works; within the
+          Source form or documentation, if provided along with the
+          Derivative Works; or, within a display generated by the
+          Derivative Works, if and wherever such third-party notices
+          normally appear. The contents of the NOTICE file are for
+          informational purposes only and do not modify the License.
+          You may add Your own attribution notices within Derivative
+          Works that You distribute, alongside or as an addendum to
+          the NOTICE text from the Work, provided that such additional
+          attribution notices cannot be construed as modifying the
+          License.
+
+      You may add Your own copyright statement to Your modifications
+      and may provide additional or different license terms and
+      conditions for use, reproduction, or distribution of Your
+      modifications, or for any such Derivative Works as a whole,
+      provided Your use, reproduction, and distribution of the Work
+      otherwise complies with the conditions stated in this License.
+
+   5. Submission of Contributions. Unless You explicitly state
+      otherwise, any Contribution intentionally submitted for
+      inclusion in the Work by You to the Licensor shall be under the
+      terms and conditions of this License, without any additional
+      terms or conditions.  Notwithstanding the above, nothing herein
+      shall supersede or modify the terms of any separate license
+      agreement you may have executed with Licensor regarding such
+      Contributions.
+
+   6. Trademarks. This License does not grant permission to use the
+      trade names, trademarks, service marks, or product names of the
+      Licensor, except as required for reasonable and customary use
+      in describing the origin of the Work and reproducing the content
+      of the NOTICE file.
+
+   7. Disclaimer of Warranty. Unless required by applicable law or
+      agreed to in writing, Licensor provides the Work (and each
+      Contributor provides its Contributions) on an "AS IS" BASIS,
+      WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
+      implied, including, without limitation, any warranties or
+      conditions of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or
+      FITNESS FOR A PARTICULAR PURPOSE. You are solely responsible for
+      determining the appropriateness of using or redistributing the
+      Work and assume any risks associated with Your exercise of
+      permissions under this License.
+
+   8. Limitation of Liability. In no event and under no legal theory,
+      whether in tort (including negligence), contract, or otherwise,
+      unless required by applicable law (such as deliberate and
+      grossly negligent acts) or agreed to in writing, shall any
+      Contributor be liable to You for damages, including any direct,
+      indirect, special, incidental, or consequential damages of any
+      character arising as a result of this License or out of the use
+      or inability to use the Work (including but not limited to
+      damages for loss of goodwill, work stoppage, computer failure or
+      malfunction, or any and all other commercial damages or losses),
+      even if such Contributor has been advised of the possibility of
+      such damages.
+
+   9. Accepting Warranty or Additional Liability. While redistributing
+      the Work or Derivative Works thereof, You may choose to offer,
+      and charge a fee for, acceptance of support, warranty, indemnity,
+      or other liability obligations and/or rights consistent with this
+      License. However, in accepting such obligations, You may act only
+      on Your own behalf and on Your sole responsibility, not on behalf
+      of any other Contributor, and only if You agree to indemnify,
+      defend, and hold each Contributor harmless for any liability
+      incurred by, or claims asserted against, such Contributor by
+      reason of your accepting any such warranty or additional
+      liability.
+
+   END OF TERMS AND CONDITIONS
+
+   APPENDIX: How to apply the Apache License to your work.
+
+      To apply the Apache License to your work, attach the following
+      boilerplate notice, with the fields enclosed by brackets "[]"
+      replaced with your own identifying information. (Don't include
+      the brackets!)  The text should be enclosed in the appropriate
+      comment syntax for the file format. We also recommend that a
+      file or class name and description of purpose be included on the
+      same "printed page" as the copyright notice for easier
+      identification within third-party archives.
+
+   Copyright [yyyy] [name of copyright owner]
+
+   Licensed 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.
+</div></pre></div></div></div><div><a name="N100D0"></a><div style="margin-top: 0pc; margin-bottom: 1.4pc; font-size: 16pt; font-weight: bold; padding-top: 1.4pc;"><div style="border-right-width: 0pt; border-left-width: 0pt; line-height: 100%; border-top-width: 3pt; border-top-color: black;"><a name="crefmpref1002477"></a><div></div>この文書について</div></div><div style="margin-left: 72pt; font-size: 10pt;"><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;"><span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>の文書については、<span style="font-style: italic;"><span style="border-right-width: 0pt; border-left-width: 0pt;"><span style="font-style: italic;">はじめてのDerby</span></span></span>を参照してください。文書の一覧や、文書の体裁上ã
 ®å–り決め、詳細が書かれています。</div></div><div><a name="N1012D"></a><div style="padding-top: 1pc; margin-bottom: 5pt; font-size: 14pt; font-weight: bold;"><div style="border-right-width: 0pt; border-left-width: 0pt; border-top-width: 1pt; border-top-color: black;"><a name="crefmpref11181"></a><div></div>この文書の目的</div></div><div style="margin-left: 72pt; font-size: 10pt;"><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;">この<span style="font-style: italic;"><span style="border-right-width: 0pt; border-left-width: 0pt;"><span style="font-style: italic;">Derby リファレンスマニュアル</span></span></span>は、<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>のリファレンスです。
+この文書には、<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>のSQL言語や、<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>におけるJDBCの実装、<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>のシステムカタログ、<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>のエラーメッセージ、<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>の属性や、SQLのキーワードの説明があります。</div></div></div><div><a name="N101A4"></a><div style="padding-top: 1pc; margin-bottom: 5pt; font-size: 14pt; font-weight: bold;"><div style="border-right-width: 0pt; border-left-width: 0pt; border-top-width: 1pt; border-top-color: black;"><a 
 name="crefmpref23223"></a><div></div>この文書の読者</div></div><div style="margin-left: 72pt; font-size: 10pt;"><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;">この文書は、<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>を使う人のためのリファレンスです。特にアプリケーションの開発者に向けて書かれています。
+SQLの標準やJavaというプログラミング言語に慣れていない<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>のユーザは、このリファレンスの対応する項目を読めば得られる情報があるでしょう。</div><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;">「<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>で、こういうことをするにはどうすればよいのか」とか、<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>の概念とかを知りたいならば、<span style="font-style: italic;"><span styl
 e="border-right-width: 0pt; border-left-width: 0pt;"><span style="font-style: italic;">Derby ディベロッパーズ ガイド</span></span></span>を読むと良いでしょう。</div></div></div><div><a name="N10214"></a><div style="padding-top: 1pc; margin-bottom: 5pt; font-size: 14pt; font-weight: bold;"><div style="border-right-width: 0pt; border-left-width: 0pt; border-top-width: 1pt; border-top-color: black;"><a name="crefmpref23947"></a><div></div>この文書の構成</div></div><div style="margin-left: 72pt; font-size: 10pt;"><div style="font-size: 10pt; text-indent: 0em; margin-top: 0em; margin-bottom: 0.6em;">この文書には以下の節があります。
+<div><table width="100%"><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div><span style="font-style: italic;"><span style="color: blue;"><a href="#crefsqlj23296">SQL言語のリファレンス</a></span></span><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;"><span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>のSQL言語のリファレンスです。
+文、関数、そのほかの構文上の情報が書かれています。</div></div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div><span style="font-style: italic;"><span style="color: blue;"><a href="#rrefkeywords29722">SQL予約語</a></span></span><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;">SQL-92標準外の、SQLのキーワードを説明します。</div></div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div><span style="font-style: italic;"><span style="color: blue;"><a href="#rrefsql9241891">DerbyのサポートするSQL-92の機能</a></span></span><d
 iv style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;">SQL-92の機能のうち、<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>が実現しているものと実現していないものを一覧します。</div></div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div><span style="font-style: italic;"><span style="color: blue;"><a href="#rrefsistabs38369">Derbyのシステム表</a></span></span><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;"><span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>のシステムカタログのリファレンスです。</div></div></td></tr><tr><td vali
 gn="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div><span style="font-style: italic;"><span style="color: blue;"><a href="#rrefexcept16677">Derbyの例外メッセージとSQL state</a></span></span><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;"><span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>の例外メッセージについての情報が書かれています。</div></div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div><span style="font-style: italic;"><span style="color: blue;"><a href="#crefjdbc12657">JDBC リファレンス</a></span></span><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; marg
 in-bottom: 0.6em;"><span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>が実装するJDBCのインターフェイスの情報がJDBC 2.0 の機能も含めて書かれています。</div></div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div><span style="font-style: italic;"><span style="color: blue;"><a href="#rrefattrib24612">データベース接続URLに属性を指定する。</a></span></span><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;"><span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>のJDBCデータベース接続URLにおいて、実現されている属性
 ®æƒ…報が書かれています。</div></div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div><span style="font-style: italic;"><span style="color: blue;"><a href="#rrefjta16677">J2EEへの準拠:Java Transaction APIとjavax.sql インターフェイス</a></span></span><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;">Java Transaction APIにおいて、<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>が実現している機能について書かれています。</div></div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div><span style="font-style: italic;"><s
 pan style="color: blue;"><a href="#rrefapi10613">Derby API</a></span></span><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;"><span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>独自のAPIについての説明があります。</div></div></td></tr></table></div></div></div></div></div><div><a name="N1033B"></a><div style="margin-top: 0pc; margin-bottom: 1.4pc; font-size: 16pt; font-weight: bold; padding-top: 1.4pc;"><div style="border-right-width: 0pt; border-left-width: 0pt; line-height: 100%; border-top-width: 3pt; border-top-color: black;"><a name="crefsqlj23296"></a><div></div>SQL言語のリファレンス</div></div><div style="margin-left: 72pt; font-size: 10pt;"><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;"><span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>は
 SQL-92のうち主要な機能のサブセットおよび、幾つかのSQL-99の機能を実現しています。</div><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;">この節では、文、組み込み関数、データ型、式、特殊文字などの説明を通して、SQL言語の概観を紹介します。</div></div><div><a name="N1045E"></a><div style="padding-top: 1pc; margin-bottom: 5pt; font-size: 14pt; font-weight: bold;"><div style="border-right-width: 0pt; border-left-width: 0pt; border-top-width: 1pt; border-top-color: black;"><a name="rrefsqlj28468"></a><div></div>大文字小文字と特殊文字</div></div><div style="margin-left: 72pt; font
 -size: 10pt;"><div style="line-height: 12pt; margin-top: 0.6em; font-size: 10pt;"><a name="N104D2"></a><span></span><div style="font-size: 10pt; text-indent: 0em; margin-top: 0em; margin-bottom: 0.6em;">JDBCのクラスやメソッドにSQL文の文字列を渡して、<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>にSQLを発行することができます。
+SQL文の文字列に可能な文字セットはUnicodeです。この文字列には、次の規則が適用されます。<div><table width="100%"><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div>二重引用符でSQL-92に定義されている特殊識別子をデリミトして、<span style="font-style: italic;">デリミトされた識別子</span>とすることができます。</div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div>一重引用符で文字の列を区切るこã
 ¨ãŒã§ãã¾ã™ã€‚</div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div>文字の列にて一重引用符またはアポストロフィーをあらわすには、一重引用符を2つ並べます。(言い方を変えれば、一重引用符は一重引用符のエスケープ文字です。)<div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;">二重引用符にはエスケープ文字が必要ではありません。二重引用符をあらわすには、単に二重引ç”
 符を使ってください。ただし、Javaのプログラムでは、二重引用符はバックスラッシュによるエスケープが必要であることを気に留める必要があります。</div><span style="border-right-width: 0pt; border-left-width: 0pt;"><span style="font-weight: bold;">例:</span></span><pre><div style="margin-top: 1.2em; margin-bottom: 0.8em; background-color: #f0f0f0; font-family: Courier; line-height: 106%; font-size: 9pt;"><span style="font-weight: bold;"><span style="border-right-width: 0pt; border-left-width: 0pt;">-- 一重引用符はエスケープ文字です-- 一重引用符に対して</span>
+
+VALUES 'Joe''s umbrella'
+<span style="border-right-width: 0pt; border-left-width: 0pt;">-- ijでは二重引用符はエスケープされません。</span>
+VALUES 'He said, "hello!"'
+
+n = stmt.executeUpdate(
+    "UPDATE aTable setStringcol = 'He said, \"hello!\"'");</span></div></pre></div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div>SQLのキーワードは大文字小文字を区別しません。例えば、SELECTというキーワードは、SELECT、Select、select、sELECTのいずれでも書くことができます。</div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div>SQL-92の書き方による識別子は大文字小文字を区別しません。(<span style="font-style: italic;"><span style="color: blue;"><a href="#crefsqlj34834
 ">SQL92識別子</a></span></span>を参照してください。)ただしデリミトされた識別子はそうではありません。</div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div>Javaの書き方による識別子は常に大文字小文字を区別します。</div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div>*は、<span style="font-style: italic;"><span style="color: blue;"><a href="#rrefselectexpression">SelectExpression</a></span>.</span>にてワイルドカード文字です。<span style="color: blue;"><a href="#sqlj3
 8441">ワイルドカードの*</a></span>を参照してください。
+この文字は同時に情報演算子でもあります。そのほかの場合この文字は、0回以上の繰り返しを表す、構文のメタ文字です。</div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div>%と_は、LIKE演算子に続く文字の列にて使われると、ワイルドカード文字となります。(これはエスケープされなかった場合です。)詳細は<span style="color: blue;"><a href="#rrefsqlj23075">真偽式</a></span>を参照してください。</di
 v></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>&bull;</span></div></td><td width="8">&nbsp;</td><td valign="top"><div>SQL-92の仕様に沿って一行あるいは複数行のコメントを書くことができます。一行のコメントは二つのダッシュ(--)で始まり改行文字で終わります。複数行の改行は前後を囲う書き方で、スラッシュ・スター(/*)で始まり、スター・スラッシュ(*/)で終わります。この書き方では入れ子となる場合があることを留意してくだã
 •ã„。コメントの開始文字と終了文字の間にある、あらゆる文字は無視されます。</div></td></tr></table></div></div></div></div></div><div><a name="N10669"></a><div style="padding-top: 1pc; margin-bottom: 5pt; font-size: 14pt; font-weight: bold;"><div style="border-right-width: 0pt; border-left-width: 0pt; border-top-width: 1pt; border-top-color: black;"><a name="crefsqlj18919"></a><div></div>SQLの識別子 </div></div><div style="margin-left: 72pt; font-size: 10pt;"><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;"><span style="font-style: italic;">識別子</span>とは、ある言語においてキーワードやコマンドとは異なる、ユーザが作成した情
 報をあらわすものです。識別子は表、ビュー、索引、列、制約のような、ユーザがデータベースに作成した<span style="font-style: italic;">ディクショナリの情報</span>をあらわすことがあります。ここで、これらの情報をディクショナリの情報とわれわれが呼ぶのは、<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>がデータディクショナリとも呼ばれる、システム表にこれらの情報を記録するからです。
+SQLの仕様は、こういった情報を特定の文で別名により扱う方法を用意しています。</div><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;">識別子は、その種類に応じてそれぞれの規則にそっていなければなりません。ディクショナリの情報の識別子の場合、SQL-92が定義する識別子の規則に沿わなければなりません。このことより、ディクショナリの情報の識別子のことを<span style="font-style: italic;"><span style="color: blu
 e;"><a href="#crefsqlj34834">SQL92識別子</a></span></span>と呼びます。.</div></div><div><a name="N10898"></a><div style="padding-top: 1pc; margin-bottom: 2pt; font-size: 12pt; font-weight: bold;"><a name="crefsqlj1003454"></a><div></div>SQL92識別子の規則</div><div style="margin-left: 72pt; font-size: 10pt;"><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;">通常の識別子は二重引用符によって囲われていません。デリミトされた識別子は二重引用符によって囲まれています。</div><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;">通常の識別子は文字で始まり、文字、アンãƒ
 €ãƒ¼ã‚¹ã‚³ã‚¢(_)、0-9の数字しか含みません。ここで文字と0-9の数字とは、Unicodeの全文字と0-9の数字を含みますが、<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>は、識別子を構成する文字がデータベースのロケールで利用可能であることを保障するものではありません。</div><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;">
+デリミトされた識別子は二重引用符の間にどのような文字でも持つことができます。
+また識別氏を囲う二重引用符は、識別子の始まりと終わりを明示しているだけであり、それ自身は識別子とみなされません。またデリミトされた識別子の最後にある空白文字列は、無視されて切り捨てられます。<span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>はデリミトされた識別子にある連続した二つの二重引用符を、ひとつの二重引用符とみなします。このみなされた二重引用符はã
 ƒ‡ãƒªãƒŸãƒˆã•ã‚ŒãŸè­˜åˆ¥å­ã®ä¸€éƒ¨ã¨ã—て扱われます。</div><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;">デリミトされた識別子の中のピリオドはディクショナリの情報をあらわす識別子の一部であり、識別子の間の区切りではありません。</div><div style="font-size: 10pt; text-indent: 0em; margin-top: 0em; margin-bottom: 0.6em;">ですから、次の例にて、<pre><div style="margin-top: 1.2em; margin-bottom: 0.8em; background-color: #f0f0f0; font-family: Courier; line-height: 106%; font-size: 9pt;"><span style="font-weight: bold;">"A.B"</span></div></pre></div><div style="font-size: 10pt; text-inden
 t: 0em; margin-top: 0em; margin-bottom: 0.6em;">は、ディクショナリの情報ですが、<pre><div style="margin-top: 1.2em; margin-bottom: 0.8em; background-color: #f0f0f0; font-family: Courier; line-height: 106%; font-size: 9pt;"><span style="font-weight: bold;">"A"."B"</span></div></pre></div><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;">は、他のディクショナリの情報で限定されたディクショナリの情報です。(つまり、A表のB列としてあらわされた情報であるということです。)</div></div></div><div><a name="N10921"></a><div style="padding-top: 1pc; margin-bottom: 2pt; font-size: 12pt; font-weight: bold;"><a name="crefsqlj34834"></a><div></div>SQ
 L92識別子</div><div style="margin-left: 72pt; font-size: 10pt;"><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;"><span style="font-style: italic;">SQL92識別子</span>とは、SQL-92に沿ってディクショナリの情報をあらわす識別子です。SQL-92では、ディクショナリの情報をあらわす識別子は、128文字以内かつ(二重引用符によりデリミトされていなければ)システムにより大文字への変換が行われるため、大文字小文字が区別されないことになっています。まã
 、デリミトされない限り識別子とはできない予約語があります。もし128文字以上の名前を使おうとすると、<span style="font-style: italic;">SQLException</span> X0X11が挙がります。</div><div style="font-size: 10pt; text-indent: 0em; margin-top: 0.6em; margin-bottom: 0.6em;"><span style="border-right-width: 0pt; border-left-width: 0pt;">Derby</span>には、SQL-92で定められている以外にもキーワードがあります。(<span style="color: blue;"><a href="#rrefkeywords29722">SQL予約語</a></span>を参照。)</div><div style="line-height: 12pt; margin-top: 0.6em; font-size: 10pt;"><a name="N1094C"></a><span></span><div style="font-weight: bold;">例</div><pre
 ><div style="margin-top: 1.2em; margin-bottom: 0.8em; background-color: #f0f0f0; font-family: Courier; line-height: 106%; font-size: 9pt;"><span style="font-weight: bold;"><span style="border-right-width: 0pt; border-left-width: 0pt;">-- この例ではシステムカタログに格納されビュー名は
+-- ANIDENTIFIERです。</span>
+CREATE VIEW AnIdentifier (RECEIVED) AS VALUES 1
+<span style="border-right-width: 0pt; border-left-width: 0pt;">-- この例ではシステムカタログに格納されたビュー名の
+-- 大文字小文字は損なわれません。</span>

[... 3252 lines stripped ...]
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/ref-single.html
------------------------------------------------------------------------------
    svn:eol-style = native



Mime
View raw message