You're right, somehow I didn't like the fact that that happened...maybe it's just because Oracle was very hard to use for me 15 years ago when I tried it in uni

You're right, somehow I didn't like the fact that that happened...maybe it's just because Oracle was very hard to use for me 15 years ago when I tried it in university (especially compared to open source DBs), but maybe it became much more user friendly since. I remember that while in MySQL I could just set the id field to autoincrement, and in Oracle I had to create a special kind of counter, increment it and read its value to create a new id for example.