Why do some people do not like the sequence on Oracle? I think they are very easy to use and very good you can use them to select, inserts, update, ... ...
I do not. I should say that sometimes people hate the hatred that they do not understand.
The visuals are incredibly important for generating unique IDs. Conceptually, there is a method of generating an ID that does not depend on the content of a table. You do not need to lock a table to generate a unique number.
Views can also be useful to generate keys in several tables, which should be unique. For example, if I have a new item entered in a system and I want to put one row in several tables at a time, then I can hold an ID from a sequence when I insert any number of tables Okay, I know that ID will not already struggle with one price in the tables and there will be only one ID per line.
I think these things are also possible with auto-increment columns.
Comments
Post a Comment