> > The difference is: > > With a trigger, you hide the details of the sequence from the > insert statement. This makes the insert statement simpler and > more portable. OTOH, you don't know which value you just > inserted (you can get at it with "select $sequence.currval > from dual" but then you lose these advantages).
Look at the returning clause -- then you don't have to issue a second statement.... Jeff
