{"id":98,"date":"2013-11-14T18:59:00","date_gmt":"2013-11-14T11:59:00","guid":{"rendered":"https:\/\/mohn.ru\/?p=98"},"modified":"2013-11-14T18:59:00","modified_gmt":"2013-11-14T11:59: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-insert-%d0%b2-%d1%82%d0%b0%d0%b1%d0%bb%d0%b8%d1%86%d1%83-%d0%b3%d1%80%d1%83%d0%bf%d0%bf%d0%b8%d1%80%d0%be","status":"publish","type":"post","link":"https:\/\/mohn.ru\/?p=98","title":{"rendered":"\u0428\u043f\u0430\u0440\u0433\u0430\u043b\u043a\u0430 \u043f\u043e SQL \u0438 PL\/SQL Oracle: insert \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445"},"content":{"rendered":"

\u0415\u0441\u043b\u0438 \u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u0441\u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u043e \u043a\u0430\u043a\u043e\u0439 \u043b\u0438\u0431\u043e \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u0438 \u043f\u0435\u0440\u0435\u043d\u0435\u0441\u0442\u0438 \u0432 \u0434\u0440\u0443\u0433\u0443\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0441 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u043c \u043f\u043e\u043b\u0435\u043c \u043f\u0435\u0440\u0432\u0438\u0447\u043d\u044b\u043c \u043a\u043b\u044e\u0447\u0435\u043c, \u0442\u043e \u043c\u043e\u0436\u0435\u0442 \u0432\u043e\u0437\u043d\u0438\u043a\u043d\u0443\u0442\u044c \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u0430. \u041b\u0443\u0447\u0448\u0435 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u043d\u0435 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 ->
\n<\/a>
\n\u0422\u0430\u043a\u043e\u0439 \u043a\u043e\u0434 \u043d\u0435 \u0431\u0443\u0434\u0435\u0442 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c:<\/p>\n

\n
\ninsert<\/span> <\/span>into<\/span> <\/span>BCDRAGGREGATOR<\/span><\/o:p><\/span><\/div>\n
\nselect<\/span> S_COAGGREGATOR<\/span>.nextval<\/span> <\/span>as<\/span> coaggregator<\/span>,<\/span><\/o:p><\/span><\/div>\n
\n       <\/span>numident <\/span>as<\/span> identificator<\/span>,<\/span> <\/o:p><\/span><\/div>\n
\n       coerror<\/span>,<\/span><\/o:p><\/span><\/div>\n
\n       <\/span>count(<\/span>*<\/span>)<\/span> bcdrcount<\/o:p><\/span><\/div>\n
\n    <\/span>from<\/span> <\/span>badcdr<\/span><\/o:p><\/span><\/div>\n
\ngroup<\/span> <\/span>by<\/span> <\/span>numident<\/span>,<\/span> <\/o:p><\/span><\/div>\n
\n         coerror<\/span><\/div>\n<\/blockquote>\n

\u0410 \u0442\u0430\u043a\u043e\u0439 \u043a\u043e\u0434 \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442:<\/p>\n

\n
\ninsert<\/span> <\/span>into<\/span> <\/span>BCDRAGGREGATOR<\/span><\/o:p><\/span><\/div>\n
\nselect<\/span> S_BCDRAGGREGATOR<\/span>.nextval<\/span> <\/span>as<\/span> COAGGREGATOR<\/span>,<\/span><\/o:p><\/span><\/div>\n
\n       <\/span>a.<\/span>*<\/o:p><\/span><\/div>\n
\nfrom<\/span><\/o:p><\/span><\/div>\n
\n    <\/span>(select<\/span> numident <\/span>as<\/span> identificator<\/span>,<\/span> <\/o:p><\/span><\/div>\n
\n            coerror<\/span>,<\/span><\/o:p><\/span><\/div>\n
\n            d2d<\/span>.<\/span>id_dep<\/span>,<\/span><\/o:p><\/span><\/div>\n
\n            <\/span>count(<\/span>*<\/span>)<\/span> bcdrcount<\/o:p><\/span><\/div>\n
\n        <\/span>from<\/span> <\/span>badcdr<\/span><\/o:p><\/span><\/div>\n
\n    <\/span>group<\/span> <\/span>by<\/span> numident<\/span>,<\/span> <\/o:p><\/span><\/div>\n
\n             coerror<\/span>)<\/span> <\/span>a<\/span><\/div>\n<\/blockquote>\n

 \u0421\u0442\u043e\u0438\u0442 \u0431\u044b\u0442\u044c \u0432\u043d\u0438\u043c\u0430\u0442\u0435\u043b\u044c\u043d\u044b\u043c \u043a \u043e\u0448\u0438\u0431\u043a\u0430\u043c.<\/p>\n","protected":false},"excerpt":{"rendered":"

\u0415\u0441\u043b\u0438 \u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u0441\u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u043e \u043a\u0430\u043a\u043e\u0439 \u043b\u0438\u0431\u043e \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u0438 \u043f\u0435\u0440\u0435\u043d\u0435\u0441\u0442\u0438 \u0432 \u0434\u0440\u0443\u0433\u0443\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0441 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u043c \u043f\u043e\u043b\u0435\u043c \u043f\u0435\u0440\u0432\u0438\u0447\u043d\u044b\u043c \u043a\u043b\u044e\u0447\u0435\u043c, \u0442\u043e \u043c\u043e\u0436\u0435\u0442 \u0432\u043e\u0437\u043d\u0438\u043a\u043d\u0443\u0442\u044c \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u0430. \u041b\u0443\u0447\u0448\u0435 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u043d\u0435 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 -> \u0422\u0430\u043a\u043e\u0439 \u043a\u043e\u0434 \u043d\u0435 \u0431\u0443\u0434\u0435\u0442 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c: insert into BCDRAGGREGATOR select S_COAGGREGATOR.nextval as coaggregator,        numident as identificator,        coerror,        count(*) bcdrcount     from badcdr group by numident,          coerror […]<\/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-98","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/mohn.ru\/index.php?rest_route=\/wp\/v2\/posts\/98","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=98"}],"version-history":[{"count":0,"href":"https:\/\/mohn.ru\/index.php?rest_route=\/wp\/v2\/posts\/98\/revisions"}],"wp:attachment":[{"href":"https:\/\/mohn.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=98"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohn.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=98"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohn.ru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=98"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}