{"id":1018,"date":"2024-04-16T10:25:21","date_gmt":"2024-04-16T01:25:21","guid":{"rendered":"http:\/\/inwelly.com\/?p=1018"},"modified":"2024-05-01T02:24:38","modified_gmt":"2024-04-30T17:24:38","slug":"oracle-%ed%95%b4%eb%8b%b9%ec%9b%94-%ec%b2%ab%eb%82%a0-%ea%b8%b0%ec%a4%80%ec%9c%bc%eb%a1%9c-%ec%9b%94%ec%9d%98-%eb%a7%88%ec%a7%80%eb%a7%89%eb%82%a0-%ec%9d%b4%ec%a0%84%eb%8b%ac%ec%9d%98-%ec%b2%ab","status":"publish","type":"post","link":"https:\/\/inwelly.com\/?p=1018","title":{"rendered":"ORACLE \ud574\ub2f9\uc6d4 \uccab\ub0a0 \uae30\uc900\uc73c\ub85c \uc6d4\uc758 \ub9c8\uc9c0\ub9c9\ub0a0 , \uc774\uc804\ub2ec\uc758 \uccab\ub0a0 \ub9c8\uc9c0\ub9c9\ub0a0 \uad6c\ud558\uae30"},"content":{"rendered":"\n<p>\ud574\ub2f9\uc6d4\uc758 \uccab\ub0a0 : 2019-07-01<\/p>\n\n\n\n<p>select biz_cdts , count(*)&nbsp; from member_base&nbsp;<\/p>\n\n\n\n<p>where TRUNC(join_dtm, &#8216;MM&#8217;) = &#8216;2019-07-01&#8217;<\/p>\n\n\n\n<p>group by biz_cdts&nbsp;<\/p>\n\n\n\n<p>select biz_cdts , count(*)&nbsp; from member_base&nbsp;<\/p>\n\n\n\n<p>where TRUNC(join_dtm, &#8216;MM&#8217;) = TRUNC( trunc(to_date(&#8216;2019-07-01&#8242;,&#8217;RRRR-MM-DD&#8217;),&#8217;MM&#8217;) -1 , &#8216;MM&#8217;)&nbsp;<\/p>\n\n\n\n<p>group by biz_cdts&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud574\ub2f9\uc6d4\uc758 \uccab\ub0a0 : 2019-07-01 select biz_cdts , count(*)&nbsp; from member_base&nbsp; where TRUNC(join_dtm, &#8216;MM&#8217;) = &#8216;2019-07-01&#8217; group by biz_cdts&nbsp; select biz_cdts [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1707,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[107],"tags":[],"class_list":["post-1018","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-etc"],"_links":{"self":[{"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/posts\/1018","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/inwelly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1018"}],"version-history":[{"count":1,"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/posts\/1018\/revisions"}],"predecessor-version":[{"id":1019,"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/posts\/1018\/revisions\/1019"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/media\/1707"}],"wp:attachment":[{"href":"https:\/\/inwelly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inwelly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inwelly.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}