tag:blogger.com,1999:blog-13265058.post3242162832752340792..comments2011-11-17T15:42:25.930+11:00Comments on Sydney Oracle Lab: Wish List III - The Sequence ComethGary Myershttps://profiles.google.com/116132019768637593422noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-13265058.post-39477196325147528332011-11-17T15:42:25.930+11:002011-11-17T15:42:25.930+11:00I think it would also be good to provide a sequenc...I think it would also be good to provide a sequence as a DEFAULT value for a column.Scott Wesleyhttp://www.blogger.com/profile/18106937181788036683noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-87498571630291162072011-11-17T10:14:40.961+11:002011-11-17T10:14:40.961+11:00"so there is some metadata about the relation..."so there is some metadata about the relationship"<br />That is indeed a very good point!<br /><br />Most of the time we do not know in which table(s) any given sequence is used...<br /><br />MSSQL has one over Oracle in there, as you associate a PK of a table with a sequence-like increase. In a nutshell, an internalised trigger that sets the PK to the next unique value upon an insert. No chance of using the wrong sequence.Noonshttp://www.blogger.com/profile/04285930853937157148noreply@blogger.com