{"id":1110,"date":"2019-06-21T10:00:13","date_gmt":"2019-06-21T01:00:13","guid":{"rendered":"http:\/\/www.climb.co.jp\/blog_dbmoto\/?p=1110"},"modified":"2019-06-21T17:25:51","modified_gmt":"2019-06-21T08:25:51","slug":"%e5%a4%96%e9%83%a8%e3%82%ad%e3%83%bc%e3%81%8c%e8%a8%ad%e5%ae%9a%e3%81%95%e3%82%8c%e3%81%9f%e8%a6%aa%e5%ad%90%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e3%82%92%e3%83%ac%e3%83%97%e3%83%aa%e3%82%b1%e3%83%bc","status":"publish","type":"post","link":"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/1110","title":{"rendered":"\u5916\u90e8\u30ad\u30fc\u304c\u8a2d\u5b9a\u3055\u308c\u305f\u89aa\u5b50\u30c6\u30fc\u30d6\u30eb\u306e\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u306e\u6ce8\u610f\u70b9\u3068\u7c21\u5358\u8a2d\u5b9a\u65b9\u6cd5"},"content":{"rendered":"\n

DBMoto\u3067\u5916\u90e8\u30ad\u30fc\u304c\u8a2d\u5b9a\u3055\u308c\u305f\u89aa\u5b50\u30c6\u30fc\u30d6\u30eb\u3092\u5171\u306b\u5168\u4ef6\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u306b\u3088\u308b\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u884c\u3046\u5834\u5408\u306b\u306f\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n\n

\u53c2\u7167\u3055\u308c\u308b\u30c6\u30fc\u30d6\u30ebA\u3092\u89aa\u3001\u53c2\u7167\u3059\u308b\u30c6\u30fc\u30d6\u30ebB\uff08\u5916\u90e8\u30ad\u30fc\u8a2d\u5b9a\uff09\u3092\u5b50\u3068\u3057\u305f\u5834\u5408\u3001
\u767b\u9332\u3059\u308b\u5834\u5408\u306fA\u304b\u3089\u3001\u524a\u9664\u3059\u308b\u5834\u5408\u306fB\u304b\u3089\u3067\u3042\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

DBMoto\u3067\u30c6\u30fc\u30d6\u30ebA\u3068B\u3092\u30b0\u30eb\u30fc\u30d7\u5316\u3057\u3066\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u3092\u884c\u3046\u5834\u5408\u306f\u901a\u5e38\u4e0b\u8a18\u306e\u624b\u9806\u304c\u3068\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n

1-1. \u30c6\u30fc\u30d6\u30ebA\u3092Truncate
1-2. \u30c6\u30fc\u30d6\u30ebA\u306bInsert
1-3. \u30c6\u30fc\u30d6\u30ebB\u3092Truncate
1-4. \u30c6\u30fc\u30d6\u30ebB\u306bInsert<\/p>\n\n\n\n

\u3057\u304b\u3057\u3053\u306e\u624b\u9806\u3067\u306f\u5916\u90e8\u30ad\u30fc\u5236\u7d04\u9055\u53cd\u306e\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u3066\u3057\u307e\u3044\u307e\u3059\u3002
\u3053\u308c\u3092\u5b9f\u969b\u306b\u306f\u4e0b\u8a18\u306e\u624b\u9806\u3067\u884c\u308f\u306a\u3051\u308c\u3070\u306a\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n

2-1. \u30c6\u30fc\u30d6\u30ebB\u3092Truncate
2-2. \u30c6\u30fc\u30d6\u30ebA\u3092Truncate
2-3. \u30c6\u30fc\u30d6\u30ebA\u306bInsert
2-4. \u30c6\u30fc\u30d6\u30ebB\u306bInsert<\/p>\n\n\n\n

\u3053\u306e\u624b\u9806\u306e\u51e6\u7406\u3092\u884c\u3046\u305f\u3081\u306b\u3001
DBMoto\u3067\u4e0b\u8a18\u306e\u901a\u308a\u8a2d\u5b9a\u5909\u66f4\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

\u307e\u305aDBMoto\u3067 2-3\/2-4 \u306eInsert\u51e6\u7406\u3092\u9806\u756a\u901a\u308a\u306b\u884c\u3046\u305f\u3081\u306b\u30b0\u30eb\u30fc\u30d7\u306b\u6240\u5c5e\u3059\u308b\u5404\u30c6\u30fc\u30d6\u30eb\u306e\u51e6\u7406\u512a\u5148\u9806\u4f4d\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002
<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

\u3057\u304b\u3057\u3053\u306e\u307e\u307e\u3060\u3068Truncate\u306e2-1\/2-2\u306e\u51e6\u7406\u3082\u3053\u306e\u512a\u5148\u9806\u4f4d\u901a\u308a\u306b\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u3002
Truncate\u306f\u9006\u306e\u9806\u5e8f\u3067\u884c\u3046\u5fc5\u8981\u304c\u3042\u308b\u305f\u3081\u3001[Truncate Inverse]\u306e\u8a2d\u5b9a\u3092 True \u306b\u3057\u307e\u3059\u3002
<\/p>\n\n\n\n

\u4ee5\u4e0a\u3067\u6b63\u5e38\u306b\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u884c\u3046\u3053\u3068\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

\u305f\u3060\u3001\u5c11\u6570\u306e\u30c6\u30fc\u30d6\u30eb\u3067\u3042\u3089\u3070\u3001\u3053\u308c\u3067\u3082\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u304c\u3001\u6570\u304b\u5897\u3048\u3066\u304f\u308b\u3068\u3044\u3061\u3044\u3061\u30dc\u30bf\u30f3\u3067\u4e26\u3073\u66ff\u3048\u306f\u624b\u9593\u3068\u306a\u308a\u307e\u3059\u3002\u3053\u306e\u3088\u3046\u306a\u5834\u5408\u306b\u306f\u53f3\u4e0b\u306e\u9375\u30de\u30fc\u30af\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u4e0a\u8a18\u306ereplication2, 3, 1\u3068\u30b0\u30eb\u30fc\u30d7\u306b\u8ffd\u52a0\u3055\u308c\u3066\u3044\u307e\u3059\u304c\u3001\u4f9d\u5b58\u95a2\u4fc2\u3068\u3057\u3066\u306f1, 2, 3\u3068\u306a\u308b\u3079\u304d\u3082\u306e\u3067\u3059\u3002\u305d\u3053\u3067\u9375\u30de\u30fc\u30af\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u624b\u52d5\u3067\u52d5\u304b\u3055\u306a\u304f\u3068\u3082\u3001DBMoto\u304c\u8aad\u307f\u53d6\u3063\u3066\u3044\u308b\u5916\u90e8\u30ad\u30fc\u60c5\u5831\u306b\u57fa\u3065\u304d\u4e0b\u8a18\u306e\u3088\u3046\u306b\u81ea\u52d5\u3067\u4e26\u3073\u66ff\u3048\u3092\u3057\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u4f8b\u3048\u3070\u3001Oracle\u3067\u4e0b\u8a18\u306e\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3059\u308b\u5834\u5408\u306b\u306f\u4e0a\u8a18\u624b\u9806\u306b\u3066\u30b0\u30eb\u30fc\u30d7\u5316\u3057\u3001\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n

ORA-02291: \u6574\u5408\u6027\u5236\u7d04(string.string)\u306b\u9055\u53cd\u3057\u307e\u3057\u305f – \u89aa\u30ad\u30fc\u304c\u3042\u308a\u307e\u305b\u3093
ORA-02292: \u6574\u5408\u6027\u5236\u7d04(string.string)\u306b\u9055\u53cd\u3057\u307e\u3057\u305f – \u5b50\u30ec\u30b3\u30fc\u30c9\u304c\u3042\u308a\u307e\u3059<\/p>\n","protected":false},"excerpt":{"rendered":"

DBMoto\u3067\u5916\u90e8\u30ad\u30fc\u304c\u8a2d\u5b9a\u3055\u308c\u305f\u89aa\u5b50\u30c6\u30fc\u30d6\u30eb\u3092\u5171\u306b\u5168\u4ef6\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u306b\u3088\u308b\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u884c\u3046\u5834\u5408\u306b\u306f\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002 \u53c2\u7167\u3055\u308c\u308b\u30c6\u30fc\u30d6\u30ebA\u3092\u89aa\u3001\u53c2\u7167\u3059\u308b\u30c6\u30fc\u30d6\u30ebB\uff08\u5916\u90e8\u30ad\u30fc\u8a2d\u5b9a\uff09\u3092\u5b50\u3068\u3057\u305f\u5834\u5408\u3001\u767b\u9332\u3059\u308b\u5834\u5408\u306fA\u304b\u3089\u3001 … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[96],"class_list":["post-1110","post","type-post","status-publish","format-standard","hentry","category-syniti","tag-96"],"_links":{"self":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/1110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/comments?post=1110"}],"version-history":[{"count":4,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/1110\/revisions"}],"predecessor-version":[{"id":4565,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/1110\/revisions\/4565"}],"wp:attachment":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/media?parent=1110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/categories?post=1110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/tags?post=1110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}