Hi I'm using PL/SQL to create a table and would like the primary key to be generated by the oracle database every time I enter a new record. Any ideas?. (new boy hence the simple question)
I agree with Simon. This also allows for some flexibility. In that you can get the nextval without inserting an actual record. If for some reason you need that ID first before you want to insert. You would not be able to do that with a trigger. Mark