{"id":1291,"date":"2016-01-14T06:20:34","date_gmt":"2016-01-14T06:20:34","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1291"},"modified":"2016-01-14T06:20:34","modified_gmt":"2016-01-14T06:20:34","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-%ec%8b%9c%ed%80%80%ec%8a%a4-%ec%b4%88%ea%b8%b0%ed%99%94-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1291","title":{"rendered":"\uc624\ub77c\ud074 \uc2dc\ud000\uc2a4 \ucd08\uae30\ud654 \ubc29\ubc95"},"content":{"rendered":"

SQL> create sequence ots_seq;<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

Sequence created.<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

SQL> select  ots_seq.nextval from dual ;<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

   NEXTVAL<\/span><\/font><\/p>\n

———-<\/span><\/font><\/p>\n

         1<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

SQL> \/<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

   NEXTVAL<\/span><\/font><\/p>\n

———-<\/span><\/font><\/p>\n

         2<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

SQL> \/<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

   NEXTVAL<\/span><\/font><\/p>\n

———-<\/span><\/font><\/p>\n

         3<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

SQL> \/<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

   NEXTVAL<\/span><\/font><\/p>\n

———-<\/span><\/font><\/p>\n

         4<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

SQL> \/<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

   NEXTVAL<\/span><\/font><\/p>\n

———-<\/span><\/font><\/p>\n

         5<\/span><\/font><\/p>\n

<\/div>\n
–PL\/SQL \uc0dd\uc131<\/div>\n
<\/div>\n

 CREATE or REPLACE PROCEDURE reset_seq (seq_name IN VARCHAR2) as<\/p>\n

  curr_val INTEGER;<\/p>\n

 BEGIN
     EXECUTE IMMEDIATE ‘alter sequence ‘ ||seq_name<\/span>||’ MINVALUE 0′;
     EXECUTE IMMEDIATE ‘SELECT ‘ ||seq_name<\/span> ||’.nextval FROM dual’ INTO curr_val;
     EXECUTE IMMEDIATE ‘alter sequence ‘ ||seq_name<\/span>||’ increment by -‘||curr_val;
     EXECUTE IMMEDIATE ‘SELECT ‘ ||seq_name<\/span> ||’.nextval FROM dual’ INTO curr_val;
     EXECUTE IMMEDIATE ‘alter sequence ‘ ||seq_name<\/span>||’ increment by 1′;
 END reset_seq;
\/<\/p>\n


<\/span><\/p>\n

 <\/span><\/p>\n

Procedure created.<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

SQL> exec reset_seq(‘ots_seq’);<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

PL\/SQL procedure successfully completed.<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

SQL>  select  ots_seq.nextval from dual ;<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

   NEXTVAL<\/span><\/font><\/p>\n

———-<\/span><\/font><\/p>\n

         1<\/span><\/font><\/p>\n


<\/span><\/font><\/p>\n

SQL><\/span><\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

SQL> create sequence ots_seq; Sequence created. SQL> select  ots_seq.nextval from dual ;    NEXTVAL ———-          1 SQL> \/    NEXTVAL ———-          2 SQL> \/    NEXTVAL ———-          3 SQL> \/    NEXTVAL ———-          4 SQL> \/    NEXTVAL ———- […]<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[14],"tags":[692,693,694,695,696],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1291"}],"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=1291"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1291\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1291"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}