May 28, 2020 at 12:00 am
Comments posted to this topic are about the item The Basics of Using a Sequence as a Table Default
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 28, 2020 at 12:07 pm
Aha! Great article, and I can immediately see a use case for having unique numbers even across different tables, where both tables get the number generated by the same sequence. e.g:
INSERT Table1 -- generates 1
INSERT Table1 -- generates 2
INSERT Table2 -- generates 3
INSERT Table1 -- generates 4
INSERT Table1 -- generates 5
INSERT Table2 -- generates 6
INSERT Table2 -- generates 7
INSERT Table2 -- generates 8
May 30, 2020 at 7:05 pm
Aha! Great article, and I can immediately see a use case for having unique numbers even across different tables, where both tables get the number generated by the same sequence. e.g:
INSERT Table1 -- generates 1
INSERT Table1 -- generates 2
INSERT Table2 -- generates 3
INSERT Table1 -- generates 4
INSERT Table1 -- generates 5
INSERT Table2 -- generates 6
INSERT Table2 -- generates 7
INSERT Table2 -- generates 8
That a good demonstration but why would you need to do such a thing that wouldn't be a violation of good design? Not trying to start a fight here. I just can't think of a good reason to do such a thing.
--Jeff Moden
May 30, 2020 at 7:06 pm
Steve, great article. Thanks for taking the time to write it up, work out the nice simple demo's and post it all. Well done!
--Jeff Moden
May 31, 2020 at 3:35 pm
This was removed by the editor as SPAM
May 31, 2020 at 7:57 pm
i also want some details
Details on what? Don't expect folks to read every post on this thread to figure out what you're talking about. Be specific or quote the post you're identifying with! 😉
--Jeff Moden
February 25, 2022 at 6:47 am
This was removed by the editor as SPAM
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply