Hello, i am used to doing the following in SQL /my insert code here/ SELECT @@IDENTITY AS NewID
And then i can just use NewID Is there an equvalient of this in oralce?
oracle uses sequences. Functions to get values from a sequence:
sequence_name.nextval
sequence_name.currval
Look it up in the docs.
alright, thanks