{"id":3909,"date":"2018-06-15T10:21:33","date_gmt":"2018-06-15T01:21:33","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3909"},"modified":"2018-06-15T10:21:33","modified_gmt":"2018-06-15T01:21:33","slug":"book-script-%ea%b1%b0%ec%9d%98-%eb%8b%a4-%ec%82%ac%ec%9a%a9%ed%95%9c-%ec%8b%9c%ed%80%80%ec%8a%a4-%ec%b0%be%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3909","title":{"rendered":"[Book Script]  \uac70\uc758 \ub2e4 \uc0ac\uc6a9\ud55c \uc2dc\ud000\uc2a4 \ucc3e\uae30"},"content":{"rendered":"<p>\uc2dc\ud000\uc2a4 OWNER \ub97c \ub123\uace0 USED \uceec\ub7fc\uc744 \ud655\uc778.<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"lang:plsql decode:true \">SQL&gt; SELECT\r\n   SEQUENCE_OWNER  \"OWNER\",\r\n   SEQUENCE_NAME   \"SEQUENCE\",\r\n   MIN_VALUE       \"MIN VALUE\",\r\n   MAX_VALUE       \"MAX VALUE\",\r\n   INCREMENT_BY    \"INCREASE\",\r\n   CYCLE_FLAG      \"CYCLE\",\r\n   ORDER_FLAG      \"ORDER\",\r\n   CACHE_SIZE      \"CACHE\",\r\n   LAST_NUMBER     \"LAST NUMBER\",\r\n   ROUND((LAST_NUMBER\/MAX_VALUE)*100) \"USED\"\r\nFROM       DBA_SEQUENCES\r\nWHERE SEQUENCE_OWNER IN ('HR')\r\nORDER BY 10 DESC ;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uc2dc\ud000\uc2a4 OWNER \ub97c \ub123\uace0 USED \uceec\ub7fc\uc744 \ud655\uc778. &nbsp; SQL&gt; SELECT SEQUENCE_OWNER &#8220;OWNER&#8221;, SEQUENCE_NAME &#8220;SEQUENCE&#8221;, MIN_VALUE &#8220;MIN VALUE&#8221;, MAX_VALUE &#8220;MAX VALUE&#8221;, INCREMENT_BY &#8220;INCREASE&#8221;, CYCLE_FLAG &#8220;CYCLE&#8221;, ORDER_FLAG &#8220;ORDER&#8221;, CACHE_SIZE &#8220;CACHE&#8221;, LAST_NUMBER &#8220;LAST NUMBER&#8221;, ROUND((LAST_NUMBER\/MAX_VALUE)*100) &#8220;USED&#8221; FROM DBA_SEQUENCES WHERE SEQUENCE_OWNER IN (&#8216;HR&#8217;) ORDER BY 10 DESC ;<\/p>\n","protected":false},"author":1,"featured_media":2880,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[1094],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/tips-newsletter.jpg?fit=680%2C530","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3909"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3909"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3909\/revisions"}],"predecessor-version":[{"id":3910,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3909\/revisions\/3910"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2880"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3909"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3909"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3909"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}