Hi I've been looking at the forum for my needs but can't find it.
I'm using spring JDBC and oracle server 8i,
I need to be able to retrieve a field value of the record that I have
inserted. I also need to retrieve the primary key that I have generated
using à sequencer in the before_update trigger of that table.
I saw on the petClinic example that these two databases use
the methods getIdentityQuery()
in hsqlDB, it uses "call identity"
in mysql, it uses "select last_insert_id()"
is there a equivalent in Oracle
or I have to make query to get the record I have inserted?
thanks a lot in advance.