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 [35/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/rrefsqlj29026.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29026.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29026.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,305 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="çµã¿è¾¼ã¿é¢æ°" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj23296.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj28468.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj18919.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj39374.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefclauses.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj19433.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29840.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefqueries.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlbuiltinsystemfunctions.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefkeywords29722.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsql9241891.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsistabs38369.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefexcept16677.html" />
+<meta scheme="URI" name="DC.Relation" content="crefjdbc12657.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc87220.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbcjsr169.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc32593.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc4_0summary.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc1020262.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj55788.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj33923.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj98067.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncacos.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncasin.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncatan.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj32693.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefbuiltbigint.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefcase.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj33562.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncceil.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefbuiltchar.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj40899.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffunccos.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj38716.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj66113.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljcurrentdate.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj34177.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefcurrentisolation.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljcurrentschema.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj1055824.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj33772.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljcurrenttimestamp.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj15866.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj42324.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefdatefunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefdayfunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncdegrees.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefbuiltdouble.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncexp.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncfloor.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefhourfunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefidentityvallocal.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefbuiltinteger.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj42049.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj16762.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffunclog.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffunclog10.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj61998.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj97870.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj27781.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj33520.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefminutefunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljmod.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefmonthfunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefcasenullif.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncpi.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncradians.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj32613.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsecondfunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj25228.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncsin.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefbuiltsmallint.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj73147.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj93082.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj13083.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffunctan.html" />
+<meta scheme="URI" name="DC.Relation" content="rreftimefunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rreftimestampfunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rreftrimfunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29930.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj42476.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefbuiltvarchar.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncxmlexists.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncxmlparse.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncxmlquery.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncxmlserialize.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefyearfunc.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj29026" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>çµã¿è¾¼ã¿é¢æ°</title>
+</head>
+<body id="rrefsqlj29026"><a name="rrefsqlj29026"><!-- --></a>
+
+
+<h1 class="topictitle1">çµã¿è¾¼ã¿é¢æ°</h1>
+
+<div>
+<div class="section"><p>çµã¿è¾¼ã¿é¢æ°ã¯ä½ããã®å¦çãè¡ãSQLãã¼ã¯ã¼ããç¹æ®ãªæ¼ç®åã§ãã
+çµã¿è¾¼ã¿é¢æ°ã«ã¯ããã¼ã¯ã¼ããç¹æ®ãªçµè¾¼ã¿ã®æ¼ç®åãä¸ãããã¦ãã¾ãã
+çµã¿è¾¼ã¿é¢æ°ã®ãã¼ã¯ã¼ãã¯SQL92èå¥åã§ããã大æåå°æåãåºå¥ãã¾ããã
+TIMESTAMPADDãTIMESTAMPDIFFã®ãããªã¨ã¹ã±ã¼ãé¢æ°ã¯ãJDBCã®ã¨ã¹ã±ã¼ãé¢æ°ã®æ§æã«æ²¿ã£ã¦ã®ã¿å©ç¨ã§ãã¾ãã<a href="rrefjdbc1020262.html#rrefjdbc1020262">JDBCã¨ã¹ã±ã¼ãã®æ§æ</a>ãåç
§ãã¦ãã ããã
+</p>
+</div>
+
+</div>
+
+<div>
+<ul class="ullinks">
+<li class="ulchildlink"><strong><a href="rrefsqlj55788.html">æ¨æºçµè¾¼ã¿é¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj33923.html">éç´ (éåé¢æ°)</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj98067.html">ABSã¨ABSVALé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rreffuncacos.html">ACOS é¢æ°</a></strong><br />
+ACOSé¢æ°ã¯ä¸ããããæ°ãå¼æ°ã¨ããéä½å¼¦é¢æ°ã®å¤ãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rreffuncasin.html">ASIN é¢æ°</a></strong><br />
+ASIN é¢æ°ã¯ä¸ããããæ°ãå¼æ°ã¨ããéæ£å¼¦ã®å¤ãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rreffuncatan.html">ATAN é¢æ°</a></strong><br />
+ATAN é¢æ°ã¯ä¸ããããæ°ãå¼æ°ã¨ããéæ£æ¥ãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj32693.html">AVGé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefbuiltbigint.html">BIGINTé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefcase.html">CASE å¼</a></strong><br />
+Derbyã§æ¡ä»¶å¼ãæ¸ãã«ã¯ãCASEå¼ã使ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj33562.html">CAST é¢æ°</a></strong><br />
+CASTé¢æ°ã«ããå¤ã®åãä»ã®åã«å¤æãã¾ããã¾ãåçãªå¼æ°(?)ãNULLå¤ã«åãä¸ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rreffuncceil.html">CEILããã³CEILINGé¢æ°</a></strong><br />
+CEILããã³CEILINGé¢æ°ã¯ä¸ããããæ°ãåãä¸ãã¦ããã®æ°ä»¥ä¸ã®æå°ã®å¤ãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rrefbuiltchar.html">CHAR é¢æ°</a></strong><br />
+CHARé¢æ°ã«ããåºå®é·ã®æååã¸ã®å¤æå¤ãè¿ããã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj40899.html">Concatenation</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rreffunccos.html">COS é¢æ°</a></strong><br />
+COSé¢æ°ã¯å¼æ°ããä½å¼¦ãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj38716.html">COUNT é¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj66113.html">COUNT(*) é¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqljcurrentdate.html">CURRENT DATE é¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj34177.html">CURRENT_DATEé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefcurrentisolation.html">CURRENT ISOLATION é¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqljcurrentschema.html">CURRENT SCHEMAé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj1055824.html">CURRENT TIME</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj33772.html">CURRENT_TIMEé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqljcurrenttimestamp.html">CURRENT TIMESTAMPé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj15866.html">CURRENT_TIMESTAMPé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj42324.html">CURRENT_USERé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefdatefunc.html">DATEé¢æ°</a></strong><br />
+DATEé¢æ°ã¯å¼æ°ããæ¥ä»ãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rrefdayfunc.html">DAY é¢æ°</a></strong><br />
+DAYé¢æ°ã¯å¤ã®ãã¡æ¥ä»ã®é¨åãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rreffuncdegrees.html">DEGREES é¢æ°</a></strong><br />
+DEGREESé¢æ°ã¯ã©ã¸ã¢ã³ã®å¤ã度ã®å¤ã¸å¤æãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rrefbuiltdouble.html">DOUBLEé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rreffuncexp.html">EXPé¢æ°</a></strong><br />
+EXPé¢æ°ã¯eãåºã¨ãã¦ãå¼æ°ã®ç´¯ä¹ãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rreffuncfloor.html">FLOORé¢æ°</a></strong><br />
+FLOORé¢æ°ã¯å¼æ°ã®å¤ã«åãæ¨ã¦ã®ä¸¸ãå¦çãè¡ããå¼æ°ä»¥ä¸ã®æ大ã®æ´æ°ãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rrefhourfunc.html">HOURé¢æ°</a></strong><br />
+HOURé¢æ°ã¯å¤ã®æã®é¨åãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rrefidentityvallocal.html">IDENTITY_VAL_LOCALé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefbuiltinteger.html">INTEGERé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj42049.html">LCASEãããã¯LOWERé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj16762.html">LENGTHé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rreffunclog.html">LNãããã¯LOGé¢æ°</a></strong><br />
+LNãããã¯LOGé¢æ°ã¯å¼æ°ã®èªç¶å¯¾æ°(eãåºã¨ãã¾ãã)ãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rreffunclog10.html">LOG10 é¢æ°</a></strong><br />
+LOG10é¢æ°ã¯10ãåºã¨ãã対æ°ãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj61998.html">LOCATEé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj97870.html">LTRIMé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj27781.html">MAXé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj33520.html">MINé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefminutefunc.html">MINUTE é¢æ°</a></strong><br />
+MINUTEé¢æ°ã¯å¤ã®åã®é¨åãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rrefsqljmod.html">MODé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefmonthfunc.html">MONTHé¢æ°</a></strong><br />
+MONTHé¢æ°ã¯å¤ããæã®é¨åãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rrefcasenullif.html">NULLIFå¼</a></strong><br />
+Derbyã§ã¯ãæ¡ä»¶å¼ã«ã¯NULLIFå¼ã使ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rreffuncpi.html">PI é¢æ°</a></strong><br />
+PIé¢æ°ã¯piã«æãè¿ãå¤ãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rreffuncradians.html">RADIANS é¢æ°</a></strong><br />
+RADIANSé¢æ°ã¯å¼æ°ã度ããã©ã¸ã¢ã³ã«å¤æãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj32613.html">RTRIMé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsecondfunc.html">SECONDé¢æ°</a></strong><br />
+SECONDé¢æ°ã¯å¼æ°ã®ç§ã®é¨åãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj25228.html">SESSION_USERé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rreffuncsin.html">SIN é¢æ°</a></strong><br />
+SINé¢æ°ã¯å¼æ°ã®æ£å¼¦ãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rrefbuiltsmallint.html">SMALLINTé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj73147.html">SQRTé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj93082.html">SUBSTRé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj13083.html">SUMé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rreffunctan.html">TAN é¢æ°</a></strong><br />
+TANé¢æ°ã¯å¼æ°ããè¨ç®ããæ£æ¥ãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rreftimefunc.html">TIME é¢æ°</a></strong><br />
+TIMEé¢æ°ã¯å¤ã®æå»ã®é¨åãè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rreftimestampfunc.html">TIMESTAMPé¢æ°</a></strong><br />
+TIMESTAMPé¢æ°ã¯ã¿ã¤ã ã¹ã¿ã³ãããå¤ãããã¯å¤ã®å¯¾ããè¿ãã¾ãã</li>
+<li class="ulchildlink"><strong><a href="rreftrimfunc.html">TRIM é¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj29930.html">UCASEé¢æ°ããã³UPPERé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj42476.html">USERé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefbuiltvarchar.html">VARCHARé¢æ°</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rreffuncxmlexists.html">XMLEXISTS æ¼ç®å</a></strong><br />
+XMLEXISTSã¯ãSQLã«ã¦XMLãåãåãããã¨ãã«å©ç¨ã§ããSQL/XMLæ¼ç®åã§ãã</li>
+<li class="ulchildlink"><strong><a href="rreffuncxmlparse.html">XMLPARSEæ¼ç®å</a></strong><br />
+XMLPARSEã¯ãæååå¼ãæ§æ解æãã¦DerbyXMLå¤ã«ããSQL/XMLæ¼ç®åã§ãã</li>
+<li class="ulchildlink"><strong><a href="rreffuncxmlquery.html">XMLQUERYæ¼ç®å</a></strong><br />
+XMLQUERYã¯SQLã«ã¦XMLã®å¤ãåãåããããã¨ãã§ããSQL/XMLæ¼ç®åã§ãã</li>
+<li class="ulchildlink"><strong><a href="rreffuncxmlserialize.html">XMLSERIALIZE æ¼ç®å</a></strong><br />
+XMLSERIALIZEã¯XMLåã®æ
å ±ãæååã®æ
å ±ã«å¤æããSQL/XMLæ¼ç®åã§ããããã¯Derby XMLå¤ãå¤æããå¯ä¸ã®æ¹æ³ã§ãã</li>
+<li class="ulchildlink"><strong><a href="rrefyearfunc.html">YEARé¢æ°</a></strong><br />
+</li>
+</ul>
+
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj23296.html" title="">SQLè¨èªã®ãªãã¡ã¬ã³ã¹</a></div>
+</div>
+<div class="relconcepts"><strong>é¢é£æ¦å¿µ</strong><br />
+<div><a href="crefsqlj18919.html" title="">SQLã®èå¥å</a></div>
+<div><a href="crefsqlj39374.html" title="">æ</a></div>
+<div><a href="crefsqlbuiltinsystemfunctions.html" title="">çµè¾¼ã¿ã·ã¹ãã é¢æ°</a></div>
+<div><a href="crefjdbc12657.html" title="Derbyã¯çµã¿è¾¼ã¿ã®JDBCãã©ã¤ãã¨å
±ã«æä¾ããã¾ãã">JDBC ãªãã¡ã¬ã³ã¹</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefsqlj28468.html" title="">大æåå°æåã¨ç¹æ®æå</a></div>
+<div><a href="rrefclauses.html" title="">SQL ç¯</a></div>
+<div><a href="rrefsqlj19433.html" title="å¤ãã®æãå¼ã®æ§æã®èªå¥ã«ãå¼ã表å¯ååãã®ãããªå¼ã®ä¸ç¨®ãããã¾ãã å¼ã¯æã®å®ããããå ´æã«ç½®ããã¨ãã§ãã¾ãã">SQLå¼</a></div>
+<div><a href="rrefsqlj29840.html" title="">JOIN æ¼ç®</a></div>
+<div><a href="rrefqueries.html" title="">SQL åãåãã</a></div>
+<div><a href="rrefkeywords29722.html" title="">SQLäºç´èª</a></div>
+<div><a href="rrefsql9241891.html" title="">Derbyã®ãµãã¼ãããSQL-92ã®æ©è½</a></div>
+<div><a href="rrefsistabs38369.html" title="">Derbyã®ã·ã¹ãã 表</a></div>
+<div><a href="rrefexcept16677.html" title="Derbyã«ã¦çºçããå
¨ã¦ã®ã¨ã©ã¼ã¯ãJDBCããSQLExceptionã¨ãã¦æããã¾ãã ããã¦ã¼ã¶ã®å®ç¾©ããåããä¾å¤ãæãã£ã¦ããã®ä¾å¤ãSQLExceptionã§ã¯ç¡ãå ´åããã®ä¾å¤ã¯SQLExceptionã«ã©ããããã¦ãã¾ãã Derbyåºæã®SQLExceptionã¯ãSQLStateã¯ã©ã¹ã«å®ç¾©ãããXã§å§ã¾ãã³ã¼ããç¨ãã¾ããæ¨æºã«å®ç¾©ãããSQLStateã®å¤ã¯ã対å¿ããä¾å¤ã«å¯¾ãã¦è¿ããã¾ãã">Derbyã®ä¾å¤ã¡ãã»ã¼ã¸ã¨SQL state</a></div>
+<div><a href="rrefjdbc87220.html" title="">java.sql.BatchUpdateException ã¯ã©ã¹</a></div>
+<div><a href="rrefjdbcjsr169.html" title="">Connected Device Configurationããã³Foundation Profileåãã®JDBCããã±ã¼ã¸(JSR169)</a></div>
+<div><a href="rrefjdbc32593.html" title="">JDBC 3.0ã®æ©è½</a></div>
+<div><a href="rrefjdbc4_0summary.html" title="">JDBC 4.0ã®æ©è½</a></div>
+<div><a href="rrefjdbc1020262.html" title="">JDBCã¨ã¹ã±ã¼ãã®æ§æ</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29026.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29840.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29840.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29840.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,134 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="JOIN æ¼ç®" />
+<meta content="JOIN operations, Outer joins" name="DC.subject" />
+<meta content="JOIN operations, Outer joins" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj23296.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj28468.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj18919.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj39374.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefclauses.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj19433.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefqueries.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlbuiltinsystemfunctions.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefkeywords29722.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsql9241891.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsistabs38369.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefexcept16677.html" />
+<meta scheme="URI" name="DC.Relation" content="crefjdbc12657.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc87220.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbcjsr169.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc32593.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc4_0summary.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc1020262.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj35034.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj18922.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj57522.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj29840" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>JOIN æ¼ç®</title>
+</head>
+<body id="rrefsqlj29840"><a name="rrefsqlj29840"><!-- --></a>
+
+
+<h1 class="topictitle1">JOIN æ¼ç®</h1>
+
+
+<div>
+<div class="section"> <p>JOINæ¼ç®ã¯<a href="rrefsqlj21583.html#rrefsqlj21583">FROM ç¯</a>ã®<em><a href="rreftableexpression.html#rreftableexpression">TableExpression</a></em>ã«ç½®ããã¨ãã§ãã2表ã®éã®çµåãè¨è¿°ãã¾ãã(WHEREç¯ã«ã¦"WHERE t1.col1
+= t2.col2"çã¨æ¸ãã¦ãæ示çã«ç価æ§ã®å¤å®å¼ãè¨è¿°ãããã¨ã§ããçµåãå®ç¾ãããã¨ãã§ãã¾ãã)</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong><em>JOINå¼</em></strong></pre>
+
+<div class="p">JOINæ¼ç®ã¯ã以ä¸ã®ããããã§ãã<ul>
+<li><a href="rrefsqlj35034.html#rrefsqlj35034">INNER JOIN æ¼ç®</a>
+<p>joinç¯ã«ãã2表ã®éã®çµåãæ示çã«æå®ãã¾ãã<a href="rrefsqlj35034.html#rrefsqlj35034">INNER JOIN æ¼ç®</a>ãåç
§ãã¦ãã ããã</p>
+</li>
+
+<li><a href="rrefsqlj18922.html#rrefsqlj18922">LEFT OUTER JOINæ¼ç®</a>
+<p>joinç¯ã«ãã2表ã®éã®çµåãæ示çã«æå®ãã¾ããã¾ãæåã®è¡¨ã«ã¦ä¸è´è¡ãäºã¤ç®ã®è¡¨ã«ãªãè¡ãæ®ãã¾ãã<a href="rrefsqlj18922.html#rrefsqlj18922">LEFT OUTER JOINæ¼ç®</a>ãåç
§ãã¦ãã ããã</p>
+</li>
+
+<li><a href="rrefsqlj57522.html#rrefsqlj57522">RIGHT OUTER JOIN æ¼ç®</a>
+<p>joinç¯ã«ãã2表ã®éã®çµåãæ示çã«æå®ãã¾ããã¾ãäºã¤ç®ã®è¡¨ã«ã¦ä¸è´è¡ãæåã®è¡¨ã«ãªãè¡ãæ®ãã¾ãã<a href="rrefsqlj57522.html#rrefsqlj57522">RIGHT OUTER JOIN æ¼ç®</a>ãåç
§ãã¦ãã ããã</p>
+</li>
+
+</ul>
+</div>
+ <p>ã©ã®å ´åã§ããçµåããã表ã®çæ¹ãããã¯ä¸¡æ¹ã«ãouter joinç¯ãããã¯<a href="rrefsqlj33602.html#rrefsqlj33602">WHERE ç¯</a>ã§ã追å ã®çµè¾¼æ¡ä»¶ãç½®ããã¨ãã§ãã¾ãã</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JOINæ¼ç®ã¨ãåãåããã®æé©å</h4>
+<p>çµåã«ã©ã®ãããªæé©åãè¡ããããã«ã¤ãã¦ã¯ã<cite><span><em>Derbyã®ãã¥ã¼ãã³ã°</em></span></cite>ãåç
§ãã¦ãã ããã</p>
+ </div>
+
+</div>
+
+<div>
+<ul class="ullinks">
+<li class="ulchildlink"><strong><a href="rrefsqlj35034.html">INNER JOIN æ¼ç®</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj18922.html">LEFT OUTER JOINæ¼ç®</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj57522.html">RIGHT OUTER JOIN æ¼ç®</a></strong><br />
+</li>
+</ul>
+
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj23296.html" title="">SQLè¨èªã®ãªãã¡ã¬ã³ã¹</a></div>
+</div>
+<div class="relconcepts"><strong>é¢é£æ¦å¿µ</strong><br />
+<div><a href="crefsqlj18919.html" title="">SQLã®èå¥å</a></div>
+<div><a href="crefsqlj39374.html" title="">æ</a></div>
+<div><a href="crefsqlbuiltinsystemfunctions.html" title="">çµè¾¼ã¿ã·ã¹ãã é¢æ°</a></div>
+<div><a href="crefjdbc12657.html" title="Derbyã¯çµã¿è¾¼ã¿ã®JDBCãã©ã¤ãã¨å
±ã«æä¾ããã¾ãã">JDBC ãªãã¡ã¬ã³ã¹</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefsqlj28468.html" title="">大æåå°æåã¨ç¹æ®æå</a></div>
+<div><a href="rrefclauses.html" title="">SQL ç¯</a></div>
+<div><a href="rrefsqlj19433.html" title="å¤ãã®æãå¼ã®æ§æã®èªå¥ã«ãå¼ã表å¯ååãã®ãããªå¼ã®ä¸ç¨®ãããã¾ãã å¼ã¯æã®å®ããããå ´æã«ç½®ããã¨ãã§ãã¾ãã">SQLå¼</a></div>
+<div><a href="rrefqueries.html" title="">SQL åãåãã</a></div>
+<div><a href="rrefsqlj29026.html" title="">çµã¿è¾¼ã¿é¢æ°</a></div>
+<div><a href="rrefkeywords29722.html" title="">SQLäºç´èª</a></div>
+<div><a href="rrefsql9241891.html" title="">Derbyã®ãµãã¼ãããSQL-92ã®æ©è½</a></div>
+<div><a href="rrefsistabs38369.html" title="">Derbyã®ã·ã¹ãã 表</a></div>
+<div><a href="rrefexcept16677.html" title="Derbyã«ã¦çºçããå
¨ã¦ã®ã¨ã©ã¼ã¯ãJDBCããSQLExceptionã¨ãã¦æããã¾ãã ããã¦ã¼ã¶ã®å®ç¾©ããåããä¾å¤ãæãã£ã¦ããã®ä¾å¤ãSQLExceptionã§ã¯ç¡ãå ´åããã®ä¾å¤ã¯SQLExceptionã«ã©ããããã¦ãã¾ãã Derbyåºæã®SQLExceptionã¯ãSQLStateã¯ã©ã¹ã«å®ç¾©ãããXã§å§ã¾ãã³ã¼ããç¨ãã¾ããæ¨æºã«å®ç¾©ãããSQLStateã®å¤ã¯ã対å¿ããä¾å¤ã«å¯¾ãã¦è¿ããã¾ãã">Derbyã®ä¾å¤ã¡ãã»ã¼ã¸ã¨SQL state</a></div>
+<div><a href="rrefjdbc87220.html" title="">java.sql.BatchUpdateException ã¯ã©ã¹</a></div>
+<div><a href="rrefjdbcjsr169.html" title="">Connected Device Configurationããã³Foundation Profileåãã®JDBCããã±ã¼ã¸(JSR169)</a></div>
+<div><a href="rrefjdbc32593.html" title="">JDBC 3.0ã®æ©è½</a></div>
+<div><a href="rrefjdbc4_0summary.html" title="">JDBC 4.0ã®æ©è½</a></div>
+<div><a href="rrefjdbc1020262.html" title="">JDBCã¨ã¹ã±ã¼ãã®æ§æ</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29840.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29930.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29930.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29930.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,72 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="UCASEé¢æ°ããã³UPPERé¢æ°" />
+<meta content="functions, UPPER, UCASE, UPPER function, UCASE function" name="DC.subject" />
+<meta content="functions, UPPER, UCASE, UPPER function, UCASE function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj29930" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>UCASEé¢æ°ããã³UPPERé¢æ°</title>
+</head>
+<body id="rrefsqlj29930"><a name="rrefsqlj29930"><!-- --></a>
+
+
+<h1 class="topictitle1">UCASEé¢æ°ããã³UPPERé¢æ°</h1>
+
+
+<div>
+<div class="section"> <p>UCASEããã³UPPERã¯æåå¼ãå¼æ°ã«ã¨ããå
¨ã¦ã®ã¢ã«ãã¡ãããã®æåã大æåã«ãã¦è¿ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4><pre>UCASEã¾ãã¯UPPER ( <em>æåå¼</em> ) </pre>
+
+<div class="p">ããå¼æ°ã®åãCHARã§ããã°ãè¿ãå¤ã®åã¯CHARã§ãããã以å¤ã®å ´åã¯ãè¿ãå¤ã®åã¯VARCHARã§ãã
+<div class="note"><span class="notetitle">注: </span>UPPERã¨LOWERã¯ããã¼ã¿ãã¼ã¹ã®ãã±ã¼ã«ã«ããå½±é¿ãåãã¾ãããã±ã¼ã«ã®è¨å®ã«ã¤ãã¦ã®ã詳細ã¯<em><a href="rrefattrib56769.html#rrefattrib56769">territory=ll_CC å±æ§</a></em>ãåç
§ãã¦ãã ããã
+</div>
+</div>
+<p>è¿ãå¤ã®é·ãã¨æ大é·ã¯ãå¼æ°ã®é·ãã¨æ大é·ã¨åãã§ãã</p>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">ä¾</h4>次ã®ç¯ã«ããã<div class="p"><samp class="codeph">aSD1#w</samp>ã¨ããæååã大æåã«ãã¦è¿ãäºãã§ãã¾ãã
+<pre>VALUES UPPER('aSD1#w')</pre>
+
+è¿ãå¤ã¯<samp class="codeph">ASD1#W</samp>ã§ãã</div>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefsqlj29026.html" title="">çµã¿è¾¼ã¿é¢æ°</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29930.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30118.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30118.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30118.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,64 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="LONG VARCHAR FOR BIT DATAãã¼ã¿å" />
+<meta content="LONG VARCHAR FOR BIT DATA type" name="DC.subject" />
+<meta content="LONG VARCHAR FOR BIT DATA type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj30118" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>LONG VARCHAR FOR BIT DATAãã¼ã¿å</title>
+</head>
+<body id="rrefsqlj30118"><a name="rrefsqlj30118"><!-- --></a>
+
+
+<h1 class="topictitle1">LONG VARCHAR FOR BIT DATAãã¼ã¿å</h1>
+
+
+<div>
+<div class="section"> <p>LONG VARCHAR FOR BIT DATAåã«ã¯æ大ã§32,700ãã¤ãã®ãããåãè¨é²ã§ãã¾ãããã®åã¯åã®å®ç¾©ãè¡ãã¨ãã«æ大é·ãæå®ããå¿
è¦ããªããã¨ãé¤ãã<a href="rrefsqlj32714.html#rrefsqlj32714">VARCHAR
+FOR BIT DATA</a>ã¨åãã§ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>LONG VARCHAR FOR BIT DATA</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBC ã¡ã¿ãã¼ã¿å(java.sql.Types)</h4><p>LONGVARBINARY</p>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj31068.html" title="">ãã¼ã¿å</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30118.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30435.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30435.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30435.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,81 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="BIGINT ãã¼ã¿å" />
+<meta content="BIGINT data type" name="DC.subject" />
+<meta content="BIGINT data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj30435" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>BIGINT ãã¼ã¿å</title>
+</head>
+<body id="rrefsqlj30435"><a name="rrefsqlj30435"><!-- --></a>
+
+
+<h1 class="topictitle1">BIGINT ãã¼ã¿å</h1>
+
+
+<div>
+<div class="section"> <p>BIGINTã§ã¯æ´æ°ã®è¨é²ã®ãã8ãã¤ãã®é åãå²ãå½ã¦ããã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>BIGINT</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">ã³ã³ãã¤ã«æã®å¯¾å¿ããJavaã®å</h4> <p><em>java.lang.Long</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBCã¡ã¿æ
å ±ã§ã®å(java.sql.Types)</h4> <p>BIGINT</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">æå°å¤</h4> <p id="rrefsqlj30435__sqlj76321"><a name="rrefsqlj30435__sqlj76321"><!-- --></a>-9223372036854775808
+(<em>java.lang.Long.MIN_VALUE</em>)</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">æ大å¤</h4> <p id="rrefsqlj30435__sqlj25246"><a name="rrefsqlj30435__sqlj25246"><!-- --></a>9223372036854775807
+(<em>java.lang.Long.MAX_VALUE</em>)</p>
+
+<p>ä»ã®ãã¼ã¿åã¨æ··å¨ããã¦å©ç¨ããå ´åãçµæã®ãã¼ã¿åã¯<a href="rrefsqlj27767.html#rrefsqlj27767">å¼ã«ã¦è¡ãããæ°å¤åã®é
ç®</a>ã«æ¸ãããã«ã¼ã«ã«å¾ãã¾ãã</p>
+
+<p>å°ããªè¨æ¶é åããæããªãå ´æã«ããããã大ããªè¨æ¶é åãå ããæ´æ°å¤ã代å
¥ãããã¨ããã¨ããã®æ´æ°å¤ãå°ããªè¨æ¶é åã§ã¯è¨é²ã§ããã«ã¨ã©ã¼ã¨ãªããã¨ãããã¾ããã¾ãã©ã®ãããªæ´æ°ã§ããé©åã«numericã®å¤ã¨ããäºãã§ãã¾ããBIGINTã§ããã°ãå
åãªç²¾åº¦ãæã¤DECIMALã«è¨é²ãããã¨ãã§ãã¾ãã</p>
+ </div>
+
+<div class="example"> <pre><strong>9223372036854775807</strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj31068.html" title="">ãã¼ã¿å</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30435.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30540.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30540.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30540.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,102 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="en-us" xml:lang="en-us">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="åå®ç¾©" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj24513.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj37836.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj30540" name="DC.Identifier" />
+<meta content="en-us" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>åå®ç¾©</title>
+</head>
+<body id="rrefsqlj30540"><a name="rrefsqlj30540"><!-- --></a>
+
+
+<h1 class="topictitle1">åå®ç¾©</h1>
+
+<div>
+<div class="example"> <pre><strong><em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">åç´åå</a></em> <em>ãã¼ã¿å</em>
+ [ <em><a href="rrefsqlj16095.html#rrefsqlj16095">åæ¯ã®å¶ç´</a></em> ]*
+ [ [ WITH ] DEFAULT <var class="varname">æ¢å®å¶ç´å¼</var>
+ |<em><a href="rrefsqlj37836.html#rrefsqlj37836">çºçªåä»æ§</a></em> ]
+ [ <em><a href="rrefsqlj16095.html#rrefsqlj16095">åæ¯ã®å¶ç´</a></em> ]*
+</strong></pre>
+</div>
+
+<div class="section"><p><em>ãã¼ã¿å</em>ã®ä»æ§ã¯<a href="crefsqlj31068.html#crefsqlj31068">ãã¼ã¿å</a>ã«ã¦èª¬æããã¦ãã¾ãã</p>
+
+<p><em><a href="rrefsqlj16095.html#rrefsqlj16095">åæ¯ã®å¶ç´</a></em>ã¨<em><a href="rrefsqlj42154.html#rrefsqlj42154">表æ¯ã®å¶ç´</a></em>ã¯ã<a href="rrefsqlj13590.html#rrefsqlj13590">CONSTRAINT ç¯</a>ã«ã¦èª¬æããã¦ãã¾ãã</p>
+</div>
+
+<div class="section" id="rrefsqlj30540__sqlj64478"><a name="rrefsqlj30540__sqlj64478"><!-- --></a><h4 class="sectiontitle">åã®æ¢å®å¤</h4>
+<p>æ¢å®å¤ã®å®ç¾©ã¨ãã¦ããããªã表ã¸ã®åç
§ããªã<em>æ¢å®å¶ç´å¼</em>ãããã¾ãã
+ããã«å¯è½ã§ããã®ã¯å®æ°ãæ¥æã®ç¹æ®å¤æ°ãç¾å¨ã®ã¹ãã¼ããã¦ã¼ã¶ãnullã§ãã</p>
+
+<pre><strong><var class="varname">æ¢å®å¶ç´å¼</var>:
+ NULL
+ | CURRENT { SCHEMA | SQLID }
+ | USER | CURRENT_USER | SESSION_USER
+ | DATE
+ | TIME
+ | TIMESTAMP
+ | CURRENT DATE | CURRENT_DATE
+ | CURRENT TIME | CURRENT_TIME
+ | CURRENT TIMESTAMP | CURRENT_TIMESTAMP
+ | <var class="varname">literal</var>
+</strong></pre>
+
+<p>Derbyã®ãªãã©ã«å¤ã«ã¤ãã¦ã®è©³ç´°ã¯ã<a href="crefsqlj31068.html#crefsqlj31068">ãã¼ã¿å</a>ãåç
§ãã¦ãã ããã</p>
+
+<p><var class="varname">æ¢å®å¶ç´å¼</var>ã«ããå¤ã¯ãåã¨äºææ§ã®ããåã§ãªããã°ãªãã¾ãããå ãã¦ä»¥ä¸ã®å¶ç´ãããã¾ãã</p>
+
+<ul>
+<li>USERãCURRENT_USERãSESSION_USERãæå®ããå ´åãåã®é·ãã¯å°ãªãã¨ã8ã§ããå¿
è¦ãããã¾ãã</li>
+
+<li>CURRENT SCHEMAãCURRENT SQLIDãæå®ããå ´åãåã®é·ãã¯å°ãªãã¨ã128ã§ããå¿
è¦ãããã¾ãã</li>
+
+<li>åãæ´æ°åã§ããå ´åãæ¢å®å¤ã¯æ´æ°ã®ãªãã©ã«ã§ããå¿
è¦ãããã¾ãã</li>
+
+<li>åã10é²ã®åã§ããå ´åãæ¢å®å¤ã®æ¡æ°ã¨ç²¾åº¦ã¯åã®ããããã®å®ç¾©ã®ç¯å²å
ã§ããå¿
è¦ãããã¾ãã</li>
+
+</ul>
+
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="rrefsqlj24513.html" title="">CREATE TABLE æ</a></div>
+</div>
+<div class="relref"><strong>Related reference</strong><br />
+<div><a href="rrefsqlj37836.html" title="">çºçªåä»æ§</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30540.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31580.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31580.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31580.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,105 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="en-us" xml:lang="en-us">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="CREATE SCHEMA æ" />
+<meta content="CREATE SCHEMA statement, CREATE SCHEMA, SQL statements, schemas, creating" name="DC.subject" />
+<meta content="CREATE SCHEMA statement, CREATE SCHEMA, SQL statements, schemas, creating" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj95081.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefcreatefunctionstatement.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj20937.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefcreateprocedurestatement.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljcreatesynonym.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj24513.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj43125.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj15446.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj31580" name="DC.Identifier" />
+<meta content="en-us" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>CREATE SCHEMA æ</title>
+</head>
+<body id="rrefsqlj31580"><a name="rrefsqlj31580"><!-- --></a>
+
+
+<h1 class="topictitle1">CREATE SCHEMA æ</h1>
+
+
+<div>
+<div class="section"> <p>ã¹ãã¼ãã«ããæ
å ±ãè«ççã«ä¸ã¤ã®éåã«åé¡ãããã¨ãããã³ãä¸æãªåå空éãæä¾ããäºãã§ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>CREATE SCHEMA { [ <em><a href="rrefschemaname.html#rrefschemaname">ã¹ãã¼ãå</a></em> AUTHORIZATION <em>ã¦ã¼ã¶å</em> ] | [ <em>ã¹ãã¼ãå</em> ] |
+[ AUTHORIZATION <em>ã¦ã¼ã¶å</em> ] }</strong>
+</pre>
+ <p>CREATE SCHEMA æã«ããã¹ãã¼ããä½æãããã¨ãã§ãã¾ããã¹ãã¼ãåã¯128æåãè¶
ãã¦ã¯ãªãã¾ãããã¹ãã¼ãåã¯ãã¼ã¿ãã¼ã¹ã®å
ã§ä¸æã§ç¡ããã°ãªãã¾ããã</p>
+
+<div class="p">CREATE SCHEMAæã¯ãã¼ã¿ãã¼ã¹ãªããã·ã¹ãã ã«ããã¦ã<samp class="codeph">derby.database.sqlAuthorization</samp>ã<samp class="codeph">true</samp>ã¨ãªã£ã¦ããå ´åãã¢ã¯ã»ã¹å¶å¾¡ã®å¯¾è±¡ã¨ãªãã¾ãããã¼ã¿ãã¼ã¹ææè
ã ããç¾å¨ã®ã¦ã¼ã¶åã¨ã¯ç°ãªãååã®ã¹ãã¼ããä½æãããã¨ãã§ãã¾ããã¾ããã¼ã¿ãã¼ã¹ææè
ã ããç¾å¨ã®ã¦ã¼ã¶åã¨ã¯ç°ãªã<pre>AUTHORIZATION <em>user-name</em></pre>
+ãæå®ã§ãã¾ãã
+<samp class="codeph">derby.database.sqlAuthorization</samp>å±æ§ã«ã¤ãã¦ã®ãã詳細ãªæ
å ±ã¯ã<span><em>Derbyã®ãã¥ã¼ãã³ã°</em></span>ãåç
§ãã¦ãã ããã</div>
+</div>
+
+<div class="example"><h4 class="sectiontitle">CREATE SCHEMAã®ä¾</h4><div class="p">é£è¡æ©ã«é¢é£ãã表ãããã¹ãã¼ããä½æãã¦ã<samp class="codeph">anita</samp>ã¨ããèªè¨¼èå¥åã«ã¹ãã¼ãã®å
¨ã¦ã®æ
å ±ãæä½ãã権éãä¸ããã«ã¯æ¬¡ã®ããã«ãã¾ãã<pre><strong>CREATE SCHEMA FLIGHTS AUTHORIZATION anita</strong> </pre>
+</div>
+
+<div class="p">å¾æ¥å¡ã«é¢é£ãã表ãããã¹ãã¼ããä½æããã«ã¯æ¬¡ã®ããã«ãã¾ãã<pre><strong>CREATE SCHEMA EMP</strong> </pre>
+</div>
+
+<div class="p"><samp class="codeph">takumi</samp>ã¨ããã¹ãã¼ãåããã®ã¾ã¾èªè¨¼èå¥åã§ããã¹ãã¼ããä½æããã«ã¯æ¬¡ã®ããã«ãã¾ãã<pre><strong>CREATE SCHEMA AUTHORIZATION takumi</strong> </pre>
+</div>
+
+<div class="p"><samp class="codeph">EMP</samp>ã¨<samp class="codeph">FLIGHTS</samp>ã®åã¹ãã¼ãã«<samp class="codeph">availability</samp>ã¨ãã表ãä½æããã«ã¯æ¬¡ã®ããã«ãã¾ãã<pre><strong>CREATE TABLE FLIGHTS.AVAILABILITY
+ (FLIGHT_ID CHAR(6) NOT NULL, SEGMENT_NUMBER INT NOT NULL,
+ FLIGHT_DATE DATE NOT NULL, ECONOMY_SEATS_TAKEN INT,
+ BUSINESS_SEATS_TAKEN INT, FIRSTCLASS_SEATS_TAKEN INT,
+ CONSTRAINT FLT_AVAIL_PK
+ PRIMARY KEY (FLIGHT_ID, SEGMENT_NUMBER, FLIGHT_DATE))</strong> </pre>
+</div>
+<pre><strong>CREATE TABLE EMP.AVAILABILITY
+ (HOTEL_ID INT NOT NULL, BOOKING_DATE DATE NOT NULL, ROOMS_TAKEN INT,
+ CONSTRAINT HOTELAVAIL_PK PRIMARY KEY (HOTEL_ID, BOOKING_DATE))
+</strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="crefsqlj95081.html" title="">CREATE æ</a></div>
+</div>
+<div class="relref"><strong>Related reference</strong><br />
+<div><a href="rrefcreatefunctionstatement.html" title="CREATE FUNCTIONæã«ãããå¼ã§å©ç¨ã§ããJavaé¢æ°ãä½æã§ãã¾ãã">CREATE FUNCTION æ</a></div>
+<div><a href="rrefsqlj20937.html" title="">CREATE INDEX æ</a></div>
+<div><a href="rrefcreateprocedurestatement.html" title="">CREATE PROCEDURE æ</a></div>
+<div><a href="rrefsqljcreatesynonym.html" title="">CREATE SYNONYM æ</a></div>
+<div><a href="rrefsqlj24513.html" title="">CREATE TABLE æ</a></div>
+<div><a href="rrefsqlj43125.html" title="">CREATE TRIGGER æ</a></div>
+<div><a href="rrefsqlj15446.html" title="">CREATE VIEW æ</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31580.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31648.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31648.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31648.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,86 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="DROP SCHEMA æ" />
+<meta content="DROP SCHEMA statement, Schemas, dropping" name="DC.subject" />
+<meta content="DROP SCHEMA statement, Schemas, dropping" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj80721.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefdropfunctionstatement.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj59893.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefdropprocedurestatement.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljdropsynonym.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj34148.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj42082.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj61102.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj31648" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>DROP SCHEMA æ</title>
+</head>
+<body id="rrefsqlj31648"><a name="rrefsqlj31648"><!-- --></a>
+
+
+<h1 class="topictitle1">DROP SCHEMA æ</h1>
+
+
+<div>
+<div class="section"> <p>DROP SCHEMA æã«ããã¹ãã¼ããç ´æ£ã§ãã¾ãã
+ç ´æ£ããã¹ãã¼ãã¯ç©ºã§ç¡ããã°ãªãã¾ããã</p>
+ <p><em>APP</em>ã¹ãã¼ã(æ¢å®ã®ã¦ã¼ã¶ã¹ãã¼ãã§ãã)ã<em>SYS</em>ã¹ãã¼ãã¯ç ´æ£ã§ãã¾ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>DROP SCHEMA <em><a href="rrefschemaname.html#rrefschemaname">ã¹ãã¼ãå</a></em> RESTRICT</strong></pre>
+
+<p>RESTRICTãã¼ã¯ã¼ãã«ãããã¼ã¿ãã¼ã¹ããç ´æ£ãããã¨ããã¹ãã¼ãã«ã¯ãæ
å ±ããã£ã¦ã¯ãªããªããã¨ãæå®ãã¾ãããã®RESTRICTãã¼ã¯ã¼ãã¯å¿
é ã§ãã</p>
+ </div>
+
+<div class="example"> <pre><strong><span>-- SAMP ã¹ãã¼ããç ´æ£ãã¾ãã
+-- SAMPã¹ãã¼ãããã¼ã¿ãã¼ã¹ããåé¤ã§ããã®ã¯ã
+-- ã¹ãã¼ãã«æ
å ±ãå®ç¾©ããã¦ããªãã¨ãã®ã¿ã§ãã</span>
+DROP SCHEMA SAMP RESTRICT</strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj80721.html" title="">DROPæ</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefdropfunctionstatement.html" title="">DROP FUNCTION æ</a></div>
+<div><a href="rrefsqlj59893.html" title="">DROP INDEX æ</a></div>
+<div><a href="rrefdropprocedurestatement.html" title="">DROP PROCEDURE æ</a></div>
+<div><a href="rrefsqljdropsynonym.html" title="">DROP SYNONYM æ</a></div>
+<div><a href="rrefsqlj34148.html" title="">DROP TABLE æ</a></div>
+<div><a href="rrefsqlj42082.html" title="">DROP TRIGGER æ</a></div>
+<div><a href="rrefsqlj61102.html" title="">DROP VIEW æ</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31648.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31783.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31783.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31783.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,83 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="FOR UPDATE ç¯" />
+<meta content="FOR UPDATE clause, Cursors" name="DC.subject" />
+<meta content="FOR UPDATE clause, Cursors" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefclauses.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj31783" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>FOR UPDATE ç¯</title>
+</head>
+<body id="rrefsqlj31783"><a name="rrefsqlj31783"><!-- --></a>
+
+
+<h1 class="topictitle1">FOR UPDATE ç¯</h1>
+
+
+<div>
+<div class="section">
+<p><a href="rrefsqlj41360.html#rrefsqlj41360">SELECTæ</a>ã«ã¯FOR UPDATEç¯ãæããããã¨ãã§ãã¾ãã
+æ¢å®ã§ã«ã¼ã½ã«ã¯èªã¿è¾¼ã¿ããã§ãã¾ãããFOR UPDATEç¯ã«ãããã³ã³ãã¤ã«ä¸ã«SELECTæãæ´æ°å¯è½ãª<em>ã«ã¼ã½ã«</em>ã®å¿
è¦æ¡ä»¶ãæºããããæ¤è¨¼ãã¦ãã«ã¼ã½ã«ãæ´æ°å¯è½ã¨ãã¾ãã
+æ´æ°å¯è½ã§ãããã¨ã®è©³ç´°ã«ã¤ãã¦ã¯ã<a href="rrefsqlj41360.html#rrefsqlj41360__sqlj15384">æ´æ°å¯è½ãªã«ã¼ã½ã«ã®å¿
è¦æ¡ä»¶</a>ãåç
§ãã¦ãã ããã</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>FOR
+{
+ READ ONLY | FETCH ONLY |
+ UPDATE [ OF <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">åç´åå</a></em> [ , <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">åç´åå</a></em>]* ]
+}</strong></pre>
+ <p><em>åç´åå</em> ã«ãããåãåããæã®FROMç¯ã«ãã表ã«ã¦ãå¯è¦ãªååãåç
§ãã¾ãã</p>
+
+</div>
+
+<div class="section">
+<div class="p"><div class="note"><span class="notetitle">注: </span>æ´æ°å¯è½ãªJDBCã®ResultSetãå¾ãããã«ãå¿
ãããFOR UPDATEç¯ã使ãå¿
è¦ã¯ããã¾ããã
+JDBCã®ResultSetã®å
ã¨ãªãæããæ´æ°å¯è½ãªã«ã¼ã½ã«ã®å¿
è¦æ¡ä»¶ãæºããã¦ããããã°ãJDBC Statementããã並è¡å¦çã¢ã¼ãã<samp class="codeph">ResultSet.CONCUR_UPDATABLE</samp>ã®JDBC ResultSetãçæãããã¨ãã§ãã¾ãã
+</div>
+</div>
+
+<p>ç´¢å¼ã®åãæ´æ°ããã¦ãã¦ããç´¢å¼ã使ã£ãæé©åãå¯è½ã§ããç´¢å¼ãã©ã®ããã«ã«ã¼ã½ã«ã«å½±é¿ãããã«ã¤ãã¦ã¯ã<cite><span><em>Derbyã®ãã¥ã¼ãã³ã°</em></span></cite>ãåç
§ãã¦ãã ããã</p>
+
+</div>
+
+<div class="example"> <pre><strong>SELECT RECEIVED, SOURCE, SUBJECT, NOTE_TEXT FROM SAMP.IN_TRAY FOR UPDATE
+</strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefclauses.html" title="">SQL ç¯</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31783.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32268.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32268.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32268.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,112 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="SET SCHEMA æ" />
+<meta content="SET SCHEMA statement, Schemas, changing default for session" name="DC.subject" />
+<meta content="SET SCHEMA statement, Schemas, changing default for session" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj35312.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj41180.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj32268" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>SET SCHEMA æ</title>
+</head>
+<body id="rrefsqlj32268"><a name="rrefsqlj32268"><!-- --></a>
+
+
+<h1 class="topictitle1">SET SCHEMA æ</h1>
+
+
+<div>
+<div class="section"> <p>SET SCHEMA æã«ãããæ¥ç¶ã®æ¢å®ã¹ãã¼ããæå®ããã¹ãã¼ãã«è¨å®ã§ãã¾ãã
+æ¥ç¶ããçºè¡ãããæã«ã¦å¯¾è±¡ã®ã¹ãã¼ãåãæ示çã«æå®ããªãã£ãå ´åãæ¢å®ã¹ãã¼ãã対象ã®ã¹ãã¼ãã¨ãªãã¾ãã</p>
+
+<p>SET SCHEMAæãæåè£ã«å®è¡ããããã«ã¯ãè¨å®ããã¹ãã¼ããåå¨ãã¦ããªããã°ãªãã¾ããã
+ã¹ãã¼ããåå¨ãã¦ããªããã°ãã¨ã©ã¼ã¨ãªãã¾ãã<a href="rrefsqlj31580.html#rrefsqlj31580">CREATE SCHEMA æ</a>ãåç
§ãã¦ãã ããã</p>
+
+<p>SET SCHEMA æã¯ãã©ã³ã¶ã¯ã·ã§ã³å¦çããã¾ãããããããSET SCHEMA æãå®è¡ãããã¨ããã©ã³ã¶ã¯ã·ã§ã³ããã¼ã«ããã¯ããã¦ããSET SCHEMA æã«ããå¤æ´ãããã¹ãã¼ãã®ã¾ã¾ã§ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>SET [CURRENT] SCHEMA [=]
+{ <em><a href="rrefschemaname.html#rrefschemaname">ã¹ãã¼ãå</a> </em>|
+USER | ? | '<æååå®æ°>' } | SET CURRENT SQLID [=]
+{
+<em><a href="rrefschemaname.html#rrefschemaname">ã¹ãã¼ãå</a> </em>| USER | ? | '<æååå®æ°>' }</strong></pre>
+
+<p><em><a href="rrefschemaname.html#rrefschemaname">ã¹ãã¼ãå</a></em>ã¯æ大ã§128æåãããªãèå¥åã§ããã¹ãã¼ãåã¯äºéå¼ç¨ç¬¦ã§å²ã¾ããªãéãã大æåå°æåãåºå¥ãã¾ããã(ä¾ãæããã¨ãSYSã¯sYsãSYsãsysã®ãããã¨ãç価ã§ãã)</p>
+
+<p>USERã¯ç¾å¨ã®ã¦ã¼ã¶ã§ããç¾å¨ã®ã¦ã¼ã¶ãå®ç¾©ããã¦ããªãå ´åãç¾å¨ã®ã¹ãã¼ãã¯æ¢å®ã§<em>APP</em>ã§ãã(æ¥ç¶ã«ã¦ã¼ã¶åãå®ç¾©ããã¦ããå ´åããã®ã¦ã¼ã¶åã«å¯¾å¿ããã¹ãã¼ãããããªãããããæ¥ç¶ã®æ¢å®ã®ã¹ãã¼ãã¨ãªãã¾ãã</p>
+
+<p>? ã¯æºåãããæã§å©ç¨ã§ããåçãªå¼æ°ã§ããSET SCHEMAæãæºåãã¦ãç°ãªãã¹ãã¼ããå¤ã«ã¨ã£ã¦å®è¡ãããã¨ãã§ãã¾ãããã®ã¨ãã¹ãã¼ãã®å¤ã¯æååå®æ°ã¨æ±ããã大æåå°æåãåºå¥ããã¾ããä¾ãã°ã<em>APP</em>ãæå®ããã«ã¯ã"app"ã§ã¯ãªã"APP"ã使ãã¾ãã</p>
+ </div>
+
+<div class="example"> <pre><strong><span>-- 以ä¸ã®ä¾ã¯å
¨ã¦ç価ã§ã
+-- HOTELã¨ããã¹ãã¼ããããã°åä½ãã¾ãã</span>
+SET SCHEMA HOTEL
+SET SCHEMA hotel
+SET CURRENT SCHEMA hotel
+SET CURRENT SQLID hotel
+SET SCHEMA = hotel
+SET CURRENT SCHEMA = hotel
+SET CURRENT SQLID = hotel
+SET SCHEMA "HOTEL" <span>-- ã¯ã©ã¼ããããèå¥å</span>
+SET SCHEMA 'HOTEL' <span>-- ã¯ã©ã¼ããããæåå</span>
+ <span>--å°æåã®hotelã¯åå¨ããªãã®ã§ã
+ --ãã®ä¾ã¯ã¨ã©ã¼ã¨ãªãã¾ãã</span>
+SET SCHEMA = 'hotel'
+<span> --SQLIDã¯CURRENTã¨ã¨ãã«ä½¿ããªããã°ãªããªãã®ã§ã
+ --ãã®ä¾ã¯å¤±æãã¾ãã</span>
+SET SQLID hotel
+<span> -- ããã«ããã¹ãã¼ãã¯ç¾å¨ã®ã¦ã¼ã¶IDã«è¨å®ããã¾ãã</span>
+SET CURRENT SCHEMA USER
+<span>// Javaã®ããã°ã©ã ã§set schemaã使ãä¾ã§ãã</span>
+PreparedStatement ps = conn.PrepareStatement("set schema ?");
+ps.setString(1,"HOTEL");
+ps.executeUpdate();
+... do some work
+ps.setString(1,"APP");
+ps.executeUpdate();
+
+ps.setString(1,"app"); <span>//error - string is case sensitive
+// no app will be found </span>
+ps.setNull(1, Types.VARCHAR); <span>//error - null is not allowed</span> </strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj35312.html" title="">SET æ</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefsqlj41180.html" title="">SET ISOLATION æ</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32268.html
------------------------------------------------------------------------------
svn:eol-style = native