I have a sequence that I am using on a field that I am using for the ID
of an item in a table. After an insert to that table, I need to insert
into two other tables using the same ID - does the initial insert
somehow return the value of the sequence that was used? I know it may
not be reliable to do, say "SELECT MAX ID FROM"..., so how can I assure
that I have the right ID for my other inserts? Should I just do the set
of inserts as a transaction?
Thanks,
Bryan