You are viewing a plain text version of this content. The canonical link for it is here.
Posted to general@db.apache.org by rh...@apache.org on 2013/03/13 14:54:25 UTC
svn commit: r854277 [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/
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
+
+ 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> </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> <span>•</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#rreflicense"><span style="font-weight: bold;">License</span> <span>•</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#crefmpref1002477"><span style="font-weight: bold;">ãã®ææ¸ã«ã¤ãã¦</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#crefmpref11181"><span style="font-weight: bold;">ãã®ææ¸ã®ç®ç</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#crefmpref23223"><span style="font-weight: bold;">ãã®ææ¸ã®èªè
</span> <span>•</span></a></div><div style="margin-left
: 7.5pc;"><a href="#crefmpref23947"><span style="font-weight: bold;">ãã®ææ¸ã®æ§æ</span> <span>•</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#crefsqlj23296"><span style="font-weight: bold;">SQLè¨èªã®ãªãã¡ã¬ã³ã¹</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefsqlj28468"><span style="font-weight: bold;">大æåå°æåã¨ç¹æ®æå</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#crefsqlj18919"><span style="font-weight: bold;">SQLã®èå¥å </span> <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj1003454">SQL92èå¥åã®è¦å <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj34834">SQL92è
å¥å <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefcolumnname">åå <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefcorrelationname">ç¸é¢å <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefnewtablename">æ°ãã表å <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefschemaname">ã¹ãã¼ãå <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsimplecolumnname">åç´åå <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsynonymname">å¥å <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreftablename">表å <span>•</span></a></div><div style="margin-left: 9pc;"><a
href="#rrefviewname">ãã¥ã¼å <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefindexname">ç´¢å¼å <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefconstraintname">å¶ç´å <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefcursorname">ã«ã¼ã½ã«å <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreftriggername">TriggerName <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefrauthid">èªè¨¼èå¥å <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#crefsqlj39374"><span style="font-weight: bold;">æ</span> <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj22771">ä¾åé¢ä¿ <sp
an>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj81859">ALTER TABLE æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefcallprocedure">CALL (æç¶ã) æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj95081">CREATE æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefdeclaretemptable">DECLARE GLOBAL TEMPORARY TABLE æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj35981">DELETE æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj80721">DROPæ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqljgrant">GRANT æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj40774">INSERT æ  
; <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj40506">LOCK TABLE æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqljrenamestatements">RENAME æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqljrevoke">REVOKE æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj35312">SET æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj41360">SELECT æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj26498">UPDATEæ <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefclauses"><span style="font-weight: bold;">SQL ç¯</span> <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj13590">CONSTRAINT ç¯ &n
bsp; <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj31783">FOR UPDATE ç¯ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj21583">FROM ç¯ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj32654">GROUP BY ç¯ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj14854">HAVING ç¯ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj13658">ORDER BY ç¯ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj33602">WHERE ç¯ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj15309">WHERE CURRENT OF ç¯ <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefsqlj19433"><span style="font-weight: bold;">SQLå¼</
span> <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefselectexpression">é¸æå¼ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreftableexpression">TableExpression <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj11277">VALUESå¼ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj1080779">å¼ã«é¢ããåªå
é ä½ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj23075">çå½å¼ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj29911">åçãã©ã¡ã¼ã¿ <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefsqlj29840"><span style="font-weight: bold;">JOIN æ¼ç®</span> &nb
sp; <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj35034">INNER JOIN æ¼ç® <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj18922">LEFT OUTER JOINæ¼ç® <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj57522">RIGHT OUTER JOIN æ¼ç® <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefqueries"><span style="font-weight: bold;">SQL åãåãã</span> <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj21571">ååã <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefscalarsubquery">ã¹ã«ã©ã¼å¯ååã <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreftablesubquery">表å¯ååã  
; <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefsqlj29026"><span style="font-weight: bold;">çµã¿è¾¼ã¿é¢æ°</span> <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj55788">æ¨æºçµè¾¼ã¿é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj33923">éç´ (éåé¢æ°) <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj98067">ABSã¨ABSVALé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncacos">ACOS é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncasin">ASIN é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncatan">ATAN é¢æ° <span>•
</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj32693">AVGé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefbuiltbigint">BIGINTé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefcase">CASE å¼ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj33562">CAST é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncceil">CEILããã³CEILINGé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefbuiltchar">CHAR é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj40899">Concatenation <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffunccos">COS é¢æ° <span>•</span>
</a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj38716">COUNT é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj66113">COUNT(*) é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqljcurrentdate">CURRENT DATE é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj34177">CURRENT_DATEé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefcurrentisolation">CURRENT ISOLATION é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqljcurrentschema">CURRENT SCHEMAé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj1055824">CURRENT TIME <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj33772">CURRENT_T
IMEé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqljcurrenttimestamp">CURRENT TIMESTAMPé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj15866">CURRENT_TIMESTAMPé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj42324">CURRENT_USERé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefdatefunc">DATEé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefdayfunc">DAY é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncdegrees">DEGREES é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefbuiltdouble">DOUBLEé¢æ° <span>•</span></a></div><div style="margin-left: 9
pc;"><a href="#rreffuncexp">EXPé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncfloor">FLOORé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefhourfunc">HOURé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefidentityvallocal">IDENTITY_VAL_LOCALé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefbuiltinteger">INTEGERé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj42049">LCASEãããã¯LOWERé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj16762">LENGTHé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffunclog">LNãããã¯LOGé¢æ° &nbs
p; <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffunclog10">LOG10 é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj61998">LOCATEé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj97870">LTRIMé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj27781">MAXé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj33520">MINé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefminutefunc">MINUTE é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqljmod">MODé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefmonthfunc">MONTHé¢æ° <span>•<
/span></a></div><div style="margin-left: 9pc;"><a href="#rrefcasenullif">NULLIFå¼ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncpi">PI é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncradians">RADIANS é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj32613">RTRIMé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsecondfunc">SECONDé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj25228">SESSION_USERé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncsin">SIN é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefbuiltsmallint">SMALLINTé¢æ° <span>•</spa
n></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj73147">SQRTé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj93082">SUBSTRé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj13083">SUMé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffunctan">TAN é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreftimefunc">TIME é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreftimestampfunc">TIMESTAMPé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreftrimfunc">TRIM é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj29930">UCASEé¢æ°ããã³UPPERé¢æ° &
nbsp; <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsqlj42476">USERé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefbuiltvarchar">VARCHARé¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncxmlexists">XMLEXISTS æ¼ç®å <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncxmlparse">XMLPARSEæ¼ç®å <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncxmlquery">XMLQUERYæ¼ç®å <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rreffuncxmlserialize">XMLSERIALIZE æ¼ç®å <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefyearfunc">YEARé¢æ° <span>•</span></a></div><div style="margin-left: 7.5pc;"><a hr
ef="#crefsqlbuiltinsystemfunctions"><span style="font-weight: bold;">çµè¾¼ã¿ã·ã¹ãã é¢æ°</span> <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsyscschecktablefunc">SYSCS_UTIL.SYSCS_CHECK_TABLEã·ã¹ãã é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefgetdbpropfunc">SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTYã·ã¹ãã é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsyscsruntimestatsfunc">SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS ã·ã¹ãã é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlbuiltinsystemprocedures">çµã¿è¾¼ã¿ã·ã¹ãã æç¶ã <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsyscsdialgtables">SYSCS
_DIAG 診æ表ããã³é¢æ° <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#crefsqlj31068">ãã¼ã¿å <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefkeywords29722"><span style="font-weight: bold;">SQLäºç´èª</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefsql9241891"><span style="font-weight: bold;">Derbyã®ãµãã¼ãããSQL-92ã®æ©è½</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefsistabs38369"><span style="font-weight: bold;">Derbyã®ã·ã¹ãã 表</span> <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs28114">SYSALIASES ã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 9
pc;"><a href="#rrefsistabs26665">SYSCHECKSã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabssyscolperms">SYSCOLPERMS ã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs22441">SYSCOLUMNSã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs39391">SYSCONGLOMERATES ã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs23241">SYSCONSTRAINTS ã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs12813">SYSDEPENDS ã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs40972">SYSFILESã·ã¹ãã 表 &nb
sp; <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs13420">SYSFOREIGNKEYSã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs33921">SYSKEYSã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabssysroutineperms">SYSROUTINEPERMS ã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs12085">SYSSCHEMAS ã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabslilanguageitemsysstatistics">SYSSTATISTICSã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs33768">SYSSTATEMENTSã·ã¹ãã 表 <span>•</span></a></div><div style="marg
in-left: 9pc;"><a href="#rrefsistabssystableperms">SYSTABLEPERMS ã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs24269">SYSTABLES ã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs79888">SYSTRIGGERSã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefsistabs24045">SYSVIEWS ã·ã¹ãã 表 <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefexcept16677"><span style="font-weight: bold;">Derbyã®ä¾å¤ã¡ãã»ã¼ã¸ã¨SQL state</span> <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefexcept71493">SQLã®ã¨ã©ã¼ã¡ãã»ã¼ã¸ã¨ä¾å¤ <span>•</span></a></div><d
iv style="margin-left: 7.5pc;"><a href="#crefjdbc12657"><span style="font-weight: bold;">JDBC ãªãã¡ã¬ã³ã¹</span> <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#crefjdbc25142">java.sqlã«ãããJDBCã®ä¸»ãªã¯ã©ã¹ã ã¤ã³ã¿ã¼ãã§ã¤ã¹ãã¡ã½ãã <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc32052">java.sql.Driverã¤ã³ã¿ã¼ãã§ã¤ã¹ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc34565">java.sql.DriverManager.getConnection ã¡ã½ãã <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc27734">java.sql.Connection ã¤ã³ã¿ã¼ãã§ã¤ã¹ <span>•</span></a></div><div style="margin-left: 9pc;"><a
href="#rrefjdbc15905">java.sql.DatabaseMetaData ã¤ã³ã¿ã¼ãã§ã¤ã¹ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc40794">java.sql.Statementã¤ã³ã¿ã¼ãã§ã¤ã¹ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc20485">java.sql.CallableStatement ã¤ã³ã¿ã¼ãã§ã¤ã¹ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc16643">java.sql.SQLException ã¯ã©ã¹ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc29874">java.sql.PreparedStatementã¤ã³ã¿ã¼ãã§ã¤ã¹ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc23502">java.sql.ResultSet ã¤ã³ã¿ã¼ãã§ã¤ã¹ <span>•</span></a></d
iv><div style="margin-left: 9pc;"><a href="#rrefjdbc38274">java.sql.ResultSetMetaData ã¤ã³ã¿ã¼ãã§ã¤ã¹ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc30469">java.sql.SQLWarning ã¯ã©ã¹ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcrefsqlxml">java.sql.SQLXMLã¤ã³ã¿ã¼ãã§ã¤ã¹ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc20377">SQLåã¨java.sql.Typesã®å¯¾å¿ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc2_0summary">JDBC 2.0 ã®æ©è½ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc80004">java.sql.Connection ã¤ã³ã¿ã¼ãã§ã¤ã¹: JDBC 2.0ã§å©ç¨å¯è½ãªã¡ã½ãã &
nbsp; <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc66688">java.sql.DatabaseMetaData ã¤ã³ã¿ã¼ãã§ã¤ã¹: å©ç¨å¯è½ãªJDBC 2.0ã®ã¡ã½ãã <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc99392">java.sql.PreparedStatementã¤ã³ã¿ã¼ãã§ã¤ã¹: JDBC2.0ã§æä¾ãããã¡ã½ãã <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc77156">java.sql.ResultSet <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc71949">java.sql.ResultSetMetaData ã¤ã³ã¿ã¼ãã§ã¤ã¹: JDBC 2.0ã§å©ç¨å¯è½ãªã¡ã½ãã <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc59162">java.sql.Statement ã�
�¤ã³ã¿ã¼ãã§ã¤ã¹: å©ç¨å¯è½ãªJDBC 2.0ã®ã¡ã½ãã <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefjdbc87220"><span style="font-weight: bold;">java.sql.BatchUpdateException ã¯ã©ã¹</span> <span>•</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> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefjdbc32593"><span style="font-weight: bold;">JDBC 3.0ã®æ©è½</span> <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcjavasqlconnection30">java.sql.Connectionã¤ã³ã¿ã¼ãã§ã¤ã¹: JDBC3.0ã«ã¦å©ç¨å¯è½�
�ªã¡ã½ãã <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcdatabasemetadata30">java.sql.DatabaseMetaData ã¤ã³ã¿ã¼ãã§ã¤ã¹: JDBC 3.0ã§å©ç¨å¯è½ãªã¡ã½ãã <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcparametermetadata30">java.sql.ParameterMetaDataã¤ã³ã¿ã¼ãã§ã¤ã¹:JDBC3.0ã§å©ç¨å¯è½ãªã¡ã½ãã <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcjavasqlpreparedstatement30">java.sql.PreparedStatementã¤ã³ã¿ã¼ãã§ã¤ã¹: JDBC3.0ã§å©ç¨å¯è½ãªã¡ã½ãã <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcjavasqlsavepoint">java.sql.Savepoint ã¤ã³ã¿ã¼ã�
�§ã¤ã¹ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcjavasqlstatement30">java.sql.Statementã¤ã³ã¿ã¼ãã§ã¤ã¹: JDBC 3.0ã§å©ç¨å¯è½ãªã¡ã½ãã <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefjdbc4_0summary"><span style="font-weight: bold;">JDBC 4.0ã®æ©è½</span> <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc4_0sqlexception">æ´ç·´ãããSQLExceptionã®ãµãã¯ã©ã¹ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc4_0connection">java.sql.Connectionã¤ã³ã¿ã¼ãã§ã¤ã¹:JDBC4.0ã§æä¾ãããæ©è½ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc4_0databaseMe
taData">java.sql.DatabaseMetaDataã¤ã³ã¿ã¼ãã§ã¤ã¹: JDBC4.0ã®æ©è½ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc4_0statement">java.sql.Statementã¤ã³ã¿ã¼ãã§ã¤ã¹: JDBC 4.0ã§å©ç¨å¯è½ãªæ©è½ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc4_0dataSource">javax.sql.DataSource ã¤ã³ã¿ã¼ãã§ã¤ã¹: JDBC 4.0ã®æ©è½ <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefjdbc1020262"><span style="font-weight: bold;">JDBCã¨ã¹ã±ã¼ãã®æ§æ</span> <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc70824">å¼ã³åºãæã®JDBCã¨ã¹ã±ã¼ããã¼ã¯ã¼ã <span>&bu
ll;</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc27768">JDBCã¨ã¹ã±ã¼ãæ§æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc28456">LIKEç¯ã®JDBCã¨ã¹ã±ã¼ãæ§æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc88908">fnãã¼ã¯ã¼ãã使ã£ãJDBCã¨ã¹ã±ã¼ãæ§æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc37244">å¤é¨çµåã®JDBCã¨ã¹ã±ã¼ãæ§æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc12124">æå»æ¸å¼ã®JDBCã¨ã¹ã±ã¼ãæ§æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbcescapedate">æ¥ä»æ¸å�
�ã®JDBCã¨ã¹ã±ã¼ãæ§æ <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjdbc41784">ã¿ã¤ã ã¹ã¿ã³ãæ¸å¼ã®JDBCã¨ã¹ã±ã¼ãæ§æ <span>•</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#rrefattrib24612"><span style="font-weight: bold;">ãã¼ã¿ãã¼ã¹æ¥ç¶URLã«å±æ§ãæå®ããã</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib42100"><span style="font-weight: bold;">bootPassword=keyå±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribcollation"><span style="font-weight: bold;">collation=collation å±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href=
"#rrefattrib26867"><span style="font-weight: bold;">create=true å±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefcreatefrom"><span style="font-weight: bold;">createFrom=Pathå±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib17246"><span style="font-weight: bold;">databaseName=nameofDatabaseå±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib15290"><span style="font-weight: bold;">dataEncryption=trueå±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribencryptkey"><span style="font-weight: bold;">encryptionKey=keyå±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib88843"><span style="font-weight: bold;">encryptionProvider=providerNameå±�
�§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib60346"><span style="font-weight: bold;">encryptionAlgorithm=algorithm å±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib72457"><span style="font-weight: bold;">logDevice=logDirectoryPath å±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribnewencryptkey"><span style="font-weight: bold;">newEncryptionKey=key å±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribnewbootpw"><span style="font-weight: bold;">newBootPassword=newPassword å±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib42686"><span style="font-weight: bold;">password=userPassword</span> <span>•</span></a></
div><div style="margin-left: 7.5pc;"><a href="#rrefrestorefrom"><span style="font-weight: bold;">restoreFrom=pathå±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefrollforward"><span style="font-weight: bold;">rollForwardRecoveryFrom=path å±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib16471"><span style="font-weight: bold;">shutdown=trueå±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib56769"><span style="font-weight: bold;">territory=ll_CC å±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribtracedirectory"><span style="font-weight: bold;">traceDirectory=path å±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribtracefile"><span style="
font-weight: bold;">traceFile=path å±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribtracefileappend"><span style="font-weight: bold;">traceFileAppend=true å±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribtracelevel"><span style="font-weight: bold;">traceLevel=value å±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribupgrade"><span style="font-weight: bold;">upgrade=true attribute</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib10035"><span style="font-weight: bold;">user=userName å±æ§</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefattribssl"><span style="font-weight: bold;">ssl=sslMode å±æ§</span> <span>•</span></
a></div><div style="margin-left: 7.5pc;"><a href="#rrefattrib34183"><span style="font-weight: bold;">å±æ§ãæå®ããã«ãã¼ã¿ãã¼ã¹ã«æ¥ç¶ãã</span> <span>•</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> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefjta51021"><span style="font-weight: bold;">JTA API </span> <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefjta1003392">製åã«é¢ããä½ãæ¸ã <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefjta18596"><span style="font-weight: bold;">javax.sql:JDBCã¤ã³ã¿
ã¼ãã§ã¤ã¹</span> <span>•</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#rrefapi10613"><span style="font-weight: bold;">Derby API</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefapi24806"><span style="font-weight: bold;">ã¹ã¿ã³ãã¢ãã¼ã³ã®ãã¼ã«ã¨ã¦ã¼ãã£ãªãã£</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefapi19690"><span style="font-weight: bold;">JDBCã®å®è£
ã¯ã©ã¹</span> <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefapi33761">JDBC driver <span>•</span></a></div><div style="margin-left: 9pc;"><a href="#rrefapi1003363">ãã¼ã¿ã½ã¼ã¹ã®ã¯ã©ã¹ <span>•</span></a></di
v><div style="margin-left: 7.5pc;"><a href="#rrefapi1005026"><span style="font-weight: bold;">ã¦ã¼ãã£ãªãã£çãªã¤ã³ã¿ã¼ãã§ã¤ã¹</span> <span>•</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#rrefsqlj75638"><span style="font-weight: bold;">å©ç¨å¯è½ãªå°åæ
å ±</span> <span>•</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#rreflimits"><span style="font-weight: bold;">Derbyã®å¶éäºé
</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefdbmlimits"><span style="font-weight: bold;">ãã¼ã¿ãã¼ã¹è¨å®å¤ã®å¶é</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefdttlimits"><span style="font-weight: bold;">DATEãTIM
Eã¨TIMESTAMPã®å¶é</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefidlengthlimits"><span style="font-weight: bold;">èå¥åã®é·ãå¶é</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefnumericlimits"><span style="font-weight: bold;">æ°å¤ã®å¶é</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rrefstringlimits"><span style="font-weight: bold;">並ã³ã®å¶é</span> <span>•</span></a></div><div style="margin-left: 7.5pc;"><a href="#rreflimitsxml"><span style="font-weight: bold;">XMLã®å¶é</span> <span>•</span></a></div><div style="margin-left: 4.9pc; margin-top: 6pt;"><a href="#rreftrademderby"><span style="font-weight: bold;">Trademarks</span> <span>•</span></a>
</div></div></div></div><div valign="top"><div style="font-family: Helvetica; font-weight: bold; font-size: 10pt; text-align: center;"><span>•</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>•</span></div></td><td width="8"> </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>•</span></div></td><td width="8"> </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>•</span></div></td><td width="8"> </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>•</span></div></td><td width="8"> </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>•</span></div></td><td width="8"> </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>•</span></div></td><td width="8"> </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>•</span></div></td><td width="8"> </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>•</span></div></td><td width="8"> </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>•</span></div></td><td width="8"> </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>•</span></div></td><td width="8"> </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>•</span></div></td><td width="8"> </td><td valign="top"><div>ä¸éå¼ç¨ç¬¦ã§æåã®åãåºåããã�
�¨ãã§ãã¾ãã</div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>•</span></div></td><td width="8"> </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>•</span></div></td><td width="8"> </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>•</span></div></td><td width="8"> </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>•</span></div></td><td width="8"> </td><td valign="top"><div>Javaã®æ¸ãæ¹ã«ããèå¥åã¯å¸¸ã«å¤§æåå°æåãåºå¥ãã¾ãã</div></td></tr><tr><td valign="top" style="text-align: right;" width="24"><div><span>•</span></div></td><td width="8"> </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>•</span></div></td><td width="8"> </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>•</span></div></td><td width="8"> </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