{"id":83,"date":"2014-01-29T15:36:00","date_gmt":"2014-01-29T08:36:00","guid":{"rendered":"https:\/\/mohn.ru\/?p=83"},"modified":"2014-01-29T15:36:00","modified_gmt":"2014-01-29T08:36:00","slug":"%d1%88%d0%bf%d0%b0%d1%80%d0%b3%d0%b0%d0%bb%d0%ba%d0%b0-%d0%bf%d0%be-sql-%d0%b8-pl-sql-oracle-update-%d0%b8%d0%b7-%d0%b4%d1%80%d1%83%d0%b3%d0%be%d0%b9-%d1%82%d0%b0%d0%b1%d0%bb%d0%b8%d1%86%d1%8b","status":"publish","type":"post","link":"https:\/\/mohn.ru\/?p=83","title":{"rendered":"\u0428\u043f\u0430\u0440\u0433\u0430\u043b\u043a\u0430 \u043f\u043e SQL \u0438 PL\/SQL Oracle: update \u0438\u0437 \u0434\u0440\u0443\u0433\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b"},"content":{"rendered":"<p>\u0414\u043b\u044f \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u043f\u043e\u043b\u044f \u0438\u043b\u0438 \u043f\u043e\u043b\u0435\u0439 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0438\u0437 \u0434\u0440\u0443\u0433\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u043c\u043e\u0436\u043d\u043e \u0432\u043e\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c\u0441\u044f \u0442\u0430\u043a, \u043a\u0430\u043a \u043f\u043e\u043a\u0430\u0437\u0430\u043d\u043e \u0432 \u043f\u0440\u0438\u043c\u0435\u0440\u0435:<\/p>\n<p><a name='more'><\/a><\/p>\n<blockquote><p>\n<span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">update<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\"> <\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\">billgrouplog bgl<br \/><o:p><\/o:p><\/span><u><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">set<\/span><\/u><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\"> bgl<\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">.<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\">startdate <\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">=<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\"> <\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">(select<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\"> bg<\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">.<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\">changed<br \/><o:p><\/o:p><\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\">&nbsp;&nbsp;&nbsp; <\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">from<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\"><br \/>\natlant<\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">.<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\">billgroup bg<br \/><o:p><\/o:p><\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\">&nbsp;&nbsp;&nbsp; <\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">where<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\">&nbsp;<\/span><span lang=\"EN-US\" style=\"background-color: white; font-family: Courier; font-size: 10pt;\">bg<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; color: blue; font-family: Courier; font-size: 10pt;\">.<\/span><span lang=\"EN-US\" style=\"background-color: white; font-family: Courier; font-size: 10pt;\">cobillgroup <\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; color: blue; font-family: Courier; font-size: 10pt;\">=<\/span><span lang=\"EN-US\" style=\"background-color: white; font-family: Courier; font-size: 10pt;\"> bgl<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; color: blue; font-family: Courier; font-size: 10pt;\">.<\/span><span lang=\"EN-US\" style=\"background-color: white; font-family: Courier; font-size: 10pt;\">cobillgroup<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; color: blue; font-family: Courier; font-size: 10pt;\">)<\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">where<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\"> bgl<\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">.<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\">uptodate <\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">=<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\"> <\/span><span lang=\"EN-US\" style=\"background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">&#8216;01.01.2500&#8217;<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\">&nbsp;&nbsp;&nbsp; <\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">and<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\"> <\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">exists<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\"> <\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">(select<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\"> <\/span><span lang=\"EN-US\" style=\"background: white; color: maroon; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">1<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\">&nbsp;&nbsp;&nbsp; <\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">from<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\"><br \/>\natlant<\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">.<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\">billgroup bg<br \/><o:p><\/o:p><\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\">&nbsp;&nbsp;&nbsp; <\/span><span lang=\"EN-US\" style=\"background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;\">where<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Courier; font-size: 10pt;\">&nbsp;<\/span><span lang=\"EN-US\" style=\"background-color: white; font-family: Courier; font-size: 10pt; line-height: 115%;\">bg<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; color: blue; font-family: Courier; font-size: 10pt; line-height: 115%;\">.<\/span><span lang=\"EN-US\" style=\"background-color: white; font-family: Courier; font-size: 10pt; line-height: 115%;\">cobillgroup <\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; color: blue; font-family: Courier; font-size: 10pt; line-height: 115%;\">=<\/span><span lang=\"EN-US\" style=\"background-color: white; font-family: Courier; font-size: 10pt; line-height: 115%;\"> bgl<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; color: blue; font-family: Courier; font-size: 10pt; line-height: 115%;\">.<\/span><span lang=\"EN-US\" style=\"background-color: white; font-family: Courier; font-size: 10pt; line-height: 115%;\">cobillgroup<\/span><span lang=\"EN-US\" style=\"background-color: white; background-position: initial initial; background-repeat: initial initial; color: blue; font-family: Courier; font-size: 10pt; line-height: 115%;\">)<\/span><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>\u0414\u043b\u044f \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u043f\u043e\u043b\u044f \u0438\u043b\u0438 \u043f\u043e\u043b\u0435\u0439 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0438\u0437 \u0434\u0440\u0443\u0433\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u043c\u043e\u0436\u043d\u043e \u0432\u043e\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c\u0441\u044f \u0442\u0430\u043a, \u043a\u0430\u043a \u043f\u043e\u043a\u0430\u0437\u0430\u043d\u043e \u0432 \u043f\u0440\u0438\u043c\u0435\u0440\u0435: update billgrouplog bglset bgl.startdate = (select bg.changed&nbsp;&nbsp;&nbsp; from atlant.billgroup bg&nbsp;&nbsp;&nbsp; where&nbsp;bg.cobillgroup = bgl.cobillgroup)where bgl.uptodate = &#8216;01.01.2500&#8217;&nbsp;&nbsp;&nbsp; and exists (select 1&nbsp;&nbsp;&nbsp; from atlant.billgroup bg&nbsp;&nbsp;&nbsp; where&nbsp;bg.cobillgroup = bgl.cobillgroup)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[],"class_list":["post-83","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/mohn.ru\/index.php?rest_route=\/wp\/v2\/posts\/83","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mohn.ru\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohn.ru\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohn.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohn.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=83"}],"version-history":[{"count":0,"href":"https:\/\/mohn.ru\/index.php?rest_route=\/wp\/v2\/posts\/83\/revisions"}],"wp:attachment":[{"href":"https:\/\/mohn.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=83"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohn.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=83"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohn.ru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=83"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}