<insert id="insertAccount" parameterClass="Account">
insert into ACCOUNT (
ACC_ID,
ACC_FIRST_NAME,
ACC_LAST_NAME,
ACC_EMAIL)
values (
seq_account.nextval, #firstName#, #lastName#, #emailAddress#
)
<selectKey resultClass="int" keyProperty="id" >
SELECT seq_account.currval AS ID from dual
</selectKey>
</insert>
insert into ACCOUNT (
ACC_ID,
ACC_FIRST_NAME,
ACC_LAST_NAME,
ACC_EMAIL)
values (
seq_account.nextval, #firstName#, #lastName#, #emailAddress#
)
<selectKey resultClass="int" keyProperty="id" >
SELECT seq_account.currval AS ID from dual
</selectKey>
</insert>