Does anyone know an easy way to insert a record (without a value for the primary key because it is a sequence) and at the same time obtain the value of primary key that was assign to this new record.
I always try insert and then select with the same values that I used for the insert, but I believe this is not a good way to do it.
