{"id":4071,"date":"2016-06-18T13:12:57","date_gmt":"2016-06-18T13:12:57","guid":{"rendered":"http:\/\/putridparrot.com\/blog\/?p=4071"},"modified":"2016-06-18T13:12:57","modified_gmt":"2016-06-18T13:12:57","slug":"autonumberunique-sequential-values-in-oracle","status":"publish","type":"post","link":"https:\/\/putridparrot.com\/blog\/autonumberunique-sequential-values-in-oracle\/","title":{"rendered":"Autonumber\/Unique sequential values in Oracle"},"content":{"rendered":"<p>I haven&#8217;t had to do much with Oracle for a while and totally forgot how to create the next &#8220;autonumber&#8221; or &#8220;sequence&#8221; for a table&#8217;s ID key. So here&#8217;s a reminder.<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\ninto PERSON (CREATEDDATE, ID, ...) \r\nvalues (SYSDATE, PERSON_seq.NEXTVAL, ...)\r\n<\/pre>\n<p><strongReferences<\/strong><\/p>\n<p><a href=\"https:\/\/docs.oracle.com\/cd\/B28359_01\/server.111\/b28286\/pseudocolumns002.htm\" target=\"_blank\">Sequence Pseudocolumns<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I haven&#8217;t had to do much with Oracle for a while and totally forgot how to create the next &#8220;autonumber&#8221; or &#8220;sequence&#8221; for a table&#8217;s ID key. So here&#8217;s a reminder. into PERSON (CREATEDDATE, ID, &#8230;) values (SYSDATE, PERSON_seq.NEXTVAL, &#8230;)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[52],"tags":[],"class_list":["post-4071","post","type-post","status-publish","format-standard","hentry","category-oracle"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/4071","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/comments?post=4071"}],"version-history":[{"count":3,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/4071\/revisions"}],"predecessor-version":[{"id":4075,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/4071\/revisions\/4075"}],"wp:attachment":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/media?parent=4071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/categories?post=4071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/tags?post=4071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}