{"id":11798,"date":"2023-10-01T20:55:16","date_gmt":"2023-10-01T19:55:16","guid":{"rendered":"https:\/\/roglacup.com\/klaus62\/?p=11798"},"modified":"2023-10-31T18:41:28","modified_gmt":"2023-10-31T17:41:28","slug":"zaporedja-sekvence","status":"publish","type":"post","link":"https:\/\/roglacup.com\/klaus62\/2023\/10\/01\/zaporedja-sekvence\/","title":{"rendered":"Zaporedja (sekvence)"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Kaj je sekvenca ? <\/h3>\n\n\n\n<p>Sekvenca je bazni objekt, ki smo ga ustvarili za generiranje numeri\u010dnih vrednosti.<\/p>\n\n\n\n<p>Med delom s tabelami v zbirki podatkov Oracle z omejitvijo primarnega klju\u010da moramo pogosto v tabelo vstaviti novo vrstico in ro\u010dno vnesti vrednost primarnegaklju\u010da tako, da zaporedoma pove\u010damo prej\u0161njo vrednost. To lahko postane dolgo\u010dasno pri delu z velikimi tabelami z ogromnimi nabori podatkov.<\/p>\n\n\n\n<p>Sekvenca ( zaporedje) je objekt, ki samodejno preveri vrednost prej\u0161njega primarnega klju\u010da in ga pri vstavljanju nove vrstice pove\u010da za vrednost ( kot smo jo dolo\u010dili ).<\/p>\n\n\n\n<p>Primer :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>kreiramo tabelo zaposlenih *<\/li>\n<\/ul>\n\n\n\n<p>CREATE TABLE zaposleni<br>(<br>zaposleni_id NUMBER(10) PRIMARY KEY,<br>ime VARCHAR(10),<br>priimek VARCHAR(10)<br>)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>vstavimo nekaj zapisov<\/li>\n<\/ul>\n\n\n\n<p>INSERT INTO zaposleni VALUES(101, &#8216;Jure&#8217;,<br>&#8216;Tepina&#8217;);<br>INSERT INTO zaposleni VALUES(102, &#8216;Andra\u017e&#8217;,<br>&#8216;Kralj&#8217;);<br>INSERT INTO zaposleni VALUES(103, &#8216;Iztok&#8217;,<br>&#8216;Podbev\u0161ek&#8217;);<\/p>\n\n\n\n<p>select * from zaposleni<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"257\" height=\"89\" src=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/10\/image-3.png\" alt=\"\" class=\"wp-image-11799\"\/><\/figure>\n\n\n\n<p>CREATE SEQUENCE test_seq2<br>INCREMENT BY 1<br>START WITH 201<br>MAXVALUE 999<br>CACHE 50<br>NOCYCLE;<\/p>\n\n\n\n<p>SELECT test_seq2.NEXTVAL FROM DUAL<\/p>\n\n\n\n<p>SELECT test_seq2.NEXTVAL FROM DUAL<\/p>\n\n\n\n<p>SELECT test_seq2.CURRVAL FROM DUAL<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"111\" height=\"47\" src=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/10\/image-4.png\" alt=\"\" class=\"wp-image-11800\"\/><\/figure>\n\n\n\n<p>INSERT INTO zaposleni VALUES(test_seq2.NEXTVAL, &#8216;Andrej&#8217;,<br>&#8216;Kopitar&#8217;);<br>INSERT INTO zaposleni VALUES(test_seq2.NEXTVAL, &#8216;Tine&#8217;,<br>&#8216;Ti\u010d&#8217;);<\/p>\n\n\n\n<p>select * from zaposleni<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"256\" height=\"121\" src=\"https:\/\/roglacup.com\/klaus62\/wp-content\/uploads\/2023\/10\/image-5.png\" alt=\"\" class=\"wp-image-11801\"\/><\/figure>\n\n\n\n<p>SELECT * FROM user_sequences;<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>SELECT * FROM all_sequences;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kaj je sekvenca ? Sekvenca je bazni objekt, ki smo ga ustvarili za generiranje numeri\u010dnih vrednosti. Med delom s tabelami v zbirki podatkov Oracle z omejitvijo primarnega klju\u010da moramo pogosto v tabelo vstaviti novo vrstico in ro\u010dno vnesti vrednost primarnegaklju\u010da tako, da zaporedoma pove\u010damo prej\u0161njo vrednost. To lahko postane dolgo\u010dasno pri delu z velikimi tabelami&hellip;&nbsp;<a href=\"https:\/\/roglacup.com\/klaus62\/2023\/10\/01\/zaporedja-sekvence\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Zaporedja (sekvence)<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[1299],"tags":[1313],"class_list":["post-11798","post","type-post","status-publish","format-standard","hentry","category-1z0-082","tag-sequences"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/11798","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/comments?post=11798"}],"version-history":[{"count":4,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/11798\/revisions"}],"predecessor-version":[{"id":11895,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/11798\/revisions\/11895"}],"wp:attachment":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media?parent=11798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/categories?post=11798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/tags?post=11798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}